private void btnSave_Click(object sender, EventArgs e) { if (IsCorrectData()) { using (clsShift shift = new clsShift()) { shift.ShiftCode = txtShiftCode.Text; shift.ShiftModeCode = cmbShiftMode.SelectedValue.ToString(); shift.TimeStart = dtpTimeStart.Value; shift.TimeHalf = dtpTimeHalf.Value; shift.TimeEnd = dtpTimeEnd.Value; shift.BreakTimeStart = dtpBreakStart.Value; shift.BreakTimeEnd = dtpBreakEnd.Value; shift.LateTime = dtpLate.Value; shift.UnderTime = dtpUndertime.Value; shift.TotalWorkHours = float.Parse(txtTotalHours.Text); shift.Remarks = txtRemarks.Text; shift.Insert(); } switch (_FormCaller) { case FormCallers.ShiftList: pfrmShiftList.BindShiftList(); break; case FormCallers.HolidayNew: pfrmHolidayNew.BindShiftList(); break; } Close(); } }
private void btnSave_Click(object sender, EventArgs e) { if (IsCorrectData()) { if (MessageBox.Show("Warning: \nModifying shift settings might cause discrepancies on employee's schedule associated with it. \nIt is advisable to create a new shift than to modify/delete existing shift.\n\nAre you sure to continue?", clsMessageBox.MessageBoxText, MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { using (clsShift shift = new clsShift()) { shift.ShiftCode = txtShiftCode.Text; shift.ShiftModeCode = cmbShiftMode.SelectedValue.ToString(); shift.TimeStart = dtpTimeStart.Value; shift.TimeHalf = dtpTimeHalf.Value; shift.TimeEnd = dtpTimeEnd.Value; shift.BreakTimeStart = dtpBreakStart.Value; shift.BreakTimeEnd = dtpBreakEnd.Value; shift.LateTime = dtpLate.Value; shift.UnderTime = dtpUndertime.Value; shift.TotalWorkHours = float.Parse(txtTotalHours.Text); shift.Remarks = txtRemarks.Text; shift.Update(); } pfrmShiftList.BindShiftList(); Close(); } } }
private void dtpDateEnd_ValueChanged(object sender, EventArgs e) { DataTable tblTime = new DataTable(); tblTime.Columns.Add("pvalue"); tblTime.Columns.Add("ptext"); DataRow drw; using (clsShift shift = new clsShift()) { shift.ShiftCode = clsShift.GetDayShiftCode(cmbRequestor.SelectedValue.ToString(), dtpDateEnd.Value); shift.Fill(); drw = tblTime.NewRow(); drw["pvalue"] = ".5"; drw["ptext"] = shift.TimeHalf.ToString("hh:mm tt"); tblTime.Rows.Add(drw); drw = tblTime.NewRow(); drw["pvalue"] = "1"; drw["ptext"] = shift.TimeEnd.ToString("hh:mm tt"); tblTime.Rows.Add(drw); } cmbTimeTo.DataSource = tblTime; cmbTimeTo.ValueMember = "pvalue"; cmbTimeTo.DisplayMember = "ptext"; ComputeUnits(); }
protected void btnDelete_Click(object sender, EventArgs e) { try { StringBuilder strXML = new StringBuilder(); strXML.Append("<ShiftDetails>"); int count = 0; for (int i = 0; i < gvShift.Rows.Count; i++) { try { CheckBox delrows = (CheckBox)gvShift.Rows[i].FindControl("DeleteRows"); HiddenField hdnRowID = (HiddenField)gvShift.Rows[i].FindControl("hdnRowID"); if (delrows.Checked == true) { count++; strXML.Append("<Shift>"); strXML.Append("<RowID>" + hdnRowID.Value + "</RowID>"); strXML.Append("</Shift>"); } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } } strXML.Append("</ShiftDetails>"); clsShift objShift = new clsShift(); objShift.CreatedBy = Session["uid"].ToString(); if (count > 0) { clsShiftViewHandler.UpdateShiftDetails(objShift, "Delete", strXML.ToString(), ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName()); if (strErrMsg.Trim().Length >= 1) { lblMessages.Text = strErrMsg; lblMessages.Visible = true; return; } else { lblMessages.Text = strSuccMsg; lblMessages.Visible = true; BindgvShift(); return; } } else { lblMessages.Text = "Please Select Record"; lblMessages.Visible = true; return; } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
protected void BindDefaultSchedule() { using (clsShift shift = new clsShift()) { shift.ShiftCode = clsShift.GetDayShiftCode(Request.Cookies["Speedo"]["UserName"], dtpOBDate.SelectedDate); shift.Fill(); dtpInTime.SelectedTime = shift.TimeStart; dtpOutTime.SelectedTime = shift.TimeEnd; } }
private void SetTimeInOut() { using (clsShift shift = new clsShift()) { shift.ShiftCode = clsShift.GetDayShiftCode(cmbUsername.SelectedValue.ToString(), dtpFocusDate.Value); shift.Fill(); dtpInTime.Value = shift.TimeStart; dtpOutTime.Value = shift.TimeEnd; } }
protected void txtDateTo_TextChanged(object sender, EventArgs e) { ddlToTime.Items.Clear(); clsShift shift = new clsShift(); shift.ShiftCode = clsShift.GetDayShiftCode(_strUsername, Convert.ToDateTime(dtpTo.SelectedDate)); shift.Fill(); ddlToTime.Items.Add(new ListItem(shift.TimeHalf.ToString("hh:mm tt"), ".5")); ddlToTime.Items.Add(new ListItem(shift.TimeEnd.ToString("hh:mm tt"), "1")); ComputeUnits(); }
private void btnInclude_Click(object sender, EventArgs e) { if (lvExcluded.SelectedItems.Count > 0) { bool blnInsertLeave = false; bool blnHasBalance = LeaveApplicationTypes.IsHasBalance(cmbLeaveType.SelectedValue.ToString()); string strLeaveCode = ""; string strUsername = lvExcluded.SelectedItems[0].Tag.ToString(); DateTime dteDateStart = DateTime.Now; DateTime dteDateEnd = DateTime.Now; using (clsShift shift = new clsShift()) { shift.ShiftCode = clsShift.GetDayShiftCode(strUsername, clsDateTime.GetDateOnly(dtpDateApplied.Value)); shift.Fill(); dteDateStart = clsDateTime.CombineDateTime(dtpDateApplied.Value, shift.TimeStart); dteDateEnd = clsDateTime.CombineDateTime(dtpDateApplied.Value, shift.TimeEnd); } if ((clsValidator.CheckFloat(lvExcluded.SelectedItems[0].SubItems[1].Text) >= 1) || (!blnHasBalance)) { using (LeaveApplication leave = new LeaveApplication()) { leave.LeaveType = cmbLeaveType.SelectedValue.ToString(); leave.Requestor = strUsername; leave.DateFile = DateTime.Now; leave.DateStart = dteDateStart; leave.DateEnd = dteDateEnd; leave.Units = 1; leave.Reason = txtReason.Text; leave.Approver = HRMSCore.Username; leave.ApproverDate = DateTime.Now; leave.ApproverRemarks = "CDL Application. Auto-generated"; leave.Status = "A"; blnInsertLeave = leave.InsertAdmin(); strLeaveCode = leave.LeaveCode; } if (blnHasBalance && blnInsertLeave) { LeaveApplicationBalance.DeductLeaveBalance(1, strUsername, cmbLeaveType.SelectedValue.ToString()); } if (blnInsertLeave) { CDL.InsertMember(_strCDLCode, strUsername, strLeaveCode); this.BindList(); } } else { MessageBox.Show(lvExcluded.SelectedItems[0].Tag.ToString() + " has not enough balance.", clsMessageBox.MessageBoxText, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
protected void txtDateFrom_TextChanged(object sender, EventArgs e) { ddlFromTime.Items.Clear(); using (clsShift shift = new clsShift()) { shift.ShiftCode = clsShift.GetDayShiftCode(_strUsername, Convert.ToDateTime(dtpFrom.SelectedDate)); shift.Fill(); ddlFromTime.Items.Add(new ListItem(shift.TimeStart.ToString("hh:mm tt"), "0")); ddlFromTime.Items.Add(new ListItem(shift.TimeHalf.ToString("hh:mm tt"), ".5")); } ComputeUnits(); }
private void tbtnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Warning: \nDeleting shift settings might cause discrepancies on employee's schedule associated with it. \nIt is advisable to disable the shift than to delete it.\n\nAre you sure to continue?", clsMessageBox.MessageBoxText, MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { if (dgShiftList.SelectedRows.Count > 0) { clsShift shift = new clsShift(); shift.ShiftCode = dgShiftList.SelectedRows[0].Cells[0].Value.ToString(); shift.Delete(); BindShiftList(); } } }
private void InitializeFields() { dtpFocusDate.Value = DateTime.Now; dtpInDate.Value = DateTime.Now; dtpOutDate.Value = DateTime.Now; using (clsShift shift = new clsShift()) { shift.ShiftCode = clsShift.GetDayShiftCode(OfficialBusiness.GetRequestor(_strOBCode), DateTime.Now); shift.Fill(); dtpInTime.Value = shift.TimeStart; dtpOutTime.Value = shift.TimeEnd; } }
private void dtpFocusDate_ValueChanged(object sender, EventArgs e) { try { dtpInDate.Value = dtpFocusDate.Value; dtpOutDate.Value = dtpFocusDate.Value; using (clsShift shift = new clsShift()) { shift.ShiftCode = clsShift.GetDayShiftCode(OfficialBusiness.GetRequestor(_strOBCode), dtpFocusDate.Value); shift.Fill(); dtpInTime.Value = shift.TimeStart; dtpOutTime.Value = shift.TimeEnd; } } catch { } }
private void frmShiftDetails_Load(object sender, EventArgs e) { lblShiftCode.Text = strShiftCode; using (clsShift shift = new clsShift(strShiftCode)) { shift.Fill(); lblWorking.Text = (shift.ShiftModeCode == "W" ? "Yes" : "No"); lblTimeStart.Text = shift.TimeStart.ToString("hh:mm tt"); lblTimeHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); lblTimeEnd.Text = shift.TimeEnd.ToString("hh:mm tt"); lblBreakStart.Text = shift.BreakTimeStart.ToString("hh:mm tt"); lblBreakEnd.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); lblLate.Text = shift.LateTime.ToString("hh:mm tt"); lblUndertime.Text = shift.UnderTime.ToString("hh:mm tt"); lblRemarks.Text = shift.Remarks; lblTotalWorkingHours.Text = shift.TotalWorkHours.ToString(); } }
private void BindFields() { cmbShiftMode.DataSource = clsShiftMode.GetDdlDs(); cmbShiftMode.ValueMember = "pvalue"; cmbShiftMode.DisplayMember = "ptext"; using (clsShift shift = new clsShift(strShiftCode)) { shift.Fill(); txtShiftCode.Text = strShiftCode; cmbShiftMode.SelectedValue = shift.ShiftModeCode; dtpTimeStart.Value = shift.TimeStart; dtpTimeHalf.Value = shift.TimeHalf; dtpTimeEnd.Value = shift.TimeEnd; dtpBreakStart.Value = shift.BreakTimeStart; dtpBreakEnd.Value = shift.BreakTimeEnd; dtpLate.Value = shift.LateTime; dtpUndertime.Value = shift.UnderTime; txtTotalHours.Text = shift.TotalWorkHours.ToString(); txtRemarks.Text = shift.Remarks; } txtShiftCode.Focus(); }
private void LoadScheduleDetails(string pScheduleCode) { using (clsSchedule schedule = new clsSchedule(pScheduleCode)) { schedule.Fill(); txtMonShift.Text = schedule.MondayShift; txtTueShift.Text = schedule.TuesdayShift; txtWedShift.Text = schedule.WednesdayShift; txtThuShift.Text = schedule.ThursdayShift; txtFriShift.Text = schedule.FridayShift; txtSatShift.Text = schedule.SaturdayShift; txtSunShift.Text = schedule.SundayShift; } Color clr = new Color(); clsShift shift; #region " Monday " shift = new clsShift(); shift.ShiftCode = txtMonShift.Text; shift.Fill(); txtMonBS.Text = shift.BreakTimeStart.ToString("hh:mm tt"); txtMonBE.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); if (shift.ShiftModeCode == "W") { txtMonIn.Text = shift.TimeStart.ToString("hh:mm tt"); txtMonHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); txtMonOut.Text = shift.TimeEnd.ToString("hh:mm tt"); txtMonLate.Text = shift.LateTime.ToString("hh:mm tt"); txtMonUT.Text = shift.UnderTime.ToString("hh:mm tt"); } clr = (shift.ShiftModeCode == "W" ? Color.Honeydew : Color.MistyRose); txtMonShift.BackColor = clr; txtMonIn.BackColor = clr; txtMonHalf.BackColor = clr; txtMonOut.BackColor = clr; txtMonBS.BackColor = clr; txtMonBE.BackColor = clr; txtMonLate.BackColor = clr; txtMonUT.BackColor = clr; #endregion #region " Tuesday " shift = new clsShift(); shift.ShiftCode = txtTueShift.Text; shift.Fill(); txtTueBS.Text = shift.BreakTimeStart.ToString("hh:mm tt"); txtTueBE.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); if (shift.ShiftModeCode == "W") { txtTueIn.Text = shift.TimeStart.ToString("hh:mm tt"); txtTueHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); txtTueOut.Text = shift.TimeEnd.ToString("hh:mm tt"); txtTueLate.Text = shift.LateTime.ToString("hh:mm tt"); txtTueUT.Text = shift.UnderTime.ToString("hh:mm tt"); } clr = (shift.ShiftModeCode == "W" ? Color.Honeydew : Color.MistyRose); txtTueShift.BackColor = clr; txtTueIn.BackColor = clr; txtTueHalf.BackColor = clr; txtTueOut.BackColor = clr; txtTueBS.BackColor = clr; txtTueBE.BackColor = clr; txtTueLate.BackColor = clr; txtTueUT.BackColor = clr; #endregion #region " Wednesday " shift = new clsShift(); shift.ShiftCode = txtWedShift.Text; shift.Fill(); txtWedBS.Text = shift.BreakTimeStart.ToString("hh:mm tt"); txtWedBE.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); if (shift.ShiftModeCode == "W") { txtWedIn.Text = shift.TimeStart.ToString("hh:mm tt"); txtWedHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); txtWedOut.Text = shift.TimeEnd.ToString("hh:mm tt"); txtWedLate.Text = shift.LateTime.ToString("hh:mm tt"); txtWedUT.Text = shift.UnderTime.ToString("hh:mm tt"); } clr = (shift.ShiftModeCode == "W" ? Color.Honeydew : Color.MistyRose); txtWedShift.BackColor = clr; txtWedIn.BackColor = clr; txtWedHalf.BackColor = clr; txtWedOut.BackColor = clr; txtWedBS.BackColor = clr; txtWedBE.BackColor = clr; txtWedLate.BackColor = clr; txtWedUT.BackColor = clr; #endregion #region " Thursday " shift = new clsShift(); shift.ShiftCode = txtThuShift.Text; shift.Fill(); txtThuBS.Text = shift.BreakTimeStart.ToString("hh:mm tt"); txtThuBE.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); if (shift.ShiftModeCode == "W") { txtThuIn.Text = shift.TimeStart.ToString("hh:mm tt"); txtThuHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); txtThuOut.Text = shift.TimeEnd.ToString("hh:mm tt"); txtThuLate.Text = shift.LateTime.ToString("hh:mm tt"); txtThuUT.Text = shift.UnderTime.ToString("hh:mm tt"); } clr = (shift.ShiftModeCode == "W" ? Color.Honeydew : Color.MistyRose); txtThuShift.BackColor = clr; txtThuIn.BackColor = clr; txtThuHalf.BackColor = clr; txtThuOut.BackColor = clr; txtThuBS.BackColor = clr; txtThuBE.BackColor = clr; txtThuLate.BackColor = clr; txtThuUT.BackColor = clr; #endregion #region " Friday " shift = new clsShift(); shift.ShiftCode = txtFriShift.Text; shift.Fill(); txtFriBS.Text = shift.BreakTimeStart.ToString("hh:mm tt"); txtFriBE.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); if (shift.ShiftModeCode == "W") { txtFriIn.Text = shift.TimeStart.ToString("hh:mm tt"); txtFriHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); txtFriOut.Text = shift.TimeEnd.ToString("hh:mm tt"); txtFriLate.Text = shift.LateTime.ToString("hh:mm tt"); txtFriUT.Text = shift.UnderTime.ToString("hh:mm tt"); } clr = (shift.ShiftModeCode == "W" ? Color.Honeydew : Color.MistyRose); txtFriShift.BackColor = clr; txtFriIn.BackColor = clr; txtFriHalf.BackColor = clr; txtFriOut.BackColor = clr; txtFriBS.BackColor = clr; txtFriBE.BackColor = clr; txtFriLate.BackColor = clr; txtFriUT.BackColor = clr; #endregion #region " Saturday " shift = new clsShift(); shift.ShiftCode = txtSatShift.Text; shift.Fill(); txtSatBS.Text = shift.BreakTimeStart.ToString("hh:mm tt"); txtSatBE.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); if (shift.ShiftModeCode == "W") { txtSatIn.Text = shift.TimeStart.ToString("hh:mm tt"); txtSatHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); txtSatOut.Text = shift.TimeEnd.ToString("hh:mm tt"); txtSatLate.Text = shift.LateTime.ToString("hh:mm tt"); txtSatUT.Text = shift.UnderTime.ToString("hh:mm tt"); } clr = (shift.ShiftModeCode == "W" ? Color.Honeydew : Color.MistyRose); txtSatShift.BackColor = clr; txtSatIn.BackColor = clr; txtSatHalf.BackColor = clr; txtSatOut.BackColor = clr; txtSatBS.BackColor = clr; txtSatBE.BackColor = clr; txtSatLate.BackColor = clr; txtSatUT.BackColor = clr; #endregion #region " Sunday " shift = new clsShift(); shift.ShiftCode = txtSunShift.Text; shift.Fill(); txtSunBS.Text = shift.BreakTimeStart.ToString("hh:mm tt"); txtSunBE.Text = shift.BreakTimeEnd.ToString("hh:mm tt"); if (shift.ShiftModeCode == "W") { txtSunIn.Text = shift.TimeStart.ToString("hh:mm tt"); txtSunHalf.Text = shift.TimeHalf.ToString("hh:mm tt"); txtSunOut.Text = shift.TimeEnd.ToString("hh:mm tt"); txtSunLate.Text = shift.LateTime.ToString("hh:mm tt"); txtSunUT.Text = shift.UnderTime.ToString("hh:mm tt"); } clr = (shift.ShiftModeCode == "W" ? Color.Honeydew : Color.MistyRose); txtSunShift.BackColor = clr; txtSunIn.BackColor = clr; txtSunHalf.BackColor = clr; txtSunOut.BackColor = clr; txtSunBS.BackColor = clr; txtSunBE.BackColor = clr; txtSunLate.BackColor = clr; txtSunUT.BackColor = clr; #endregion }
protected void Modify_Data(string ShiftID) { try { Shft_id.Enabled = false; _oldshift = clsShiftViewHandler.GetShiftDetails("EditFill", ShiftID); if (_oldshift != null) { Shft_id.Text = _oldshift.SHIFT_ID; Shft_desc.Text = _oldshift.SHIFT_DESCRIPTION; RBShiftALType.SelectedValue = _oldshift.SHIFT_ALLOCATION_TYPE; if (RBShiftALType.SelectedValue == "AUTO") { ASStartTime.Enabled = true; ASEndTime.Enabled = true; } else { ASStartTime.Enabled = false; ASEndTime.Enabled = false; } ASStartTime.Text = _oldshift.SHIFT_AUTO_SEARCH_START; ASEndTime.Text = _oldshift.SHIFT_AUTO_SEARCH_END; Shft_Type.SelectedValue = _oldshift.SHIFT_TYPE; Shft_Type.Enabled = false; Shft_Frm.Text = _oldshift.SHIFT_START; Shft_To.Text = _oldshift.SHIFT_END; Lnch_Frm.Text = _oldshift.SHIFT_BREAK_START; Lnch_To.Text = _oldshift.SHIFT_BREAK_END; Tot_BrHr.Text = _oldshift.SHIFT_BREAK_HRS; hdnTot_BrHr.Value = _oldshift.SHIFT_BREAK_HRS; Tot_WrKHr.Text = _oldshift.SHIFT_WORKHRS; hdnTot_WrKHr.Value = _oldshift.SHIFT_WORKHRS; if (_oldshift.SHIFT_FLAG_ADD_BREAK == true) { ChkShft.Checked = true; } else { ChkShft.Checked = false; } if (_oldshift.SHIFT_WEEKEND_DIFF_TIME == true) { WChkShft1.Checked = true; WShft_Frm.Enabled = true; WShft_To.Enabled = true; WLnch_Frm.Enabled = true; WLnch_To.Enabled = true; } else { WChkShft1.Checked = false; WShft_Frm.Enabled = false; WShft_To.Enabled = false; WLnch_Frm.Enabled = false; WLnch_To.Enabled = false; } WShft_Frm.Text = _oldshift.SHIFT_WEEKEND_START; WShft_To.Text = _oldshift.SHIFT_WEEKEND_END; WLnch_Frm.Text = _oldshift.SHIFT_WEEKEND_BREAK_START; WLnch_To.Text = _oldshift.SHIFT_WEEKEND_BREAK_END; EarlySearchHours.Text = _oldshift.SHIFT_EARLY_SEARCH_HRS; LateSearchHours.Text = _oldshift.SHIFT_LATE_SEARCH_HRS; } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());; } }