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