protected void Recalculate_Click(object sender, EventArgs e) { ArrayList list = new ArrayList(); foreach (DataListItem item in Repeater.Items) { CheckBox c = (CheckBox)item.FindControl("DeleteItem"); HtmlInputHidden h = (HtmlInputHidden)item.FindControl("AttendanceRecordID"); if (c.Checked) { EAttendanceRecord obj = new EAttendanceRecord(); obj.AttendanceRecordID = Int32.Parse(h.Value); list.Add(obj); } } HROne.Attendance.AttendanceProcess attendanceProcess = new HROne.Attendance.AttendanceProcess(dbConn); WebUtils.StartFunction(Session, FUNCTION_CODE, CurrentEmpID); foreach (EAttendanceRecord obj in list) { EAttendanceRecord.db.select(dbConn, obj); attendanceProcess.GetAttendanceTimeResult(obj); EAttendanceRecord.db.update(dbConn, obj); } WebUtils.EndFunction(dbConn); view = loadData(info, db, Repeater); }
public void LoadAttendanceRecord(int intAttendanceRecordID) { EAttendanceRecord obj = new EAttendanceRecord(); obj.AttendanceRecordID = intAttendanceRecordID; if (EAttendanceRecord.db.select(dbConn, obj)) { Hashtable values = new Hashtable(); EAttendanceRecord.db.populate(obj, values); eBinding.toControl(values); if (obj.AttendanceRecordOverrideBonusEntitled) { if (obj.AttendanceRecordHasBonus) { AttendanceRecordHasBonus.SelectedValue = "Y"; } else { AttendanceRecordHasBonus.SelectedValue = "N"; } } else { AttendanceRecordHasBonus.SelectedValue = ""; } AttendanceRecordRosterCodeInTimeOverride.MaxLength = 0; AttendanceRecordRosterCodeLunchStartTimeOverride.MaxLength = 0; AttendanceRecordRosterCodeLunchEndTimeOverride.MaxLength = 0; AttendanceRecordRosterCodeOutTimeOverride.MaxLength = 0; AttendanceRecordWorkStart.MaxLength = 0; AttendanceRecordLunchOut.MaxLength = 0; AttendanceRecordLunchIn.MaxLength = 0; AttendanceRecordWorkEnd.MaxLength = 0; ERosterCode rosterCode = new ERosterCode(); rosterCode.RosterCodeID = obj.RosterCodeID; ERosterCode.db.select(dbConn, rosterCode); if (rosterCode.RosterClientID > 0) { RosterClientID.SelectedValue = rosterCode.RosterClientID.ToString(); } RefreshClientSite(rosterCode.RosterClientID); if (rosterCode.RosterClientSiteID > 0) { RosterClientSiteID.SelectedValue = rosterCode.RosterClientSiteID.ToString(); } RefreshRosterCode(rosterCode.RosterClientSiteID); } }
protected void ButtonMessageOkay_Click(object sender, EventArgs e) { EAttendanceRecord obj = new EAttendanceRecord(); Hashtable values = new Hashtable(); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); eBinding.toValues(values); db.validate(errors, values); if (!errors.isEmpty()) { AdjustmentModalPopupExtender.Show(); return; } db.parse(values, obj); if (AttendanceRecordHasBonus.SelectedValue.Equals("Y", StringComparison.CurrentCultureIgnoreCase)) { obj.AttendanceRecordOverrideBonusEntitled = true; obj.AttendanceRecordHasBonus = true; } else if (AttendanceRecordHasBonus.SelectedValue.Equals("N", StringComparison.CurrentCultureIgnoreCase)) { obj.AttendanceRecordOverrideBonusEntitled = true; obj.AttendanceRecordHasBonus = false; } else { obj.AttendanceRecordOverrideBonusEntitled = false; obj.AttendanceRecordHasBonus = false; } if (!errors.isEmpty()) { AdjustmentModalPopupExtender.Show(); return; } WebUtils.StartFunction(Session, FUNCTION_CODE, obj.EmpID); db.update(dbConn, obj); WebUtils.EndFunction(dbConn); if (Closed != null) { Closed(sender, e); } }
protected void Repeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { DataRowView row = (DataRowView)e.Item.DataItem; CheckBox cb = (CheckBox)e.Item.FindControl("ItemSelect"); HtmlAnchor requestLink = (HtmlAnchor)e.Item.FindControl("requestLink"); WebFormUtils.LoadKeys(sdb, row, cb); cb.Checked = false; cb.Visible = true; EAttendanceRecord obj = new EAttendanceRecord(); EAttendanceRecord.db.toObject(((DataRowView)e.Item.DataItem).Row, obj); // Start 0000112, Miranda, 2015-01-11 if (hasSubmitted(obj.AttendanceRecordID)) { cb.Visible = false; } // End 0000112, Miranda, 2015-01-11 }
//// Start 0000112, Miranda, 2015-01-11 //private bool hasSubmitLateWaive(int empID, int attendanceRecordID) //{ // DBFilter filter = new DBFilter(); // filter.add(new Match("EmpID", empID)); // filter.add(new Match("AttendanceRecordID", attendanceRecordID)); // ArrayList lwList = ELateWaive.db.select(dbConn, filter); // if (lwList != null && lwList.Count > 0) // { // return true; // } // else // { // return false; // } //} //// End 0000112, Miranda, 2015-01-11 protected void Repeater_ItemCommand(object source, DataListCommandEventArgs e) { Button b = (Button)e.CommandSource; if (b.ID.Equals("Edit")) { int intAttendanceRecordID = 0; if (int.TryParse(((HtmlInputHidden)e.Item.FindControl("AttendanceRecordID")).Value, out intAttendanceRecordID)) { Attendance_AttendanceRecordDetail_Edit1.LoadAttendanceRecord(intAttendanceRecordID); Attendance_AttendanceRecordDetail_Edit1.Show(); } //Repeater.EditItemIndex = e.Item.ItemIndex; //view = loadData(info, db, Repeater); } else if (b.ID.Equals("Cancel")) { Repeater.EditItemIndex = -1; view = loadData(info, db, Repeater); } else if (b.ID.Equals("Save")) { Binding eBinding; eBinding = new Binding(dbConn, db); eBinding.add(EmpID); eBinding.add((HtmlInputHidden)e.Item.FindControl("AttendanceRecordID")); eBinding.add((Label)e.Item.FindControl("AttendanceRecordDate")); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("RosterCodeID"), ERosterCode.VLRosterCode)); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeInTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeLunchStartTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeLunchEndTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeOutTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkStart")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchOut")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchIn")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkEnd")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkStartLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchOutLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchInLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkEndLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLateMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualEarlyLeaveMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchLateMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchEarlyLeaveMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualOvertimeMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchOvertimeMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualWorkingHour")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualWorkingDay")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchTimeMins")); eBinding.add(new CheckBoxBinder(db, (CheckBox)e.Item.FindControl("AttendanceRecordIsAbsent"))); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRemark")); eBinding.init(Request, Session); EAttendanceRecord obj = new EAttendanceRecord(); Hashtable values = new Hashtable(); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); eBinding.toValues(values); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, obj); DropDownList rosterCodeID = ((DropDownList)e.Item.FindControl("AttendanceRecordHasBonus")); if (rosterCodeID.SelectedValue.Equals("Y", StringComparison.CurrentCultureIgnoreCase)) { obj.AttendanceRecordOverrideBonusEntitled = true; obj.AttendanceRecordHasBonus = true; } else if (rosterCodeID.SelectedValue.Equals("N", StringComparison.CurrentCultureIgnoreCase)) { obj.AttendanceRecordOverrideBonusEntitled = true; obj.AttendanceRecordHasBonus = false; } else { obj.AttendanceRecordOverrideBonusEntitled = false; obj.AttendanceRecordHasBonus = false; } if (!errors.isEmpty()) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE, obj.EmpID); db.update(dbConn, obj); WebUtils.EndFunction(dbConn); Repeater.EditItemIndex = -1; view = loadData(info, db, Repeater); } }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.SelectedItem || e.Item.ItemType == ListItemType.EditItem) { EAttendanceRecord obj = new EAttendanceRecord(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); Hashtable values = new Hashtable(); db.populate(obj, values); if (e.Item.ItemIndex == Repeater.EditItemIndex) { Binding eBinding; eBinding = new Binding(dbConn, db); eBinding.add(EmpID); eBinding.add((HtmlInputHidden)e.Item.FindControl("AttendanceRecordID")); eBinding.add((Label)e.Item.FindControl("AttendanceRecordDate")); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("RosterCodeID"), ERosterCode.VLRosterCode)); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeInTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeLunchStartTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeLunchEndTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeOutTimeOverride")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkStart")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchOut")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchIn")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkEnd")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkStartLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchOutLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordLunchInLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordWorkEndLocation")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLateMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualEarlyLeaveMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchLateMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchEarlyLeaveMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualOvertimeMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchOvertimeMins")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualWorkingHour")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualWorkingDay")); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordActualLunchTimeMins")); eBinding.add(new CheckBoxBinder(db, (CheckBox)e.Item.FindControl("AttendanceRecordIsAbsent"))); eBinding.add((TextBox)e.Item.FindControl("AttendanceRecordRemark")); eBinding.init(Request, Session); eBinding.toControl(values); if (obj.AttendanceRecordOverrideBonusEntitled) { if (obj.AttendanceRecordHasBonus) { ((DropDownList)e.Item.FindControl("AttendanceRecordHasBonus")).SelectedValue = "Y"; } else { ((DropDownList)e.Item.FindControl("AttendanceRecordHasBonus")).SelectedValue = "N"; } } else { ((DropDownList)e.Item.FindControl("AttendanceRecordHasBonus")).SelectedValue = ""; } ((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeInTimeOverride")).MaxLength = 0; ((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeLunchStartTimeOverride")).MaxLength = 0; ((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeLunchEndTimeOverride")).MaxLength = 0; ((TextBox)e.Item.FindControl("AttendanceRecordRosterCodeOutTimeOverride")).MaxLength = 0; ((TextBox)e.Item.FindControl("AttendanceRecordWorkStart")).MaxLength = 0; ((TextBox)e.Item.FindControl("AttendanceRecordLunchOut")).MaxLength = 0; ((TextBox)e.Item.FindControl("AttendanceRecordLunchIn")).MaxLength = 0; ((TextBox)e.Item.FindControl("AttendanceRecordWorkEnd")).MaxLength = 0; } else { // Start 0000112, Miranda, 2015-01-11 e.Item.FindControl("Edit").Visible = true & IsAllowEdit; //&& !hasSubmitLateWaive(obj.EmpID, obj.AttendanceRecordID); // End 0000112, Miranda, 2015-01-11 e.Item.FindControl("DeleteItem").Visible = true & IsAllowEdit; Binding eBinding; eBinding = new Binding(dbConn, db); eBinding.add((HtmlInputHidden)e.Item.FindControl("AttendanceRecordID")); eBinding.add(new BlankZeroLabelVLBinder(db, (Label)e.Item.FindControl("RosterCodeID"), ERosterCode.VLRosterCode)); eBinding.init(Request, Session); eBinding.toControl(values); //HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("AttendanceRecordID"); //h.Value = ((DataRowView)e.Item.DataItem)["AttendanceRecordID"].ToString(); if (obj.AttendanceRecordOverrideBonusEntitled) { if (obj.AttendanceRecordHasBonus) { ((Label)e.Item.FindControl("AttendanceRecordHasBonus")).Text = "Yes"; } else { ((Label)e.Item.FindControl("AttendanceRecordHasBonus")).Text = "No"; } } else { ((Label)e.Item.FindControl("AttendanceRecordHasBonus")).Text = "By Attendance Plan"; } } } HROne.Common.WebUtility.WebControlsLocalization(Session, e.Item.Controls); }
protected bool loadObject() { DBFilter filterStatus = new DBFilter(); filterStatus.add(new Match("EmpRequestRecordID", CurRequestID)); filterStatus.add(new Match("EmpRequestType", EEmpRequest.TYPE_EELATEWAIVECANCEL)); ArrayList empRequestList = EEmpRequest.db.select(dbConn, filterStatus); if (empRequestList.Count > 0) { EEmpRequest empRequest = (EEmpRequest)empRequestList[0]; if (empRequest.EmpID == UserID) { string submitStatus = empRequest.EmpRequestStatus; if ((submitStatus.Equals(EEmpRequest.STATUS_SUBMITTED) || submitStatus.Equals(EEmpRequest.STATUS_ACCEPTED)) && !submitStatus.Equals(EEmpRequest.STATUS_APPROVED)) { btnCancel.Visible = true; RejectReasonRow.Visible = false; } else { btnCancel.Visible = false; if (!string.IsNullOrEmpty(empRequest.EmpRequestRejectReason)) { RejectReasonRow.Visible = true; lblRejectReason.Text = empRequest.EmpRequestRejectReason; } else { RejectReasonRow.Visible = false; } } } else { btnCancel.Visible = false; RejectReasonRow.Visible = false; } obj = new ERequestLateWaiveCancel(); obj.RequestLateWaiveCancelID = CurRequestID; if (!db.select(dbConn, obj)) { return(false); } Hashtable lateWaiveCancelValues = new Hashtable(); db.populate(obj, lateWaiveCancelValues); cancelBinding.toControl(lateWaiveCancelValues); ELateWaive LateWaive = new ELateWaive(); LateWaive.LateWaiveID = obj.LateWaiveID; if (!ELateWaive.db.select(dbConn, LateWaive)) { return(false); } EAttendanceRecord aObj = new EAttendanceRecord(); aObj.AttendanceRecordID = LateWaive.AttendanceRecordID; if (sdb.select(dbConn, aObj)) { // Start 0000112, Miranda, 2015-01-17 AttendanceRecordDate.Text = aObj.AttendanceRecordDate.ToString("yyyy-MM-dd"); ERosterCode rcObj = new ERosterCode(); rcObj.RosterCodeID = aObj.RosterCodeID; if (ERosterCode.db.select(dbConn, rcObj)) { RosterCode.Text = rcObj.RosterCode; RosterCodeDesc.Text = rcObj.RosterCodeDesc; RosterCodeInTime.Text = rcObj.RosterCodeInTime.ToString("HH:mm"); RosterCodeOutTime.Text = rcObj.RosterCodeOutTime.ToString("HH:mm"); } AttendanceRecordWorkStart.Text = aObj.AttendanceRecordWorkStart.ToString("HH:mm"); AttendanceRecordWorkEnd.Text = aObj.AttendanceRecordWorkEnd.ToString("HH:mm"); // End 0000112, Miranda, 2015-01-17 AttendanceRecordActualLateMins.Text = aObj.AttendanceRecordActualLateMins.ToString(); } Hashtable LateWaiveValues = new Hashtable(); ELateWaive.db.populate(LateWaive, LateWaiveValues); lateWaiveBinding.toControl(LateWaiveValues); LateWaiveDateToPlaceHolder.Visible = true; Reject.Attributes.Add("onclick", "return confirm(\"" + HROne.Common.WebUtility.GetLocalizedString(CONFIRM_MESSAGE) + "\");"); return(true); } else { return(false); } }