Calculating overtime for the Month

Question

I have a simple data grid that track vacation, comp time and overtime. All is working well with the exception of the overtime. I can find a example of clearing the overtime at the end of the mo. and start over. Please help thanks

james james · Answer

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 { 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 { 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 { 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(); }

Amit Gupta · Answer

Please share a demo data with ezpected output

Calculating overtime for the Month

Answers (2)