protected bool loadObject() { EEmpPersonalInfo obj = new EEmpPersonalInfo(); bool isNew = WebFormWorkers.loadKeys(empDB, obj, DecryptedRequest); DBFilter filter = new DBFilter(); filter.add(new Match("EmpID", obj.EmpID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); ArrayList empInfoList = EEmpPersonalInfo.db.select(dbConn, filter); if (empInfoList.Count == 0) { return(false); } obj = (EEmpPersonalInfo)empInfoList[0]; Hashtable values = new Hashtable(); empDB.populate(obj, values); empBinding.toControl(values); OldEmpNo.Text = EmpNo.Text; EEmpPositionInfo empPos = AppUtils.GetLastPositionInfo(dbConn, CurEmpID); values = new Hashtable(); empPosDB.populate(empPos, values); empPosBinding.toControl(values); return(true); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = sbinding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); string select = "e.*, ep.EmpPayrollID"; string from = "from [" + db.dbclass.tableName + "] e, EmpPayroll ep, PayrollPeriod pp"; filter.add(new Match("PayGroupID", PayGroupID.SelectedValue)); filter.add(new MatchField("e.EmpID", "ep.EmpID")); filter.add(new MatchField("ep.PayperiodID", "pp.PayperiodID")); filter.add(new Match("ep.EmpPayStatus", "T")); filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); filter.add(new IN("e.EmpID", "Select EmpID From " + EEmpPersonalInfo.db.dbclass.tableName + " ee", EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()))); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
protected bool loadObject() { obj = new EEmpPersonalInfo(); bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest); DBFilter filter = new DBFilter(); filter.add(new Match("EmpID", obj.EmpID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); ArrayList empPayrollList = EEmpPersonalInfo.db.select(dbConn, filter); if (empPayrollList.Count == 0) { //IsAllowEdit = false; Attendance_AttendanceRecordList.Visible = false; return(false); } obj = (EEmpPersonalInfo)empPayrollList[0]; Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); ucEmp_Header.CurrentEmpID = obj.EmpID; return(true); }
protected bool loadObject() { obj = new EEmpPersonalInfo(); bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest); DBFilter filter = new DBFilter(); filter.add(new Match("EmpID", obj.EmpID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); ArrayList empInfoList = EEmpPersonalInfo.db.select(dbConn, filter); if (empInfoList.Count == 0) { return(false); } obj = (EEmpPersonalInfo)empInfoList[0]; DBFilter empUniformFilter = new DBFilter(); empUniformFilter.add(new Match("EmpID", obj.EmpID)); ArrayList empUniformList = EEmpUniform.db.select(dbConn, empUniformFilter); if (empUniformList.Count > 0) { EEmpUniform empUniform = (EEmpUniform)empUniformList[0]; EmpUniformB.Text = empUniform.EmpUniformB; EmpUniformW.Text = empUniform.EmpUniformW; EmpUniformH.Text = empUniform.EmpUniformH; } Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); return(true); }
protected void RefreshMinimumWagesInfo() { DBFilter filter = new DBFilter(); filter.add(new Match("EmpPayrollID", CurID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); ArrayList empPayrollList = EEmpPayroll.db.select(dbConn, filter); if (empPayrollList.Count == 0) { TotalWagesForMinimumWages.Text = string.Empty; MinimumWagesRequired.Text = string.Empty; return; } EEmpPayroll empPayroll = (EEmpPayroll)empPayrollList[0]; double dblTotalWagesForMinimumWages = 0; double dblMinimumWagesRequired = 0; EPayrollPeriod payPeriod = new EPayrollPeriod(); payPeriod.PayPeriodID = empPayroll.PayPeriodID; if (EPayrollPeriod.db.select(dbConn, payPeriod)) { dblTotalWagesForMinimumWages = HROne.Payroll.PayrollProcess.GetTotalWagesWithoutRestDayPayment(dbConn, empPayroll.EmpID, payPeriod.PayPeriodFr, payPeriod.PayPeriodTo, null); } double totalWorkingHour = HROne.Payroll.PayrollProcess.GetTotalEmpPayrollWorkingHours(dbConn, empPayroll.EmpID, empPayroll.PayPeriodID); lblTotalWorkingHours.Text = totalWorkingHour.ToString(); dblMinimumWagesRequired = ((double)(HROne.Payroll.PayrollProcess.GetMinimumWages(dbConn, empPayroll.EmpID, payPeriod.PayPeriodTo) * totalWorkingHour)); TotalWagesForMinimumWages.Text = dblTotalWagesForMinimumWages.ToString("#,##0.00"); MinimumWagesRequired.Text = dblMinimumWagesRequired.ToString("#,##0.00"); if (dblMinimumWagesRequired - dblTotalWagesForMinimumWages <= 0.01) { btnAddAdditionalRemuneration.Visible = false; } else { EPayrollGroup payGroup = new EPayrollGroup(); payGroup.PayGroupID = payPeriod.PayGroupID; if (EPayrollGroup.db.select(dbConn, payGroup)) { if (payGroup.PayGroupAdditionalRemunerationPayCodeID > 0) { btnAddAdditionalRemuneration.Visible = true & toolBar.EditButton_Visible; } else { btnAddAdditionalRemuneration.Visible = false; } } else { btnAddAdditionalRemuneration.Visible = false; } } }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = sbinding.createFilter(); filter.add(new Match("EmpID", this.CurID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); if (info != null && info.orderby != null && !info.orderby.Equals("")) { filter.add(info.orderby, info.order); } string select = "c.*"; string from = "from [" + sdb.dbclass.tableName + "] c "; DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = binding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); string select = "e.* "; string from = "from [" + db.dbclass.tableName + "] e "; //DataTable table = filter.loadData(info, select, from); DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
public DataView PayrollProcessedLoadData(ListInfo info, DBManager db, DataList repeater) { DBFilter filter = sPayrollProcessedBinding.createFilter(); if (info != null && info.orderby != null && !info.orderby.Equals("")) { } else { info.orderby = "CNDEffDate"; info.order = false; } string select = "c.* "; string from = "from " + db.dbclass.tableName + " c "; filter.add(new Match("PayRecID", ">", 0)); //filter.add(new Match("EmpPayrollID", ">", 0)); filter.add(WebUtils.AddRankFilter(Session, "c.EmpID", true)); DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info); DataView view = new DataView(table); if (PayrollProcessedRepeater != null) { PayrollProcessedRepeater.DataSource = view; PayrollProcessedRepeater.DataBind(); } return(view); }
protected bool loadObject() { obj = new EEmpBankAccount(); 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"); } } //DBFilter filter = new DBFilter(); //filter.add(new Match("EmpBankAccountID", obj.EmpBankAccountID)); //filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); //ArrayList empBankAccountList = EEmpBankAccount.db.select(dbConn, filter); //if (empBankAccountList.Count == 0) // return false; //obj = (EEmpBankAccount)empBankAccountList[0]; Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); return(true); }
protected bool loadObject() { obj = new EEmpPositionInfo(); 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"); } } //if (obj.EmpPosIsRosterTableGroupSupervisor) // EmpPosIsRosterTableGroupSupervisor.Visible = true; //else // EmpPosIsRosterTableGroupSupervisor.Visible = false; Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); return(true); }
protected bool loadObject(int EmpID) { DBFilter filter = new DBFilter(); filter.add(new Match("EmpID", EmpID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); ArrayList empInfoList = EEmpPersonalInfo.db.select(dbConn, filter); if (empInfoList.Count == 0) { if (EmpID <= 0) { return(false); } else { HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx"); } } EEmpPersonalInfo obj = (EEmpPersonalInfo)empInfoList[0]; //if (obj.MasterEmpID > 0) //{ // NewRoleEmpNo.Text = obj.EmpNo; // EEmpPersonalInfo masterEmpInfo = new EEmpPersonalInfo(); // obj.EmpID = obj.MasterEmpID; // if (!EEmpPersonalInfo.db.select(obj)) //} //DBFilter empUniformFilter = new DBFilter(); //empUniformFilter.add(new Match("EmpID", obj.EmpID)); //ArrayList empUniformList = EEmpUniform.db.select(dbConn, empUniformFilter); //if (empUniformList.Count > 0) //{ // EEmpUniform empUniform = (EEmpUniform)empUniformList[0]; // EmpUniformB.Text = empUniform.EmpUniformB; // EmpUniformW.Text = empUniform.EmpUniformW; // EmpUniformH.Text = empUniform.EmpUniformH; //} Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); //EmpFullName.Text = obj.EmpEngFullName; NewRoleEmpNoRoleRow.Visible = false; if (obj.MasterEmpID > 0) { RoleEmpInfoPanel.Visible = true; } else { RoleEmpInfoPanel.Visible = false; } return(true); }
protected bool loadObject() { obj = new EEmpWorkExp(); 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); binding.toControl(values); if (EmpWorkExpToYear.Text.Equals("0")) { EmpWorkExpToYear.Text = string.Empty; } return(true); }
protected bool loadObject() { obj = new EEmpDependant(); 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); binding.toControl(values); //Start 0000190, Miranda, 2015-04-30 isMedicalSchemeInsured(EmpDependantMedicalSchemeInsured.Checked); //End 0000190, Miranda, 2015-04-30 return(true); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = binding.createFilter(); if (info != null && info.orderby != null && !info.orderby.Equals("")) { filter.add(info.orderby, info.order); } string select = "e.*"; string from = "from [" + db.dbclass.tableName + "] e "; filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); DBFilter empPayrollFilter = new DBFilter(); empPayrollFilter.add(Payroll_PeriodSelectionList1.GetEmpPayrollDBTerm("ep")); filter.add(new IN("e.EmpID", "SELECT DISTINCT ep.EmpID FROM " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter)); DBFilter payPeriodFilter = new SearchBinding(dbConn, EPayrollPeriod.db).createFilter();; payPeriodFilter.add(new IN("pp.PayPeriodID", "SELECT DISTINCT ep.PayPeriodID FROM " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter)); string sqlStr = " min(pp.PayPeriodFr) as PayPeriodFr, max(pp.PayPeriodTo) as PayPeriodTo "; string fromStr = " from [" + EPayrollPeriod.db.dbclass.tableName + "] pp "; DataTable payPeriodTable = payPeriodFilter.loadData(dbConn, null, sqlStr, fromStr); int rowCount = payPeriodTable.Rows.Count; if (rowCount > 0 && !string.IsNullOrEmpty(payPeriodTable.Rows[0]["PayPeriodFr"].ToString())) { filter.add(new Match("e.EmpDateOfJoin", ">=", ((DateTime)payPeriodTable.Rows[0]["PayPeriodFr"]).ToString("yyyy/MM/dd"))); filter.add(new Match("e.EmpDateOfJoin", "<=", ((DateTime)payPeriodTable.Rows[0]["PayPeriodTo"]).ToString("yyyy/MM/dd"))); } DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { EClaimsAndDeductions obj = new EClaimsAndDeductions(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); Hashtable values = new Hashtable(); db.populate(obj, values); { //((Button)e.Item.FindControl("Edit")).Visible = IsAllowEdit; //if (obj.PayRecID != null) //{ // ((Button)e.Item.FindControl("Edit")).Visible = false; // ((CheckBox)e.Item.FindControl("DeleteItem")).Visible = false; //} HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("CNDID"); h.Value = obj.CNDID.ToString(); Label CNDAmount = (Label)e.Item.FindControl("CNDAmount"); Label CNDRemark = (Label)e.Item.FindControl("CNDRemark"); Label EmpAccID = (Label)e.Item.FindControl("EmpAccID"); Binding ebinding = new Binding(dbConn, db); ebinding.add(CNDAmount); ebinding.add(CNDRemark); ebinding.add(new BlankZeroLabelVLBinder(EEmpBankAccount.db, EmpAccID, "EmpAccID", EEmpBankAccount.VLBankAccount).setTextDisplayForZero(HROne.Common.WebUtility.GetLocalizedString(EEmpBankAccount.DEFAULT_BANK_ACCOUNT_TEXT))); ebinding.init(Request, Session); ebinding.toControl(values); DBFilter empRankFilter = new DBFilter(); empRankFilter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); empRankFilter.add(new Match("EmpID", obj.EmpID)); if (EEmpPersonalInfo.db.count(dbConn, empRankFilter) > 0) { CNDAmount.Text = obj.CNDAmount.ToString("$#,##0.00"); } else { CNDAmount.Text = "******"; CNDRemark.Text = "******"; if (obj.CNDPayMethod.Equals("A", StringComparison.CurrentCultureIgnoreCase)) { EmpAccID.Text = "******"; } } } }
public DataView loadEmpData(ListInfo info, DBManager db, Repeater repeater) { WebDatePicker PayPeriodAsOFDate = (WebDatePicker)EmployeeSearchControl1.AdditionElementControl.FindControl("PayPeriodAsOFDate"); DBFilter filter = binding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); string select = "e.*, ep.*, pp.PayPeriodFr, pp.PayperiodTo, pp.PayPeriodConfirmDate"; string from = "from [" + db.dbclass.tableName + "] e, EmpPayroll ep, PayrollPeriod pp "; filter.add(new MatchField("e.EmpID", "ep.EmpID")); filter.add(new MatchField("ep.PayperiodID", "pp.PayperiodID")); filter.add(new Match("ep.EmpPayStatus", "C")); filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); DateTime dtPayPeriodAsOFDate; if (DateTime.TryParse(PayPeriodAsOFDate.Value, out dtPayPeriodAsOFDate)) { filter.add(new Match("pp.PayPeriodFr", "<=", dtPayPeriodAsOFDate)); filter.add(new Match("pp.PayPeriodTo", ">=", dtPayPeriodAsOFDate)); } if (dtPayPeriodAsOFDate.Ticks.Equals(0)) { dtPayPeriodAsOFDate = AppUtils.ServerDateTime().Date; } filter.add(new IN("e.EmpID", "Select EmpID from " + EEmpPersonalInfo.db.dbclass.tableName + " ee", EmployeeSearchControl1.GetEmpInfoFilter(dtPayPeriodAsOFDate, dtPayPeriodAsOFDate))); //if (filter.getOrderClause().IndexOf("PayPeriodFr")<0) // filter.add("EmpNo", true); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = table; repeater.DataBind(); } return(view); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = binding.createFilter(); if (info != null && info.orderby != null && !info.orderby.Equals("")) { filter.add(info.orderby, info.order); } string select = "et.EmpTermID, e.*"; string from = "from [" + db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL"; from += " inner join " + EEmpTermination.db.dbclass.tableName + " et on et.empid = e.empid "; filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); //DateTime dtLastEmploymentDateFrom, dtLastEmploymentDateTo; //if (DateTime.TryParse(((WebDatePicker)EmployeeSearchControl1.AdditionElementControl.FindControl("LastEmploymentDateFrom")).Value, out dtLastEmploymentDateFrom)) // filter.add(new Match("et.EmpTermLastDate", ">=", dtLastEmploymentDateFrom)); //if (DateTime.TryParse(((WebDatePicker)EmployeeSearchControl1.AdditionElementControl.FindControl("LastEmploymentDateTo")).Value, out dtLastEmploymentDateTo)) // filter.add(new Match("et.EmpTermLastDate", "<=", dtLastEmploymentDateTo)); DBFilter empPayrollFilter = new DBFilter(); empPayrollFilter.add(Payroll_PeriodSelectionList1.GetEmpPayrollDBTerm()); DBFilter lastEmploymentDateFilter = new DBFilter(); lastEmploymentDateFilter.add(new MatchField("et.EmpTermLastDate", "<=", "tmpPP.PayPeriodTo")); empPayrollFilter.add(new IN("ep.PayPeriodID", "SELECT tmpPP.PayPeriodID FROM " + EPayrollPeriod.db.dbclass.tableName + " tmpPP", lastEmploymentDateFilter)); filter.add(new IN("e.EmpID", "SELECT DISTINCT ep.EmpID FROM " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter)); DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = binding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); // only staffs with commission calculation is configured through latest Recurring Payment DBFilter m_rpFilter = new DBFilter(); OR m_or = new OR(); m_or.add(new NullTerm("EmpRPEffTo")); m_or.add(new Match("EmpRPEffTo", ">=", Utility.LastDateOfMonth(AppUtils.ServerDateTime()))); m_rpFilter.add(new Match("EmpRPEffFr", "<=", Utility.LastDateOfMonth(AppUtils.ServerDateTime()))); m_rpFilter.add(m_or); DBFilter m_isHitRateBasedFilter = new DBFilter(); m_isHitRateBasedFilter.add(new Match("PaymentCodeIsHitRateBased", true)); m_rpFilter.add(new IN("PayCodeID", "SELECT PaymentCodeID FROM PaymentCode", m_isHitRateBasedFilter)); filter.add(new IN("EmpID", "SELECT tmpRP.EmpID FROM EmpRecurringPayment tmpRP", m_rpFilter)); string select = "e.* "; string from = "from [" + db.dbclass.tableName + "] e "; //DataTable table = filter.loadData(info, select, from); DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { ECommissionAchievement obj = new ECommissionAchievement(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); Hashtable values = new Hashtable(); db.populate(obj, values); { //((Button)e.Item.FindControl("Edit")).Visible = IsAllowEdit; //if (obj.PayRecID != null) //{ // ((Button)e.Item.FindControl("Edit")).Visible = false; // ((CheckBox)e.Item.FindControl("DeleteItem")).Visible = false; //} HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("CAID"); h.Value = obj.CAID.ToString(); Label CAPercent = (Label)e.Item.FindControl("CAPercent"); Label CAEffDate = (Label)e.Item.FindControl("CAEffDate"); Binding ebinding = new Binding(dbConn, db); ebinding.add(CAPercent); ebinding.add(CAEffDate); // ebinding.add(new BlankZeroLabelVLBinder(EEmpBankAccount.db, EmpAccID, "EmpAccID", EEmpBankAccount.VLBankAccount).setTextDisplayForZero(HROne.Common.WebUtility.GetLocalizedString(EEmpBankAccount.DEFAULT_BANK_ACCOUNT_TEXT))); ebinding.init(Request, Session); ebinding.toControl(values); DBFilter empRankFilter = new DBFilter(); empRankFilter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); empRankFilter.add(new Match("EmpID", obj.EmpID)); if (EEmpPersonalInfo.db.count(dbConn, empRankFilter) > 0) { CAPercent.Text = obj.CAPercent.ToString("#0.00"); if (!obj.CAEffDate.Ticks.Equals(0)) { CAEffDate.Text = obj.CAEffDate.ToString("yyyy-MM-dd"); } } else { CAPercent.Text = "******"; CAEffDate.Text = "******"; } } }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = binding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); string select = "e.*"; string from = "from [" + db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL"; filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); //foreach (RepeaterItem item in HierarchyLevel.Items) //{ // DBFilter sub = null; // DropDownList c = (DropDownList)item.FindControl("HElementID"); // string v = c.SelectedValue; // if (!v.Equals("")) // { // if (sub == null) // { // sub = new DBFilter(); // sub.add(new MatchField("p.EmpPosID", "EmpPosID")); // } // sub.add(new Match("HLevelID", c.Attributes["HLevelID"])); // sub.add(new Match("HElementID", v)); // } // if (sub != null) // filter.add(new Exists(EEmpHierarchy.db.dbclass.tableName, sub)); //} DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
//protected bool loadObject() //{ // obj = new EPayrollGroup(); // bool isNew = WebFormWorkers.loadKeys(EPayrollGroup.db, obj, DecryptedRequest); // if (!EPayrollGroup.db.select(dbConn, obj)) // return false; // Hashtable values = new Hashtable(); // EPayrollGroup.db.populate(obj, values); // binding.toControl(values); // if (CurPayPeriodID <= 0) // { // CurPayPeriodID = obj.CurrentPayPeriodID; // } // try // { // PayPeriodID.SelectedValue = CurPayPeriodID.ToString(); // ucPayroll_PeriodInfo.CurrentPayPeriodID = CurPayPeriodID; // } // catch (Exception ex) // { // CurPayPeriodID = 0; // } // if (PayPeriodID.SelectedIndex == 0) // { // CurPayPeriodID = 0; // ucPayroll_PeriodInfo.CurrentPayPeriodID = 0; // } // if (CurPayPeriodID > 0) // panelCostAllocationAdjustmentDetail.Visible = true; // else // panelCostAllocationAdjustmentDetail.Visible = false; // return true; //} //protected void CostAllocationStatus_SelectedIndexChanged(object sender, EventArgs e) //{ // Response.Redirect(Request.Url.LocalPath + "?PayGroupID=" + PayGroupID.SelectedValue + "&CostAllocationStatus=" + CostAllocationStatus.SelectedValue); //} //protected void PayGroupID_SelectedIndexChanged(object sender, EventArgs e) //{ // Response.Redirect(Request.Url.LocalPath + "?PayGroupID=" + PayGroupID.SelectedValue + "&CostAllocationStatus=" + CostAllocationStatus.SelectedValue); //} //protected void PayPeriodID_SelectedIndexChanged(object sender, EventArgs e) //{ // Response.Redirect(Request.Url.LocalPath + "?PayGroupID=" + PayGroupID.SelectedValue + "&PayPeriodID=" + PayPeriodID.SelectedValue + "&CostAllocationStatus=" + CostAllocationStatus.SelectedValue); //} public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = sbinding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); string select = " e.*, ca.CostAllocationID "; string from = "from " + EEmpPersonalInfo.db.dbclass.tableName + " e, " + ECostAllocation.db.dbclass.tableName + " ca, " + EEmpPayroll.db.dbclass.tableName + " ep, " + EPayrollPeriod.db.dbclass.tableName + " pp"; filter.add(new MatchField("e.EmpID", "ca.EmpID")); filter.add(new MatchField("ca.EmpPayrollID", "ep.EmpPayrollID")); filter.add(new MatchField("ep.PayPeriodID", "pp.PayPeriodID")); filter.add(new Match("ca.CostAllocationStatus", CostAllocationStatus.SelectedValue)); //DBFilter empPayrollFilter = new DBFilter(); //empPayrollFilter.add(new Match("ep.EmpPayStatus", "C")); //empPayrollFilter.add(new Match("ep.PayPeriodID", CurPayPeriodID)); // Start 0000129, Ricky So, 2014/11/11 filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); // End 0000129, Ricky So, 2014/11/11 //DBFilter inCostAllocationFilter = new DBFilter(); //filter.add(new IN("ca.EmpPayrollID", "Select EmpPayrollID from " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter)); DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info); view = new DataView(table); //if (info != null) //{ // info.loadPageList(null, PrevPage, NextPage, FirstPage, LastPage); // CurPage.Value = info.page.ToString(); // NumPage.Value = info.numPage.ToString(); //} if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = binding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); string select = " e.*"; string from = "from [" + db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL"; filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); DateTime dtEmpDateOfJoinFrom = new DateTime(), dtEmpDateOfJoinTo = new DateTime(); if (DateTime.TryParse(EmpDateOfJoinFrom.Value, out dtEmpDateOfJoinFrom)) { filter.add(new Match("e.EmpDateOfJoin", ">=", dtEmpDateOfJoinFrom)); } if (DateTime.TryParse(EmpDateOfJoinTo.Value, out dtEmpDateOfJoinTo)) { filter.add(new Match("e.EmpDateOfJoin", "<=", dtEmpDateOfJoinTo)); } filter.add(new NullTerm("NOT e.EmpDateOfJoin")); DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
public DataView loadData(ListInfo info, DBManager db, DataList repeater) { DBFilter filter = sbinding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) //{ // info.orderby = "is_processed, " + info.orderby; //} //else //{ // info.orderby = "is_processed, CNDEffDate"; // info.order = false; //} //string select = "c.*, (CASE WHEN payrecid>0 THEN 1 Else 0 END) is_processed "; //string from = "from " + db.dbclass.tableName + " c "; if (info != null && info.orderby != null && !info.orderby.Equals("")) { } else { info.orderby = "CNDEffDate"; info.order = false; } string select = "c.* "; string from = "from " + db.dbclass.tableName + " c "; filter.add(new NullTerm("PayRecID")); filter.add(WebUtils.AddRankFilter(Session, "c.EmpID", true)); DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info); DataView view = new DataView(table); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { EIncentivePayment obj = new EIncentivePayment(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); Hashtable values = new Hashtable(); db.populate(obj, values); { HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("IPID"); h.Value = obj.IPID.ToString(); Label IPPercent = (Label)e.Item.FindControl("IPPercent"); Label IPEffDate = (Label)e.Item.FindControl("IPEffDate"); Binding ebinding = new Binding(dbConn, db); ebinding.add(IPPercent); ebinding.add(IPEffDate); // ebinding.add(new BlankZeroLabelVLBinder(EEmpBankAccount.db, EmpAccID, "EmpAccID", EEmpBankAccount.VLBankAccount).setTextDisplayForZero(HROne.Common.WebUtility.GetLocalizedString(EEmpBankAccount.DEFAULT_BANK_ACCOUNT_TEXT))); ebinding.init(Request, Session); ebinding.toControl(values); DBFilter empRankFilter = new DBFilter(); empRankFilter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); empRankFilter.add(new Match("EmpID", obj.EmpID)); if (EEmpPersonalInfo.db.count(dbConn, empRankFilter) > 0) { IPPercent.Text = obj.IPPercent.ToString("#0.00"); if (!obj.IPEffDate.Ticks.Equals(0)) { IPEffDate.Text = obj.IPEffDate.ToString("yyyy-MM-dd"); } } else { IPPercent.Text = "******"; IPEffDate.Text = "******"; } } }
public DataView loadData2(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = new DBFilter(); filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); int m_batchID = -1; if (!int.TryParse(BatchID.SelectedValue, out m_batchID)) { m_batchID = -1; } DBFilter m_batchFilter = new DBFilter(); m_batchFilter.add(new Match("CAImportBatchID", m_batchID)); filter.add(new IN("EmpID", "SELECT EmpID FROM CommissionAchievement ", m_batchFilter)); string select = "e.* "; string from = "from [" + db.dbclass.tableName + "] e "; DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
protected bool loadObject() { ECostAllocation obj = new ECostAllocation(); bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest); DBFilter filter = new DBFilter(); filter.add(new Match("CostAllocationID", obj.CostAllocationID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); ArrayList costAllocationList = db.select(dbConn, filter); if (costAllocationList.Count == 0) { return(false); } obj = (ECostAllocation)costAllocationList[0]; Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); ucEmp_Header.CurrentEmpID = obj.EmpID; EEmpPayroll empPayroll = new EEmpPayroll(); empPayroll.EmpPayrollID = obj.EmpPayrollID; EEmpPayroll.db.select(dbConn, empPayroll); ucPayroll_PeriodInfo.CurrentPayPeriodID = empPayroll.PayPeriodID; Payroll_CostAllocationList.CurrentCostAllocationID = obj.CostAllocationID; //Payroll_PaymentRecordList.CurrentEmpPayrollID = obj.EmpPayrollID; //Payroll_PaymentRecordList.CurrentEmpPayStatus = obj.EmpPayStatus; //Payroll_MPFRecordList.CurrentEmpPayrollID = obj.EmpPayrollID; //Payroll_MPFRecordList.CurrentEmpPayStatus = obj.EmpPayStatus; //Payroll_ORSORecordList.CurrentEmpPayrollID = obj.EmpPayrollID; //Payroll_ORSORecordList.CurrentEmpPayStatus = obj.EmpPayStatus; return(true); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = addAuthorizerBinding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); string select = "e.* "; string from = "from [" + EEmpPersonalInfo.db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL"; filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); DBFilter empAuthorizerFilter = new DBFilter(); empAuthorizerFilter.add(new MatchField("e.empid", "ar.empid")); empAuthorizerFilter.add(new Match("ar.AuthorizationGroupID", CurID)); filter.add(new Exists(EAuthorizer.db.dbclass.tableName + " ar", empAuthorizerFilter, true)); DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
protected void btnAddAdditionalRemuneration_Click(object sender, EventArgs e) { DBFilter filter = new DBFilter(); filter.add(new Match("EmpPayrollID", CurID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); ArrayList empPayrollList = EEmpPayroll.db.select(dbConn, filter); if (empPayrollList.Count == 0) { TotalWagesForMinimumWages.Text = string.Empty; MinimumWagesRequired.Text = string.Empty; return; } EEmpPayroll empPayroll = (EEmpPayroll)empPayrollList[0]; WebUtils.StartFunction(Session, FUNCTION_CODE.Value, empPayroll.EmpID); HROne.Payroll.PayrollProcess.InsertAdditionalRemuneration(dbConn, empPayroll); WebUtils.EndFunction(dbConn); Payroll_PaymentRecordList.Refresh(); RefreshMinimumWagesInfo(); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = binding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); // only staffs with commission calculation is configured through latest Recurring Payment DBTerm m_inCondition = CreateFilterByProcess(gProcessName, gPID); if (m_inCondition != null) { filter.add(m_inCondition); } string select = "e.* "; string from = "from [" + db.dbclass.tableName + "] e "; DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); DataTable table = filter.loadData(dbConn, null, select, from); table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info); view = new DataView(table); ListFooter.Refresh(); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }
public DataView loadData(ListInfo info, DBManager db, Repeater repeater) { DBFilter filter = sbinding.createFilter(); //if (info != null && info.orderby != null && !info.orderby.Equals("")) // filter.add(info.orderby, info.order); string select = "e.*, ep.*"; string from = "from [" + db.dbclass.tableName + "] ep, EmpPersonalInfo e "; filter.add(new MatchField("e.EmpID", "ep.EmpID")); filter.add(Payroll_PeriodSelectionList1.GetEmpPayrollDBTerm("ep")); filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true)); DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info); if (table.Rows.Count > 0) { btnUndo.Visible = IsAllowEdit; } else { btnUndo.Visible = false; } view = new DataView(table); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } return(view); }