protected bool loadObject()
{
obj = new EEmpPersonalInfo();
obj.EmpID = CurID;
if (!db.select(dbConn, obj))
{
return(false);
}
ESSAuthorizationProcess authorizationProcess = new ESSAuthorizationProcess(dbConn);
int groupCount = authorizationProcess.GetAuthorizerAuthorizationGroupList(CurID).Count;
if (groupCount > 0)
{
Emp_Authorize_List_Form1.Visible = true;
}
else
{
Emp_Authorize_List_Form1.Visible = false;
}
//------------------------------------------------------
return(true);
}
//public void loadState()
//{
// info = new ListInfo();
// int page = 0;
// if (!CurPage.Value.Equals(""))
// page = Int32.Parse(CurPage.Value);
// info.loadState(Request, page);
// info.order = Order.Value.Equals("True");
// info.orderby = OrderBy.Value;
// if (info.orderby == "")
// info.orderby = null;
// info.recordPerPage = -1;
//}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
ESSAuthorizationProcess authorization = new ESSAuthorizationProcess(dbConn);
List <EAuthorizationGroup> authGroupList = authorization.GetAuthorizerAuthorizationGroupList(CurID);
if (authGroupList.Count > 0)
{
DBFilter filter = binding.createFilter();
DateTime dtPeriodFr, dtPeriodTo;
if (DateTime.TryParse(EmpRequestFromDate.Value, out dtPeriodFr))
{
filter.add(new Match("EmpRequestCreateDate", ">=", dtPeriodFr));
}
if (DateTime.TryParse(EmpRequestToDate.Value, out dtPeriodTo))
{
filter.add(new Match("EmpRequestCreateDate", "<", dtPeriodTo.AddDays(1)));
}
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
filter.add(new Match("R.EmpRequestStatus", "<>", EEmpRequest.STATUS_CANCELLED));
filter.add(new Match("R.EmpRequestStatus", "<>", EEmpRequest.STATUS_REJECTED));
filter.add(new Match("R.EmpRequestStatus", "<>", EEmpRequest.STATUS_APPROVED));
DBFilter workFlowDetailFilter = new DBFilter();
OR orWorkFlowIndexTerms = new OR();
if (EmpRequestStatus2.SelectedValue == "Y")
{
orWorkFlowIndexTerms.add(new MatchField("awfd.AuthorizationWorkFlowIndex", "=", "R.EmpRequestLastAuthorizationWorkFlowIndex + 1"));
}
else if (EmpRequestStatus2.SelectedValue == "O")
{
orWorkFlowIndexTerms.add(new MatchField("awfd.AuthorizationWorkFlowIndex", ">", "R.EmpRequestLastAuthorizationWorkFlowIndex + 1"));
}
else
{
orWorkFlowIndexTerms.add(new MatchField("awfd.AuthorizationWorkFlowIndex", ">", "R.EmpRequestLastAuthorizationWorkFlowIndex"));
}
AND andMaxWorkFlowIndexTerms = new AND();
andMaxWorkFlowIndexTerms.add(new MatchField("awfd.AuthorizationWorkFlowIndex", "=", "(SELECT MAX(maxAWFD.AuthorizationWorkFlowIndex) FROM " + EAuthorizationWorkFlowDetail.db.dbclass.tableName + " maxAWFD WHERE maxAWFD.AuthorizationWorkFlowID=awfd.AuthorizationWorkFlowID)"));
andMaxWorkFlowIndexTerms.add(new MatchField("R.EmpRequestLastAuthorizationWorkFlowIndex", ">=", "awfd.AuthorizationWorkFlowIndex"));
orWorkFlowIndexTerms.add(andMaxWorkFlowIndexTerms);
workFlowDetailFilter.add(orWorkFlowIndexTerms);
DBFilter authorizerFilter = new DBFilter();
string strAuthGroupInList = string.Empty;
foreach (EAuthorizationGroup authGroup in authGroupList)
{
if (string.IsNullOrEmpty(strAuthGroupInList))
{
strAuthGroupInList = authGroup.AuthorizationGroupID.ToString();
}
else
{
strAuthGroupInList += "," + authGroup.AuthorizationGroupID.ToString();
}
}
workFlowDetailFilter.add(new IN("awfd.AuthorizationGroupID", strAuthGroupInList, null));
AND andLeaveApplicationTerms = new AND();
andLeaveApplicationTerms.add(new IN("R.EmpRequestType", new string[] { EEmpRequest.TYPE_EELEAVEAPP, EEmpRequest.TYPE_EELEAVECANCEL }));
andLeaveApplicationTerms.add(new IN("EP.AuthorizationWorkFlowIDLeaveApp", "SELECT awfd.AuthorizationWorkFlowID FROM " + EAuthorizationWorkFlowDetail.db.dbclass.tableName + " awfd", workFlowDetailFilter));
//andLeaveApplicationTerms.add(new Match("AuthorizationGroupIsApproveLeave", "<>", false));
AND andEEProfileTerms = new AND();
andEEProfileTerms.add(new Match("R.EmpRequestType", EEmpRequest.TYPE_EEPROFILE));
andEEProfileTerms.add(new IN("EP.AuthorizationWorkFlowIDEmpInfoModified", "SELECT awfd.AuthorizationWorkFlowID FROM " + EAuthorizationWorkFlowDetail.db.dbclass.tableName + " awfd", workFlowDetailFilter));
// Start 0000060, Miranda, 2014-07-13
AND andOTClaimTerms = new AND();
andOTClaimTerms.add(new IN("R.EmpRequestType", new string[] { EEmpRequest.TYPE_EEOTCLAIM, EEmpRequest.TYPE_EEOTCLAIMCANCEL }));
andOTClaimTerms.add(new IN("EP.AuthorizationWorkFlowIDOTClaims", "SELECT awfd.AuthorizationWorkFlowID FROM " + EAuthorizationWorkFlowDetail.db.dbclass.tableName + " awfd", workFlowDetailFilter));
// End 0000060, Miranda, 2014-07-13
// Start 0000112, Miranda, 2014-12-10
AND andLateWaiveTerms = new AND();
andLateWaiveTerms.add(new IN("R.EmpRequestType", new string[] { EEmpRequest.TYPE_EELATEWAIVE, EEmpRequest.TYPE_EELATEWAIVECANCEL }));
andLateWaiveTerms.add(new IN("EP.AuthorizationWorkFlowIDLateWaive", "SELECT awfd.AuthorizationWorkFlowID FROM " + EAuthorizationWorkFlowDetail.db.dbclass.tableName + " awfd", workFlowDetailFilter));
// End 0000112, Miranda, 2014-12-10
OR orAuthorizationGrpApplicationTerms = new OR();
orAuthorizationGrpApplicationTerms.add(andLeaveApplicationTerms);
orAuthorizationGrpApplicationTerms.add(andEEProfileTerms);
// Start 0000060, Miranda, 2014-07-13
orAuthorizationGrpApplicationTerms.add(andOTClaimTerms);
// End 0000060, Miranda, 2014-07-13
// Start 0000112, Miranda, 2014-12-10
orAuthorizationGrpApplicationTerms.add(andLateWaiveTerms);
// End 0000112, Miranda, 2014-12-10
filter.add(orAuthorizationGrpApplicationTerms);
//string select = "R.*, E.EmpNo, E.EmpEngSurname, E.EmpEngOtherName, E.EmpAlias ";
//string from = "from (select * from [" + db.dbclass.tableName + "] where EmpRequestStatus = '"
// + EEmpRequest.STATUS_USRSUBMIT.ToString() + "' or EmpRequestStatus = '"
// + EEmpRequest.STATUS_FSTAPP.ToString() + "' ) R LEFT JOIN " + EEmpPersonalInfo.db.dbclass.tableName + " E on R.EmpID = E.EmpID AND R.EmpID in (Select P.EmpID From "
// + EEmpPositionInfo.db.dbclass.tableName + " P where P.EmpPosEffFr < '" + DateTime.Today.ToString("yyyy-MM-dd") + "' and ( P.EmpPosEffFr > '" + DateTime.Today.ToString("yyyy-MM-dd") + "' or P.EmpPosEffTo is Null ) and ( P.EmpFirstAuthorizationGp in ( Select A.AuthorizationGroupID From "
// + EAuthorizer.db.dbclass.tableName + " A where A.EmpID = " + CurID + " and R.EmpRequestStatus = '"
// + EEmpRequest.STATUS_USRSUBMIT.ToString() + "')) or ( P.EmpSecondAuthorizationGp in ( Select A.AuthorizationGroupID From "
// + EAuthorizer.db.dbclass.tableName + " A where A.EmpID = " + CurID + " and (R.EmpRequestStatus = '"
// + EEmpRequest.STATUS_FSTAPP.ToString() + "' or R.EmpRequestStatus = '"
// + EEmpRequest.STATUS_USRSUBMIT.ToString() + "'))))";
// Start 0000105, KuangWei, 2014-10-21
// Start 0000232, Miranda, 2015-07-02
string select = "R.*, E.EmpNo, E.EmpEngSurname, E.EmpEngOtherName, E.EmpAlias, ISNULL ( L.LeaveCode , L2.LeaveCode ) as LeaveCode, ISNULL ( L.LeaveCodeDesc , L2.LeaveCodeDesc) as LeaveCodeDesc";
// End 0000232, Miranda, 2015-07-02
string from = "from " + db.dbclass.tableName + " R "
+ " LEFT JOIN " + EEmpPersonalInfo.db.dbclass.tableName + " E on R.EmpID = E.EmpID "
+ " Left Join " + EEmpPositionInfo.db.dbclass.tableName + " EP on EP.EmpID = E.EmpID "
+ " and EP.EmpPosEffFr <= '" + DateTime.Today.ToString("yyyy-MM-dd") + "' AND (EP.EmpPosEffTO >= '" + DateTime.Today.ToString("yyyy-MM-dd") + "' or EP.EmpPosEffTo is Null )"
// Start 0000112, Miranda, 2015-01-11
// Start 0000232, Miranda, 2015-07-02
+ " LEFT JOIN " + ERequestLeaveApplication.db.dbclass.tableName + " C on R.EmpRequestRecordID = C.RequestLeaveAppID and R.EmpRequestType = '" + EEmpRequest.TYPE_EELEAVEAPP + "'"
+ " LEFT JOIN " + ERequestLeaveApplicationCancel.db.dbclass.tableName + " CC on R.EmpRequestRecordID = CC.RequestLeaveAppCancelID and R.EmpRequestType = '" + EEmpRequest.TYPE_EELEAVECANCEL + "'"
+ " LEFT JOIN " + ELeaveApplication.db.dbclass.tableName + " LA on LA.LeaveAppID = CC.LeaveAppID"
// End 0000112, Miranda, 2015-01-11
+ " LEFT JOIN " + ELeaveCode.db.dbclass.tableName + " L on C .RequestLeaveCodeID = L.LeaveCodeID "
+ " LEFT JOIN " + ELeaveCode.db.dbclass.tableName + " L2 on LA.LeaveCodeID = L2.LeaveCodeID";
// End 0000232, Miranda, 2015-07-02
// End 0000105, KuangWei, 2014-10-21
//DBFilter authorizerFilter = new DBFilter();
//authorizerFilter.add(new Match("EmpID", CurID));
//OR orFirstGrpStatusTerms = new OR();
//orFirstGrpStatusTerms.add(new Match("R.EmpRequestStatus", EEmpRequest.STATUS_SUBMITTED));
//DBFilter firstGrpFilter = new DBFilter();
//firstGrpFilter.add(orFirstGrpStatusTerms);
//firstGrpFilter.add(orAuthorizationGrpApplicationTerms);
//firstGrpFilter.add(new IN("AuthorizationGroupID", "Select AuthorizationGroupID from " + EAuthorizer.db.dbclass.tableName, authorizerFilter));
//OR orSecondGrpStatusTerms = new OR();
//orSecondGrpStatusTerms.add(new Match("R.EmpRequestStatus", EEmpRequest.STATUS_SUBMITTED));
//orSecondGrpStatusTerms.add(new Match("R.EmpRequestStatus", EEmpRequest.STATUS_ACCEPTED));
//DBFilter secondGrpFilter = new DBFilter();
//secondGrpFilter.add(orSecondGrpStatusTerms);
//secondGrpFilter.add(orAuthorizationGrpApplicationTerms);
//secondGrpFilter.add(new IN("AuthorizationGroupID", "Select AuthorizationGroupID from " + EAuthorizer.db.dbclass.tableName, authorizerFilter));
//OR orAuthorizationGrpFilter = new OR();
//orAuthorizationGrpFilter.add(new IN("EP.EmpFirstAuthorizationGp", "Select AuthorizationGroupID from " + EAuthorizationGroup.db.dbclass.tableName, firstGrpFilter));
//orAuthorizationGrpFilter.add(new IN("EP.EmpSecondAuthorizationGp", "Select AuthorizationGroupID from " + EAuthorizationGroup.db.dbclass.tableName, secondGrpFilter));
//filter.add(orAuthorizationGrpFilter);
DataTable table = filter.loadData(dbConn, info, select, from);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
else
{
return(null);
}
}
private ArrayList GetRemoveMenuItemList(MenuItemCollection menuItemCollection)
{
HROne.ProductLicense productLicense = WebUtils.productLicense(Session);
EESSUser essUser = WebUtils.GetCurUser(Session);
ArrayList removeSubMenuItemArray = new ArrayList();
foreach (MenuItem subMenuItem in menuItemCollection)
{
if (productLicense != null)
{
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Leave Application", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpLeaveApplication.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LEAVE_APPLICATION).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Request Status", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpRequestStatus.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LEAVE_APPLICATION).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true)
//Start 0000060, Miranda, 2014-07-22
&& !(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_OT_CLAIMS).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true)
//End 0000060, Miranda, 2014-07-22
&& !(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_CHANGE_EE_INFO).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true)
)
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Application Approval", StringComparison.CurrentCultureIgnoreCase)
// || subMenuItem.NavigateUrl.EndsWith("/ESS_EmpSupervisorApproval.aspx", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpSupervisorApproval.aspx", StringComparison.CurrentCultureIgnoreCase))
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
{
ESSAuthorizationProcess authorizationProcess = new ESSAuthorizationProcess(dbConn);
int groupCount = authorizationProcess.GetAuthorizerAuthorizationGroupList(user.EmpID).Count;
if (groupCount <= 0)
{
removeSubMenuItemArray.Add(subMenuItem);
}
else if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LEAVE_APPLICATION).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true)
//Start 0000060, Miranda, 2014-07-22
&& !(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_OT_CLAIMS).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true)
//End 0000060, Miranda, 2014-07-22
&& !(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_CHANGE_EE_INFO).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true)
)
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Leave Balance Enquiry", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpLeaveBalanceEnquiry.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LEAVE_BALANCE_ENQUIRY).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Leave History Enquiry", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpLeaveHistoryEnquiry.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LEAVE_HISTORY).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Leave Balance Report", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpLeaveBalanceReport.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LEAVE_BALANCE_REPORT).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
else
{
if (essUser != null)
{
ESSAuthorizationProcess authorization = new ESSAuthorizationProcess(dbConn);
int groupCount = authorization.GetAuthorizerAuthorizationGroupList(essUser.EmpID).Count;
if (groupCount <= 0)
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
}
}
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpLeaveApplicationList.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LEAVE_APPLICATION_LIST).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Payslip Printing", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpPayslipPrint.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_PRINT_PAYSLIP).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Tax Report Printing", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpTaxReport.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_PRINT_TAXREPORT).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Roster Table", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_RosterTable_View.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
if (!productLicense.IsAttendance || !(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_ROSTER_TABLE).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpOverallPaymentSummary.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_OVERALL_PAYMENT_SUMMARY).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// Start 0000057, KuangWei, 2014-07-09
if (subMenuItem.NavigateUrl.EndsWith("/ESS_MonthlyAttendanceReport.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// Start 000118, Ricky So, 2014/12/24
//ESSAuthorizationProcess authorizationProcess = new ESSAuthorizationProcess(dbConn);
//int groupCount = authorizationProcess.GetAuthorizerAuthorizationGroupList(user.EmpID).Count;
//if (groupCount <= 0)
// removeSubMenuItemArray.Add(subMenuItem);
//else
// End 000118, Ricky So, 2014/12/24
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ENABLE_MONTHLY_ATTENDANCE_REPORT).Equals("Y", StringComparison.CurrentCultureIgnoreCase)) ||
(!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_MONTHLY_ATTENDANCE_REPORT).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// End 0000057, KuangWei, 2014-07-09
if (subMenuItem.NavigateUrl.EndsWith("/ESS_TimeCardRecord.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ENABLE_TIMECARD_RECORD).Equals("Y", StringComparison.CurrentCultureIgnoreCase)) ||
(!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_TIMECARD_RECORD).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
if (subMenuItem.NavigateUrl.EndsWith("/ESS_Attendance_TimeEntry_List.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ENABLE_ATTENDANCE_TIMEENTRY_LIST).Equals("Y", StringComparison.CurrentCultureIgnoreCase)) ||
(!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_ATTENDANCE_TIMEENTRY_LIST).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// Start 0000076, Miranda, 2014-08-21
if (subMenuItem.NavigateUrl.EndsWith("/ESS_AttendanceTimeEntryReport.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_ATTENDANCE_TIMEENTRY_REPORT).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// End 0000076, Miranda, 2014-08-21
removeSubMenuItemArray.AddRange(GetRemoveMenuItemList(subMenuItem.ChildItems));
// ***** Start 2013/11/15, Ricky So, revise the show/hide menu routine
// if (subMenuItem.Text.Equals("Approval History", StringComparison.CurrentCultureIgnoreCase))
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpSupervisorApprovalHistory.aspx", StringComparison.CurrentCultureIgnoreCase))
{
// ***** End 2013/11/15, Ricky So, revise the show/hide menu routine
// ***** Start 0000208, Miranda, 2015-06-12
//{
// DBFilter approvalHistoryFilter = new DBFilter();
// approvalHistoryFilter.add(new Match("EmpRequestApprovalHistoryActionByEmpID", user.EmpID));
// if (EEmpRequestApprovalHistory.db.count(dbConn,approvalHistoryFilter)<=0)
// removeSubMenuItemArray.Add(subMenuItem);
//}
// ***** End 0000208, Miranda, 2015-06-12
// Start 0000060, Miranda, 2014-07-15
//if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpOTClaims.aspx", StringComparison.CurrentCultureIgnoreCase))
// if (!(ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_ENABLE_OTCLAIM).Equals("N", StringComparison.CurrentCultureIgnoreCase) ? false : true))
// removeSubMenuItemArray.Add(subMenuItem);
// End 0000060, Miranda, 2014-07-15
// Start 0000060, Miranda, 2014-07-22
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpOTClaims.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ENABLE_OTCLAIM).Equals("Y", StringComparison.CurrentCultureIgnoreCase)) ||
(!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_OT_CLAIMS).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
}
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpOTClaimsHistory.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ENABLE_OTCLAIM).Equals("Y", StringComparison.CurrentCultureIgnoreCase)) ||
(!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_OT_CLAIMS_HISTORY).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// End 0000060, Miranda, 2014-07-22
// Start 0000112, Miranda, 2014-12-10
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpLateWaive.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ENABLE_LATE_WAIVE).Equals("Y", StringComparison.CurrentCultureIgnoreCase)) ||
(!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LATE_WAIVE).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
if (subMenuItem.NavigateUrl.EndsWith("/ESS_EmpLateWaiveHistory.aspx", StringComparison.CurrentCultureIgnoreCase))
{
if ((!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ENABLE_LATE_WAIVE).Equals("Y", StringComparison.CurrentCultureIgnoreCase)) ||
(!ESystemParameter.getParameter(dbConn, ESystemParameter.PARAM_CODE_ESS_FUNCTION_LATE_WAIVE_HISTORY).Equals("Y", StringComparison.CurrentCultureIgnoreCase)))
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
// End 0000112, Miranda, 2014-12-10
}
else
{
removeSubMenuItemArray.Add(subMenuItem);
}
}
return(removeSubMenuItemArray);
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
DateTime dtLeaveAppDateFr = new DateTime();
DateTime dtLeaveAppDateTo = new DateTime();
if (!DateTime.TryParse(periodFrom.Value, out dtLeaveAppDateFr))
{
dtLeaveAppDateFr = new DateTime(1940, 1, 1);
}
if (!DateTime.TryParse(periodTo.Value, out dtLeaveAppDateTo))
{
dtLeaveAppDateTo = AppUtils.ServerDateTime().Date;
}
// Start 0000182, Ricky So, 2015-04-06
ESSAuthorizationProcess authProcess = new ESSAuthorizationProcess(dbConn);
List <EAuthorizationGroup> groupList = authProcess.GetAuthorizerAuthorizationGroupList(CurID);
ArrayList EmpIDList = new ArrayList();
if (groupList.Count > 0)
{
DBFilter authWorkFlowDetailFilter = new DBFilter();
string authGroupIDList = string.Empty;
foreach (EAuthorizationGroup group in groupList)
{
if (string.IsNullOrEmpty(authGroupIDList))
{
authGroupIDList = group.AuthorizationGroupID.ToString();
}
else
{
authGroupIDList += ", " + group.AuthorizationGroupID.ToString();
}
}
authWorkFlowDetailFilter.add(new IN("AuthorizationGroupID", authGroupIDList, null));
DBFilter empPosFilter = EEmpPositionInfo.CreateDateRangeDBFilter("epi", dtLeaveAppDateTo, dtLeaveAppDateTo);
empPosFilter.add(new IN("epi.AuthorizationWorkFlowIDLeaveApp", "SELECT DISTINCT awfd.AuthorizationWorkFlowID FROM " + EAuthorizationWorkFlowDetail.db.dbclass.tableName + " awfd", authWorkFlowDetailFilter));
DBFilter empInfoFilter = new DBFilter();
empInfoFilter.add(new IN("EmpID", "SELECT DISTINCT epi.EmpID FROM " + EEmpPositionInfo.db.dbclass.tableName + " epi", empPosFilter));
DBFilter empTermFilter = new DBFilter();
empTermFilter.add(new Match("EmpTermLastDate", "<", dtLeaveAppDateTo));
empInfoFilter.add(new IN("NOT EMPID", "SELECT et.EmpID FROM " + EEmpTermination.db.dbclass.tableName + " et", empTermFilter));
ArrayList EmpList = EEmpPersonalInfo.db.select(dbConn, empInfoFilter);
foreach (EEmpPersonalInfo empInfo in EmpList)
{
EmpIDList.Add(empInfo.EmpID);
}
}
EmpIDList.Add(CurID);
HROne.Reports.Employee.LeaveApplicationProcess rpt = new HROne.Reports.Employee.LeaveApplicationProcess(dbConn, EmpIDList, dtLeaveAppDateFr, dtLeaveAppDateTo);
string reportFileName = WebUtils.GetLocalizedReportFile(Server.MapPath("~/LeaveApplicationProcessList.rpt"));
WebUtils.ReportExport(Response, rpt, reportFileName, "PDF", "LeaveApplicationList");
//ArrayList values = new ArrayList();
//values.Add(CurID);
//if (errors.isEmpty())
//{
// HROne.Reports.Employee.LeaveApplicationProcess rpt = new HROne.Reports.Employee.LeaveApplicationProcess(dbConn, values, dtLeaveAppDateFr, dtLeaveAppDateTo);
// string reportFileName = WebUtils.GetLocalizedReportFile(Server.MapPath("~/LeaveApplicationProcessList.rpt"));
// //WebUtils.ReportExport(dbConn, user, errors, lblReportHeader.Text, Response, rpt, reportFileName, ((Button)sender).CommandArgument, "LeaveApplicationList", true);
// WebUtils.ReportExport(Response, rpt, reportFileName, "PDF", "LeaveApplicationList");
//}
// End 0000182, Ricky So, 2015-04-06
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
DateTime currentDate = AppUtils.ServerDateTime().Date;
DateTime asOfDate = currentDate;
if (!DateTime.TryParse(BalanceAsOfDate.Value, out asOfDate))
{
asOfDate = currentDate;
}
ESSAuthorizationProcess authProcess = new ESSAuthorizationProcess(dbConn);
List <EAuthorizationGroup> groupList = authProcess.GetAuthorizerAuthorizationGroupList(CurID);
ArrayList EmpIDList = new ArrayList();
if (groupList.Count > 0)
{
DBFilter authWorkFlowDetailFilter = new DBFilter();
string authGroupIDList = string.Empty;
foreach (EAuthorizationGroup group in groupList)
{
if (string.IsNullOrEmpty(authGroupIDList))
{
authGroupIDList = group.AuthorizationGroupID.ToString();
}
else
{
authGroupIDList += ", " + group.AuthorizationGroupID.ToString();
}
}
authWorkFlowDetailFilter.add(new IN("AuthorizationGroupID", authGroupIDList, null));
DBFilter empPosFilter = EEmpPositionInfo.CreateDateRangeDBFilter("epi", currentDate, currentDate);
empPosFilter.add(new IN("epi.AuthorizationWorkFlowIDLeaveApp", "SELECT DISTINCT awfd.AuthorizationWorkFlowID FROM " + EAuthorizationWorkFlowDetail.db.dbclass.tableName + " awfd", authWorkFlowDetailFilter));
DBFilter empInfoFilter = new DBFilter();
empInfoFilter.add(new IN("EmpID", "SELECT DISTINCT epi.EmpID FROM " + EEmpPositionInfo.db.dbclass.tableName + " epi", empPosFilter));
DBFilter empTermFilter = new DBFilter();
empTermFilter.add(new Match("EmpTermLastDate", "<", currentDate < asOfDate?currentDate:asOfDate));
empInfoFilter.add(new IN("NOT EMPID", "SELECT et.EmpID FROM " + EEmpTermination.db.dbclass.tableName + " et", empTermFilter));
ArrayList EmpList = EEmpPersonalInfo.db.select(dbConn, empInfoFilter);
foreach (EEmpPersonalInfo empInfo in EmpList)
{
EmpIDList.Add(empInfo.EmpID);
}
}
// Start Ricky So, 0000119, 2014/10/28
EmpIDList.Add(WebUtils.GetCurUser(Session).EmpID);
// End Ricky So, 0000119, 2014/10/28
if (EmpIDList.Count > 0)
{
ArrayList leaveTypeList = new ArrayList();
leaveTypeList.Add(ELeaveType.ANNUAL_LEAVE_TYPE(dbConn));
// Start 0000057, Ricky So, 2014/07/03
DBFilter m_leaveTypeFilter = new DBFilter();
DBFilter m_leaveCodeFilter = new DBFilter();
OR m_orLeaveType = new OR();
m_orLeaveType.add(new Match("LeaveType", "SLCAT1"));
m_orLeaveType.add(new Match("LeaveType", "SLCAT2"));
m_leaveTypeFilter.add(m_orLeaveType);
m_leaveCodeFilter.add(new IN("LeaveTypeID", "SELECT LeaveTypeID FROM LeaveType", m_leaveTypeFilter));
ArrayList m_leaveCodeList = ELeaveCode.db.select(dbConn, m_leaveCodeFilter);
if (m_leaveCodeList.Count > 0)
{
leaveTypeList.Add(ELeaveType.SLCAT1_LEAVE_TYPE(dbConn));
leaveTypeList.Add(ELeaveType.SLCAT2_LEAVE_TYPE(dbConn));
}
// End 0000057, Ricky So, 2014/07/03
HROne.Reports.Employee.LeaveBalanceProcess rpt = new HROne.Reports.Employee.LeaveBalanceProcess(dbConn, EmpIDList, asOfDate, leaveTypeList);
string reportFileName = WebUtils.GetLocalizedReportFile(Server.MapPath("~/Report_Employee_LeaveBalance.rpt"));
WebUtils.ReportExport(Response, rpt, reportFileName, "PDF", "LeaveBalance");
}
else
{
errors.addError("No employee can be generated");
}
}
