Calculating overtime for the Month

if i had 12 hours og overtime for the mo of june ehen i enter july 1st it will show o and start over.

private void btnVacation_Total_Click(object sender, EventArgs e)

{

decimal sum = 0;

for (int i = 0; i < dataGridView1.Rows.Count; ++i)

{

decimal dec = 0;

decimal.TryParse(this.dataGridView1[2, i].FormattedValue.ToString(), out dec);

sum += dec;

}

// sum = (sum);

txtVacation_Total.Text = sum.ToString("");

}

private void btnComp_Total_Click(object sender, EventArgs e)

{

decimal sum = 0;

for (int i = 0; i < dataGridView1.Rows.Count; ++i)

{

decimal dec = 0;

decimal.TryParse(this.dataGridView1[3, i].FormattedValue.ToString(), out dec);

sum += dec;

}

// sum = (sum);

txtComp_Total.Text = sum.ToString("");

}

private void btnOver_Time_Click(object sender, EventArgs e)

{

decimal sum = 0;

for (int i = 0; i < dataGridView1.Rows.Count; ++i)

{

decimal dec = 0;

decimal.TryParse(this.dataGridView1[4, i].FormattedValue.ToString(), out dec);

sum += dec;

}

// sum = (sum);

txtOver_Time.Text = sum.ToString("");

}

private void btnSave_Click(object sender, EventArgs e)

{

try

{

dataBaseBindingSource.EndEdit();

dataBaseTableAdapter.Update(this.attendance_TrackerDataSet.DataBase);

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);

dataBaseBindingSource.ResetBindings(false);

}

private void btnTotal_Click(object sender, EventArgs e)

{

btnComp_Total.PerformClick(); btnOver_Time.PerformClick(); btnVacation_Total.PerformClick();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

james james9y ago
if i had 12 hours og overtime for the mo of june ehen i enter july 1st it will show o and start over.

private void btnVacation_Total_Click(object sender, EventArgs e)
{
decimal sum = 0;
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
decimal dec = 0;
decimal.TryParse(this.dataGridView1[2, i].FormattedValue.ToString(), out dec);
sum += dec;
}
// sum = (sum);
txtVacation_Total.Text = sum.ToString("");
}
private void btnComp_Total_Click(object sender, EventArgs e)
{
decimal sum = 0;
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
decimal dec = 0;
decimal.TryParse(this.dataGridView1[3, i].FormattedValue.ToString(), out dec);
sum += dec;
}
// sum = (sum);
txtComp_Total.Text = sum.ToString("");
}
private void btnOver_Time_Click(object sender, EventArgs e)
{
decimal sum = 0;
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
decimal dec = 0;
decimal.TryParse(this.dataGridView1[4, i].FormattedValue.ToString(), out dec);
sum += dec;
}
// sum = (sum);
txtOver_Time.Text = sum.ToString("");
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
dataBaseBindingSource.EndEdit();
dataBaseTableAdapter.Update(this.attendance_TrackerDataSet.DataBase);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
dataBaseBindingSource.ResetBindings(false);
}
}
private void btnTotal_Click(object sender, EventArgs e)
{
btnComp_Total.PerformClick(); btnOver_Time.PerformClick(); btnVacation_Total.PerformClick();
}
0
Amit Gupta9y ago
Please share a demo data with ezpected output
0