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