public DataTable updateDTRShiftSchedule(string pEmployeeNo, DateTime pFromDate, DateTime pToDate, string pShiftSchedule) { return(loDailyTimeRecord.updateDTRShiftSchedule(pEmployeeNo, pFromDate, pToDate, pShiftSchedule)); }
private void btnSave_Click(object sender, EventArgs e) { try { if (dtpStartDate.Value.Date < _StarDate.Date || dtpStartDate.Value.Date > _EndDate.Date) { MessageBoxUI _mb = new MessageBoxUI("Start Date must be within Date Range!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mb.showDialog(); dtpStartDate.Focus(); return; } if (dtpEndDate.Value.Date > _EndDate.Date || dtpEndDate.Value.Date < _StarDate.Date) { MessageBoxUI _mb = new MessageBoxUI("End Date must be within Date Range!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mb.showDialog(); dtpEndDate.Focus(); return; } if (dtpEndDate.Value.Date < dtpStartDate.Value.Date) { MessageBoxUI _mb = new MessageBoxUI("End Date must not be lesser than Start Date!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mb.showDialog(); dtpEndDate.Focus(); return; } if (dtpStartDate.Value.Date > dtpEndDate.Value.Date) { MessageBoxUI _mb = new MessageBoxUI("Start Date must not be greater than End Date!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mb.showDialog(); dtpStartDate.Focus(); return; } string _shiftSchedule = ""; if (chkBreak.Checked) { _shiftSchedule = string.Format("{0:hh:mm tt}", dtpTimeIn.Value) + ";" + string.Format("{0:hh:mm tt}", dtpBreakOut.Value) + ";" + string.Format("{0:hh:mm tt}", dtpBreakIn.Value) + ";" + string.Format("{0:hh:mm tt}", dtpTimeOut.Value) + ";ND=" + (chkNextDay.Checked ? "Y" : "N"); } else { _shiftSchedule = string.Format("{0:hh:mm tt}", dtpTimeIn.Value) + ";;;" + string.Format("{0:hh:mm tt}", dtpTimeOut.Value) + ";ND=" + (chkNextDay.Checked ? "Y" : "N"); } loDailyTimeRecord.updateDTRShiftSchedule(_EmployeeNo, dtpStartDate.Value, dtpEndDate.Value, _shiftSchedule); #region "UPDATE DTR TI,BO,BI,TO" foreach (DataRow _drDTR in loDailyTimeRecord.getDailyTimeRecordByDate(_EmployeeNo, dtpStartDate.Value, dtpEndDate.Value).Rows) { try { if (_drDTR["RawDTR"].ToString() != "") { string[] _dtr = _drDTR["RawDTR"].ToString().Split(';'); foreach (string dtr in _dtr) { string[] _shift = _drDTR["ShiftSchedule"].ToString().Split(';'); string _shiftTI = ""; string _shiftBO = ""; string _shiftBI = ""; string _shiftTO = ""; try { _shiftTI = _shift[0]; _shiftBO = _shift[1]; _shiftBI = _shift[2]; _shiftTO = _shift[3]; } catch { continue; } if (dtr != "") { string[] _raw = dtr.Split('='); if (_raw[0].ToString() == "TI") { insertTimeIn(_drDTR["DailyTimeRecordId"].ToString(), _raw[1].ToString()); string _late1 = "00:00"; try { _late1 = string.Format("{0:HH:mm}", DateTime.Parse(DateTime.Parse(_raw[1].ToString()).TimeOfDay.Subtract(DateTime.Parse(_shiftTI).TimeOfDay).ToString())); } catch { _late1 = "00:00"; } if (_late1 != "00:00") { insertLate1(_drDTR["DailyTimeRecordId"].ToString(), _late1); } } else if (_raw[0].ToString() == "BO") { insertBreakOut(_drDTR["DailyTimeRecordId"].ToString(), _raw[1].ToString()); string _undertime1 = "00:00"; try { _undertime1 = string.Format("{0:HH:mm}", DateTime.Parse(DateTime.Parse(_shiftBO).TimeOfDay.Subtract(DateTime.Parse(_raw[1].ToString()).TimeOfDay).ToString())); } catch { _undertime1 = "00:00"; } if (_undertime1 != "00:00") { insertUndertime1(_drDTR["DailyTimeRecordId"].ToString(), _undertime1); } } else if (_raw[0].ToString() == "BI") { /*if (_drDTR["BreakIn"].ToString() == "") * { * foreach (DataRow _drEmpDTR in loDailyTimeRecord.getDailyTimeRecord(_EmployeeNo, DateTime.Parse(_drDTR["Date"].ToString())).Rows) * { * if (_drEmpDTR["BreakIn"].ToString() == "") * {*/ insertBreakIn(_drDTR["DailyTimeRecordId"].ToString(), _raw[1].ToString()); string _late2 = "00:00"; try { _late2 = string.Format("{0:HH:mm}", DateTime.Parse(DateTime.Parse(_raw[1].ToString()).TimeOfDay.Subtract(DateTime.Parse(_shiftBI).TimeOfDay).ToString())); } catch { _late2 = "00:00"; } if (_late2 != "00:00") { insertLate2(_drDTR["DailyTimeRecordId"].ToString(), _late2); } /*} * } * }*/ } else if (_raw[0].ToString() == "TO") { insertTimeOut(_drDTR["DailyTimeRecordId"].ToString(), _raw[1].ToString()); string _undertime2 = "00:00"; try { _undertime2 = string.Format("{0:HH:mm}", DateTime.Parse(DateTime.Parse(_shiftTO).TimeOfDay.Subtract(DateTime.Parse(_raw[1].ToString()).TimeOfDay).ToString())); } catch { _undertime2 = "00:00"; } if (_undertime2 != "00:00") { insertUndertime2(_drDTR["DailyTimeRecordId"].ToString(), _undertime2); } } } } } } catch { continue; } } #endregion "" _lFromSave = true; MessageBoxUI _mb1 = new MessageBoxUI("Shift Schedule has been successfully changed!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb1.showDialog(); this.Close(); } catch { } }