public CompensationLeaveBalanceProcess(DatabaseConnection dbConn, int EmpID)
: base(dbConn, EmpID, 0)
{
EntitlePeriodUnit = "Y";
m_LeaveTypeID = ELeaveType.COMPENSATION_LEAVE_TYPE(dbConn).LeaveTypeID;
m_BalanceUnit = ELeaveBalance.LeaveBalanceUnit.Hour;
}
protected bool loadObject()
{
obj = new ELeaveApplication();
obj.LeaveAppID = CurLeaveAppID;
if (!ELeaveApplication.db.select(dbConn, obj))
{
return(false);
}
if (obj.EmpID != UserID)
{
return(false);
}
Hashtable values = new Hashtable();
ELeaveApplication.db.populate(obj, values);
leaveApplicationBinding.toControl(values);
//EEmpPersonalInfo EmpInfo = new EEmpPersonalInfo();
//EmpInfo.EmpID = obj.EmpID;
//if (EEmpPersonalInfo.db.select(dbConn, EmpInfo))
// EmpName.Text = EmpInfo.EmpNo + " - " + EmpInfo.EmpEngFullNameWithAlias;
if (obj.LeaveAppUnit.Equals("D"))
{
TimeRow.Visible = false;
LeaveAppDateToPlaceHolder.Visible = true;
}
else
{
TimeRow.Visible = true;
LeaveAppDateToPlaceHolder.Visible = false;
}
string leaveAuthorizedMessage = CONFIRM_MESSAGE;
ELeaveCode leaveCode = new ELeaveCode();
leaveCode.LeaveCodeID = obj.LeaveCodeID;
if (ELeaveCode.db.select(dbConn, leaveCode))
{
LeaveCodeIsShowMedicalCertOptionPanel.Visible = leaveCode.LeaveCodeIsShowMedicalCertOption;
if (leaveCode.LeaveTypeID.Equals(ELeaveType.COMPENSATION_LEAVE_TYPE(dbConn).LeaveTypeID))
{
HoursClaimPanel.Visible = true;
}
else
{
HoursClaimPanel.Visible = false;
}
}
else
{
HoursClaimPanel.Visible = false;
}
return(true);
}
protected void RefreshLeaveCodeID()
{
HoursClaimPanel.Visible = false;
if (!string.IsNullOrEmpty(LeaveCodeID.SelectedValue))
{
int tmpLeaveCodeID = 0;
if (int.TryParse(LeaveCodeID.SelectedValue, out tmpLeaveCodeID))
{
ELeaveCode leaveCode = new ELeaveCode();
leaveCode.LeaveCodeID = tmpLeaveCodeID;
if (ELeaveCode.db.select(dbConn, leaveCode))
{
PayrollProcessPanel.Visible = !leaveCode.LeaveCodeIsSkipPayrollProcess;
LeaveCodeIsShowMedicalCertOptionPanel.Visible = leaveCode.LeaveCodeIsShowMedicalCertOption;
if (!leaveCode.LeaveCodeIsSkipPayrollProcess)
{
ELeaveApplication leaveApp = new ELeaveApplication();
leaveApp.LeaveAppID = CurID;
if (ELeaveApplication.db.select(dbConn, leaveApp))
{
ELeaveCode prevLeaveCode = new ELeaveCode();
prevLeaveCode.LeaveCodeID = leaveApp.LeaveCodeID;
if (ELeaveCode.db.select(dbConn, prevLeaveCode))
{
if (prevLeaveCode.LeaveCodeIsSkipPayrollProcess)
{
LeaveAppNoPayProcess.Checked = false;
}
}
}
}
if (leaveCode.LeaveTypeID.Equals(ELeaveType.COMPENSATION_LEAVE_TYPE(dbConn).LeaveTypeID))
{
HoursClaimPanel.Visible = true;
}
else
{
HoursClaimPanel.Visible = false;
}
}
}
}
if (HoursClaimPanel.Visible)
{
LeaveAppDays.AutoPostBack = true;
LeaveAppDays.TextChanged += new EventHandler(LeaveAppDays_TextChanged);
}
else
{
LeaveAppDays.AutoPostBack = false;
LeaveAppDays.TextChanged -= new EventHandler(LeaveAppDays_TextChanged);
}
}
protected bool loadObject()
{
obj = new ELeaveApplication();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", CurEmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
if (EEmpPersonalInfo.db.count(dbConn, filter) == 0)
{
if (CurEmpID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (!db.select(dbConn, obj))
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (obj.EmpID != CurEmpID)
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
Hashtable values = new Hashtable();
db.populate(obj, values);
//int empPayrollID = int.Parse((string)values["EmpPayrollID"]);
if (obj.EmpPayrollID > 0)
{
EEmpPayroll empPayroll = new EEmpPayroll();
empPayroll.EmpPayrollID = obj.EmpPayrollID;
if (EEmpPayroll.db.select(dbConn, empPayroll))
{
values.Add("PayPeriodID", empPayroll.PayPeriodID.ToString());
}
}
binding.toControl(values);
if (obj.LeaveAppUnit.Equals("D"))
{
TimeRow.Visible = false;
LeaveAppDateToPlaceHolder.Visible = true;
}
else
{
TimeRow.Visible = true;
LeaveAppDateToPlaceHolder.Visible = false;
}
if (obj.EmpPaymentID != 0 || obj.EmpPayrollID != 0)
{
toolBar.EditButton_Visible = false;
toolBar.DeleteButton_Visible = false;
toolBar.CustomButton1_Visible = true;
toolBar.CustomButton2_Visible = true;
}
else
{
toolBar.EditButton_Visible = true;
toolBar.DeleteButton_Visible = true;
toolBar.CustomButton1_Visible = false;
toolBar.CustomButton2_Visible = false;
}
if (obj.LeaveAppCancelID > 0)
{
toolBar.EditButton_Visible = false;
toolBar.DeleteButton_Visible = false;
toolBar.CustomButton1_Visible = false;
toolBar.CustomButton2_Visible = false;
}
ELeaveCode leaveCode = new ELeaveCode();
leaveCode.LeaveCodeID = obj.LeaveCodeID;
if (ELeaveCode.db.select(dbConn, leaveCode))
{
PayrollProcessPanel.Visible = !leaveCode.LeaveCodeIsSkipPayrollProcess;
LeaveCodeIsShowMedicalCertOptionPanel.Visible = leaveCode.LeaveCodeIsShowMedicalCertOption;
//if (!leaveCode.LeaveCodeIsSkipPayrollProcess)
//{
// ELeaveApplication leaveApp = new ELeaveApplication();
// leaveApp.LeaveAppID = CurID;
// if (ELeaveApplication.db.select(dbConn, leaveApp))
// {
// ELeaveCode prevLeaveCode = new ELeaveCode();
// prevLeaveCode.LeaveCodeID = leaveApp.LeaveCodeID;
// if (ELeaveCode.db.select(dbConn, prevLeaveCode))
// if (prevLeaveCode.LeaveCodeIsSkipPayrollProcess)
// LeaveAppNoPayProcess.Checked = false;
// }
//}
if (leaveCode.LeaveTypeID.Equals(ELeaveType.COMPENSATION_LEAVE_TYPE(dbConn).LeaveTypeID))
{
HoursClaimPanel.Visible = true;
}
else
{
HoursClaimPanel.Visible = false;
}
}
else
{
HoursClaimPanel.Visible = false;
}
CurEmpID = obj.EmpID;
return(true);
}
protected bool loadObject()
{
DBFilter filterStatus = new DBFilter();
filterStatus.add(new Match("EmpRequestRecordID", CurRequestID));
filterStatus.add(new Match("EmpRequestType", EEmpRequest.TYPE_EELEAVEAPP));
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;
// Start 0000063, KuangWei, 2014-08-25
if (!string.IsNullOrEmpty(empRequest.EmpRequestRejectReason))
{
RejectReasonRow.Visible = true;
lblReject.Visible = false;
lblAuthorize.Visible = true;
lblRejectReason.Text = empRequest.EmpRequestRejectReason;
}
else
{
RejectReasonRow.Visible = false;
}
// End 0000063, KuangWei, 2014-08-25
}
else
{
btnCancel.Visible = false;
if (!string.IsNullOrEmpty(empRequest.EmpRequestRejectReason))
{
RejectReasonRow.Visible = true;
// Start 0000063, KuangWei, 2014-08-25
lblReject.Visible = true;
lblAuthorize.Visible = false;
// End 0000063, KuangWei, 2014-08-25
lblRejectReason.Text = empRequest.EmpRequestRejectReason;
}
else
{
RejectReasonRow.Visible = false;
}
}
}
else
{
btnCancel.Visible = false;
RejectReasonRow.Visible = false;
}
obj = new ERequestLeaveApplication();
obj.RequestLeaveAppID = CurRequestID;
if (!db.select(dbConn, obj))
{
return(false);
}
Emp_LeaveBalance_List1.EmpID = obj.EmpID;
Emp_LeaveBalance_List1.AsOfDate = obj.RequestLeaveAppDateFrom;
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
//EEmpPersonalInfo EmpInfo = new EEmpPersonalInfo();
//EmpInfo.EmpID = obj.EmpID;
//if (EEmpPersonalInfo.db.select(dbConn, EmpInfo))
// EmpName.Text = EmpInfo.EmpNo + " - " + EmpInfo.EmpEngFullNameWithAlias;
if (obj.RequestLeaveAppUnit.Equals("D"))
{
TimeRow.Visible = false;
LeaveAppDateToPlaceHolder.Visible = true;
}
else
{
TimeRow.Visible = true;
LeaveAppDateToPlaceHolder.Visible = false;
}
string leaveAuthorizedMessage = CONFIRM_MESSAGE;
ELeaveCode leaveCode = new ELeaveCode();
leaveCode.LeaveCodeID = obj.RequestLeaveCodeID;
if (ELeaveCode.db.select(dbConn, leaveCode))
{
LeaveCodeIsShowMedicalCertOptionPanel.Visible = leaveCode.LeaveCodeIsShowMedicalCertOption;
if (leaveCode.LeaveTypeID.Equals(ELeaveType.COMPENSATION_LEAVE_TYPE(dbConn).LeaveTypeID))
{
HoursClaimPanel.Visible = true;
}
else
{
HoursClaimPanel.Visible = false;
}
if (leaveCode.LeaveTypeID.Equals(ELeaveType.ANNUAL_LEAVE_TYPE(dbConn).LeaveTypeID))
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = obj.EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
if (AppUtils.ServerDateTime().Date <= empInfo.EmpProbaLastDate || obj.RequestLeaveAppDateFrom <= empInfo.EmpProbaLastDate)
{
leaveAuthorizedMessage = AL_AUTHORIZED_BEFORE_PROBATION_MESSAGE;
}
}
}
}
else
{
HoursClaimPanel.Visible = false;
}
Authorize.Attributes.Add("onclick", "return confirm(\"" + HROne.Common.WebUtility.GetLocalizedString(leaveAuthorizedMessage) + "\");");
Reject.Attributes.Add("onclick", "return confirm(\"" + HROne.Common.WebUtility.GetLocalizedString(CONFIRM_MESSAGE) + "\");");
return(true);
}
else
{
return(false);
}
}
protected void Save_Click(object sender, EventArgs e)
{
ECompensationLeaveEntitle c = new ECompensationLeaveEntitle();
if (string.IsNullOrEmpty(CompensationLeaveEntitleClaimPeriodTo.Value))
{
CompensationLeaveEntitleClaimPeriodTo.Value = CompensationLeaveEntitleClaimPeriodFrom.Value;
}
Hashtable values = new Hashtable();
binding.toValues(values);
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
db.validate(errors, values);
if (!errors.isEmpty())
{
return;
}
db.parse(values, c);
if (!errors.isEmpty())
{
return;
}
ELeaveType compensationLeaveType = ELeaveType.COMPENSATION_LEAVE_TYPE(dbConn);
WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID);
LeaveBalanceCalc leaaveBalCal = new LeaveBalanceCalc(dbConn, c.EmpID);
if (CurID < 0)
{
// Utils.MarkCreate(Session, c);
db.insert(dbConn, c);
CurID = c.CompensationLeaveEntitleID;
//if (compensationLeaveType != null)
// leaaveBalCal.RecalculateAfter(c.CompensationLeaveEntitleEffectiveDate, compensationLeaveType.LeaveTypeID);
//else
// leaaveBalCal.RecalculateAfter(c.CompensationLeaveEntitleEffectiveDate);
// url = Utils.BuildURL(-1, CurID);
}
else
{
// Utils.Mark(Session, c);
//ECompensationLeaveEntitle leaveBalApp = new ECompensationLeaveEntitle();
//leaveBalApp.CompensationLeaveEntitleID = CurID;
//db.select(dbConn, leaveBalApp);
db.update(dbConn, c);
//if (compensationLeaveType != null)
// leaaveBalCal.RecalculateAfter(leaveBalApp.CompensationLeaveEntitleEffectiveDate < c.CompensationLeaveEntitleEffectiveDate ? leaveBalApp.CompensationLeaveEntitleEffectiveDate : c.CompensationLeaveEntitleEffectiveDate, compensationLeaveType.LeaveTypeID);
//else
// leaaveBalCal.RecalculateAfter(leaveBalApp.CompensationLeaveEntitleEffectiveDate < c.CompensationLeaveEntitleEffectiveDate ? leaveBalApp.CompensationLeaveEntitleEffectiveDate : c.CompensationLeaveEntitleEffectiveDate);
}
WebUtils.EndFunction(dbConn);
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Emp_CompensationLeaveEntitle_View.aspx?EmpID=" + c.EmpID + "&CompensationLeaveEntitleID=" + CurID);
}
