public List <EPaymentRecord> GeneratePaymentRecordList() { List <EPaymentRecord> list = new List <EPaymentRecord>(); foreach (PaymentBreakDown breakDown in this.Values) { EPaymentRecord paymentRecord = new EPaymentRecord(); paymentRecord.CostCenterID = breakDown.key.CostCenterID; paymentRecord.CurrencyID = breakDown.key.CurrencyID; paymentRecord.EmpAccID = breakDown.key.EmpAccID; paymentRecord.PaymentCodeID = breakDown.key.PaymentCodeID; paymentRecord.PayRecCalAmount = breakDown.key.Rate * breakDown.unit * breakDown.key.RateMultiplier; paymentRecord.PayRecActAmount = HROne.CommonLib.GenericRoundingFunctions.RoundingTo(paymentRecord.PayRecCalAmount, HROne.Lib.ExchangeCurrency.DefaultCurrencyDecimalPlaces(), 9); paymentRecord.PayRecIsRestDayPayment = breakDown.key.IsRestDayPayment; paymentRecord.PayRecMethod = string.IsNullOrEmpty(breakDown.key.PaymentMethod) ? DefaultPayMethod : breakDown.key.PaymentMethod; paymentRecord.PayRecNumOfDayAdj = breakDown.DayAdjusts; paymentRecord.PayRecStatus = "A"; if (breakDown.key.IsGenerateRemark) { paymentRecord.PayRecRemark = (string.IsNullOrEmpty(breakDown.key.RateRemark) ? breakDown.key.Rate.ToString("#,##0.00######") : breakDown.key.RateRemark) + " x " + breakDown.unit.ToString() + (breakDown.key.RateMultiplier.Equals(1.0) ? string.Empty : " x " + breakDown.key.RateMultiplier.ToString()); } if (breakDown.relatedObjectList.Count > 0) { paymentRecord.RelatedObject = breakDown.relatedObjectList; } list.Add(paymentRecord); } return(list); }
protected void Delete_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("PayRecID"); if (c.Checked) { EPaymentRecord obj = new EPaymentRecord(); obj.PayRecID = Int32.Parse(h.Value); list.Add(obj); } } EEmpPayroll empPayroll = new EEmpPayroll(); empPayroll.EmpPayrollID = int.Parse(EmpPayrollID.Value); if (EEmpPayroll.db.select(dbConn, empPayroll)) { WebUtils.StartFunction(Session, m_FunctionCode, empPayroll.EmpID); foreach (EPaymentRecord obj in list) { if (db.select(dbConn, obj)) { db.delete(dbConn, obj); } } WebUtils.EndFunction(dbConn); } view = loadData(info, db, Repeater); //Response.Redirect(Request.Url.LocalPath + "?" + Request.QueryString); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { EPaymentRecord obj = new EPaymentRecord(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); Hashtable values = new Hashtable(); db.populate(obj, values); dblTotalPaymentAmount += obj.PayRecActAmount; if (e.Item.ItemIndex == Repeater.EditItemIndex) { Binding eBinding; eBinding = new Binding(dbConn, db); eBinding.add((HtmlInputHidden)e.Item.FindControl("PayRecID")); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PaymentCodeID"), EPaymentCode.VLPaymentCode)); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("CurrencyID"), Values.VLCurrency)); eBinding.add((TextBox)e.Item.FindControl("PayRecActAmount")); eBinding.add((TextBox)e.Item.FindControl("PayRecNumOfDayAdj")); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("CostCenterID"), ECostCenter.VLCostCenter).setNotSelected(HROne.Common.WebUtility.GetLocalizedString(ECostCenter.DEFAULT_COST_CENTER_TEXT))); eBinding.add(new CheckBoxBinder(db, (CheckBox)e.Item.FindControl("PayRecIsRestDayPayment"))); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PayRecMethod"), Values.VLPaymentMethod).setNotSelected(null)); eBinding.add((TextBox)e.Item.FindControl("PayRecRemark")); //DBFilter filter = new DBFilter(); //DBFilter inFilter = new DBFilter(); //inFilter.add(new Match("EmpPayrollID", EmpPayrollID.Value)); //filter.add(new IN("EmpID", "Select EmpID from EmpPayroll", inFilter)); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("EmpAccID"), EEmpBankAccount.VLBankAccount, empBankAccountFilter).setNotSelected(HROne.Common.WebUtility.GetLocalizedString(EEmpBankAccount.DEFAULT_BANK_ACCOUNT_TEXT))); eBinding.init(Request, Session); eBinding.toControl(values); if (EmpPayStatus.Value == "C" && obj.PayRecType != "A") { ((DropDownList)e.Item.FindControl("PaymentCodeID")).Enabled = false;; ((TextBox)e.Item.FindControl("PayRecActAmount")).Enabled = false; ((TextBox)e.Item.FindControl("PayRecNumOfDayAdj")).Enabled = false; //((TextBox)e.Item.FindControl("PayRecRemark")).Enabled = false; e.Item.FindControl("DeleteItem").Visible = false; } ((HtmlTableCell)e.Item.FindControl("CostCenterDetailCell")).Visible = WebUtils.productLicense(Session).IsCostCenter; ((HtmlTableCell)e.Item.FindControl("RemarkCell")).ColSpan = ((HtmlTableRow)e.Item.FindControl("detailRow")).Cells.Count - 5 - (WebUtils.productLicense(Session).IsCostCenter ? 0 : 1); } else { Binding eBinding; eBinding = new Binding(dbConn, db); eBinding.add((HtmlInputHidden)e.Item.FindControl("PayRecID")); //eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PaymentCodeID"), EPaymentCode.VLPaymentCode)); //eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("CurrencyID"), Values.VLCurrency)); //eBinding.add((TextBox)e.Item.FindControl("PayRecActAmount")); //eBinding.add((TextBox)e.Item.FindControl("PayRecNumOfDayAdj")); //eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PayRecMethod"), Values.VLPaymentMethod)); //eBinding.add((TextBox)e.Item.FindControl("PayRecRemark")); //DBFilter filter = new DBFilter(); //DBFilter inFilter = new DBFilter(); //inFilter.add(new Match("EmpPayrollID", EmpPayrollID.Value)); //filter.add(new IN("EmpID", "Select EmpID from EmpPayroll", inFilter)); eBinding.add(new BlankZeroLabelVLBinder(db, (Label)e.Item.FindControl("EmpAccID"), EEmpBankAccount.VLBankAccount, empBankAccountFilter).setTextDisplayForZero(HROne.Common.WebUtility.GetLocalizedString(EEmpBankAccount.DEFAULT_BANK_ACCOUNT_TEXT))); eBinding.add(new BlankZeroLabelVLBinder(db, (Label)e.Item.FindControl("CostCenterID"), ECostCenter.VLCostCenter).setTextDisplayForZero(HROne.Common.WebUtility.GetLocalizedString(ECostCenter.DEFAULT_COST_CENTER_TEXT))); eBinding.init(Request, Session); eBinding.toControl(values); e.Item.FindControl("Edit").Visible = IsAllowEdit; if (EmpPayStatus.Value == "C" && obj.PayRecType != "A") { e.Item.FindControl("DeleteItem").Visible = false; } else { e.Item.FindControl("DeleteItem").Visible = true & IsAllowEdit; } //HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("PayRecID"); //h.Value = ((DataRowView)e.Item.DataItem)["PayRecID"].ToString(); ((HtmlTableCell)e.Item.FindControl("CostCenterDetailCell")).Visible = WebUtils.productLicense(Session).IsCostCenter; ((HtmlTableCell)e.Item.FindControl("RemarkCell")).ColSpan = ((HtmlTableRow)e.Item.FindControl("detailRow")).Cells.Count - 5 - (WebUtils.productLicense(Session).IsCostCenter ? 0 : 1); } HROne.Common.WebUtility.WebControlsLocalization(Session, e.Item.Controls); }
protected void Repeater_ItemCommand(object source, DataListCommandEventArgs e) { Button b = (Button)e.CommandSource; if (b.ID.Equals("Edit")) { Repeater.EditItemIndex = e.Item.ItemIndex; //AddPanel.Visible = false; view = loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(AddPanel, false); } else if (b.ID.Equals("Cancel")) { Repeater.EditItemIndex = -1; //AddPanel.Visible = IsAllowEdit; view = loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(AddPanel, true); } else if (b.ID.Equals("Save")) { Binding eBinding; // Hard code set Currency to HKD ((DropDownList)e.Item.FindControl("CurrencyID")).SelectedValue = "HKD"; eBinding = new Binding(dbConn, db); eBinding.add(EmpPayrollID); eBinding.add((HtmlInputHidden)e.Item.FindControl("PayRecID")); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("CurrencyID"), Values.VLCurrency)); if (((DropDownList)e.Item.FindControl("PaymentCodeID")).Enabled) { eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PaymentCodeID"), EPaymentCode.VLPaymentCode)); } if (((TextBox)e.Item.FindControl("PayRecActAmount")).Enabled) { eBinding.add((TextBox)e.Item.FindControl("PayRecActAmount")); } if (((TextBox)e.Item.FindControl("PayRecNumOfDayAdj")).Enabled) { eBinding.add((TextBox)e.Item.FindControl("PayRecNumOfDayAdj")); } if (((TextBox)e.Item.FindControl("PayRecRemark")).Enabled) { eBinding.add((TextBox)e.Item.FindControl("PayRecRemark")); } eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("CostCenterID"), ECostCenter.VLCostCenter).setNotSelected(HROne.Common.WebUtility.GetLocalizedString(ECostCenter.DEFAULT_COST_CENTER_TEXT))); eBinding.add(new CheckBoxBinder(db, (CheckBox)e.Item.FindControl("PayRecIsRestDayPayment"))); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PayRecMethod"), Values.VLPaymentMethod).setNotSelected(null)); //DBFilter filter = new DBFilter(); //DBFilter inFilter = new DBFilter(); //inFilter.add(new Match("EmpPayrollID", EmpPayrollID.Value)); //filter.add(new IN("EmpID", "Select EmpID from EmpPayroll", inFilter)); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("EmpAccID"), EEmpBankAccount.VLBankAccount, empBankAccountFilter).setNotSelected(HROne.Common.WebUtility.GetLocalizedString(EEmpBankAccount.DEFAULT_BANK_ACCOUNT_TEXT))); eBinding.init(Request, Session); EPaymentRecord obj = new EPaymentRecord(); Hashtable values = new Hashtable(); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); eBinding.toValues(values); db.validate(errors, values); if (!errors.isEmpty()) { HROne.Common.WebUtility.WebControlsLocalization(Session, e.Item.Controls); return; } db.parse(values, obj); EEmpPayroll empPayroll = new EEmpPayroll(); empPayroll.EmpPayrollID = obj.EmpPayrollID; if (EEmpPayroll.db.select(dbConn, empPayroll)) { if (obj.PayRecMethod.Equals("A")) { if (obj.EmpAccID == 0) { EEmpBankAccount bankAccount = EEmpBankAccount.GetDefaultBankAccount(dbConn, empPayroll.EmpID); if (bankAccount != null) { //obj.EmpAccID = bankAccount.EmpBankAccountID; } else { errors.addError("EmpAccID", HROne.Translation.PageErrorMessage.ERROR_ACCOUNT_REQUIRED); } } } if (!errors.isEmpty()) { HROne.Common.WebUtility.WebControlsLocalization(Session, e.Item.Controls); return; } WebUtils.StartFunction(Session, m_FunctionCode, empPayroll.EmpID); db.update(dbConn, obj); WebUtils.EndFunction(dbConn); Repeater.EditItemIndex = -1; //AddPanel.Visible = IsAllowEdit; view = loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(AddPanel, true); } //Response.Redirect(Request.Url.LocalPath + "?" + Request.QueryString); } }
protected void Add_Click(object sender, EventArgs e) { // Hard code set Currency to HKD CurrencyID.SelectedValue = "HKD"; Repeater.EditItemIndex = -1; EPaymentRecord c = new EPaymentRecord(); Hashtable values = new Hashtable(); newBinding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); EEmpPayroll empPayroll = new EEmpPayroll(); empPayroll.EmpPayrollID = c.EmpPayrollID; if (EEmpPayroll.db.select(dbConn, empPayroll)) { if (c.PayRecMethod.Equals("A")) { if (c.EmpAccID == 0) { EEmpBankAccount bankAccount = EEmpBankAccount.GetDefaultBankAccount(dbConn, empPayroll.EmpID); if (bankAccount != null) { //c.EmpAccID = bankAccount.EmpBankAccountID; } else { errors.addError("EmpAccID", HROne.Translation.PageErrorMessage.ERROR_ACCOUNT_REQUIRED); } } } if (!errors.isEmpty()) { return; } c.PayRecCalAmount = 0; //c.PayRecNumOfDayAdj = 0; c.PayRecStatus = PaymentRecordStatus.PAYRECORDSTATUS_ACTIVE; if (EmpPayStatus.Value == "C") { c.PayRecType = PaymentRecordType.PAYRECORDTYPE_CONFIRM_ADJUSTMENT; } else { c.PayRecType = PaymentRecordType.PAYRECORDTYPE_TRIALRUN_ADJUSTMENT; } WebUtils.StartFunction(Session, m_FunctionCode, empPayroll.EmpID); db.insert(dbConn, c); WebUtils.EndFunction(dbConn); PaymentCodeID.SelectedIndex = 0; CurrencyID.SelectedIndex = 0; PayRecActAmount.Text = string.Empty; PayRecMethod.SelectedIndex = 0; PayRecNumOfDayAdj.Text = string.Empty; PayRecRemark.Text = string.Empty; view = loadData(info, db, Repeater); } //Response.Redirect(Request.Url.LocalPath + "?" + Request.QueryString); }