private void LoadDRTEnrollee(JEnrollee en, Miscellaneous misc)
{
Cursor = Cursors.WaitCursor;
if (listBox1.Items.Count > 0)
{
var eName = en.GetFullName;
Enrollee enrollee = ActionClass.GetEnrollee(en.EnrolleeId);
List <JDTR> lDTRSource01 = DataManagementClass.LoadDTRViaDTRBatch(enrollee, iMonth, iStartDay, iEndDay, iYear, ActionClass.FillDTRs(en.EnrolleeId), misc, eName, labelDuration.Text);
lDTRSource.AddRange(lDTRSource01);
}
Cursor = Cursors.Default;
}
private void LoadDRTEnrolleeId()
{
Cursor = Cursors.WaitCursor;
if (listBoxEnrollees.Items.Count > 0)
{
textBoxName.Text = listBoxEnrollees.Text;
iMonth = toolStripComboBoxMonth.SelectedIndex + 1;
iYear = int.Parse(toolStripComboBoxDuration.Text);
textBoxDepartment.Text = GetEnrolleeDepartment();
textBoxPosition.Text = GetEnrolleePosition();
Miscellaneous misc = ActionClass.FillMiscellaneous().FirstOrDefault(mi => mi.MiscActive == true);
int iEnrolleeId = ((JEnrollee)listBoxEnrollees.SelectedItem).EnrolleeId;
Enrollee enrollee = ActionClass.GetEnrollee(iEnrolleeId);
lDTRSource = DataManagementClass.LoadDTRViaDTR(enrollee, iMonth, iYear, ActionClass.FillDTRs(iEnrolleeId), misc);
dTRsBindingSource.DataSource = lDTRSource;
ExecuteSaveDTRThread(); // loop to save dtr.
MarkUnderOverTimeHours();
}
Cursor = Cursors.Default;
}
private void dTRBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
if (dTRBindingSource != null)
{
this.Validate();
dTRBindingSource.EndEdit();
List <DTR> lDtr1 = ActionClass.FillDTRs(OEnrollee.EnrolleeId, IMonth, IYear);
var lDtr2 = new List <DTR>();
foreach (var dtr in lDTR)
{
DTR d = lDtr1.FirstOrDefault(dt => (dt.DTRDate == dtr.DTRDate));
if (d == null)
{
dtr.IsSource = false;
dtr.EditedBy = SUserName;
dtr.EditedOn = DateTime.Now;
lDtr2.Add(dtr);
}
else
{
string tempTimeInAM = (d.TimeInAM != null) ? d.TimeInAM.Trim() : null;
string tempTimeOutAM = (d.TimeOutAM != null) ? d.TimeOutAM.Trim() : null;
string tempTimeInPM = (d.TimeInPM != null) ? d.TimeInPM.Trim() : null;
string tempTimeOutPM = (d.TimeOutPM != null) ? d.TimeOutPM.Trim() : null;
string tempTimeInOT = (d.TimeInOT != null) ? d.TimeInOT.Trim() : null;
string tempTimeOutOT = (d.TimeOutOT != null) ? d.TimeOutOT.Trim() : null;
if ((tempTimeInAM != dtr.TimeInAM) || (tempTimeOutAM != dtr.TimeOutAM) ||
(tempTimeInPM != dtr.TimeInPM) || (tempTimeOutPM != dtr.TimeOutPM) ||
(tempTimeInOT != dtr.TimeInOT) || (tempTimeOutOT != dtr.TimeOutOT))
{
dtr.IsSource = false;
dtr.EditedBy = SUserName;
dtr.EditedOn = DateTime.Now;
dtr.DTRId = d.DTRId;
ActionClass.SaveDTR(dtr);
}
}
}
if (lDtr2.Count > 0)
{
int iResult = ActionClass.SaveDTR(lDtr2);
if (iResult > 0)
{
toolStripStatusLabel1.Text = "Record successfully saved. (" + lDtr2.Count.ToString() +
" record)";
Thread.Sleep(200);
Application.DoEvents();
}
else
{
toolStripStatusLabel1.Text = "Error Occured while saving data to database or duplicate record already exists.";
}
}
else
{
toolStripStatusLabel1.Text = "Record already exists.";
}
}
Cursor.Current = Cursors.Default;
}
