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) { ECostAllocationDetail obj = new ECostAllocationDetail(); obj.PayRecID = Int32.Parse(h.Value); list.Add(obj); } } ECostAllocation costAllocation = new ECostAllocation(); costAllocation.CostAllocationID = int.Parse(CostAllocationID.Value); if (ECostAllocation.db.select(dbConn, costAllocation)) { WebUtils.StartFunction(Session, m_FunctionCode, costAllocation.EmpID); foreach (ECostAllocationDetail obj in list) { db.delete(dbConn, obj); } WebUtils.EndFunction(dbConn); } view = loadData(info, db, Repeater); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { ECostAllocationDetail obj = new ECostAllocationDetail(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); Hashtable values = new Hashtable(); db.populate(obj, values); dblTotalAmount += obj.CostAllocationDetailAmount; if (e.Item.ItemIndex == Repeater.EditItemIndex) { Binding eBinding; eBinding = new Binding(dbConn, db); eBinding.add(CostAllocationID); eBinding.add((HtmlInputHidden)e.Item.FindControl("CostAllocationDetailID")); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PaymentCodeID"), EPaymentCode.VLPaymentCode)); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("CostCenterID"), ECostCenter.VLCostCenter)); eBinding.add((TextBox)e.Item.FindControl("CostAllocationDetailAmount")); eBinding.init(Request, Session); eBinding.toControl(values); } else { e.Item.FindControl("Edit").Visible = true & IsAllowEdit; //if (EmpPayStatus.Value == "C" && obj.PayRecType != "A") //{ // e.Item.FindControl("Edit").Visible = false & IsAllowEdit; // e.Item.FindControl("DeleteItem").Visible = false; //} //else //{ // e.Item.FindControl("Edit").Visible = true & IsAllowEdit; // e.Item.FindControl("DeleteItem").Visible = true & IsAllowEdit; //} HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("CostAllocationDetailID"); h.Value = ((DataRowView)e.Item.DataItem)["CostAllocationDetailID"].ToString(); } e.Item.FindControl("DeleteItem").Visible = false;// true & IsAllowEdit; HROne.Common.WebUtility.WebControlsLocalization(Session, e.Item.Controls); }
protected void Add_Click(object sender, EventArgs e) { Repeater.EditItemIndex = -1; ECostAllocationDetail c = new ECostAllocationDetail(); 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); if (!errors.isEmpty()) { return; } ECostAllocation costAllocation = new ECostAllocation(); costAllocation.CostAllocationID = c.CostAllocationID; if (ECostAllocation.db.select(dbConn, costAllocation)) { WebUtils.StartFunction(Session, m_FunctionCode, costAllocation.EmpID); db.insert(dbConn, c); WebUtils.EndFunction(dbConn); } view = loadData(info, db, Repeater); }
public static string GetValueFromID(DatabaseConnection dbConn, string fieldName, string fieldValue) { try { string tmpfieldName = fieldName; if (tmpfieldName.Equals("PreviousEmpID", StringComparison.CurrentCultureIgnoreCase) || tmpfieldName.Equals("NewEmpID", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "EmpID"; } if (tmpfieldName.EndsWith("PaymentCodeID", StringComparison.CurrentCultureIgnoreCase) || tmpfieldName.EndsWith("PayCodeID", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "PaymentCodeID"; } if (tmpfieldName.Equals("DefaultMPFPlanID", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "MPFPlanID"; } if (tmpfieldName.Equals("AttendanceFormulaPayFormID", StringComparison.CurrentCultureIgnoreCase) || tmpfieldName.Equals("ReferencePayFormID", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "PayFormID"; } if (tmpfieldName.StartsWith("LeaveCode", StringComparison.CurrentCultureIgnoreCase) && tmpfieldName.EndsWith("Formula", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "PayFormID"; } if (tmpfieldName.StartsWith("PayGroup", StringComparison.CurrentCultureIgnoreCase) && tmpfieldName.EndsWith("Formula", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "PayFormID"; } if (tmpfieldName.Equals("CurrentPayPeriodID", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "PayPeriodID"; } if (tmpfieldName.Equals("EmpPosDefaultRosterCodeID", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "RosterCodeID"; } if (tmpfieldName.Equals("RosterClientMappingSiteCodeToHLevelID", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "HLevelID"; } if (tmpfieldName.Equals("EmpFirstAuthorizationGp", StringComparison.CurrentCultureIgnoreCase) || tmpfieldName.Equals("EmpSecondAuthorizationGp", StringComparison.CurrentCultureIgnoreCase)) { tmpfieldName = "AuthorizationGroupID"; } if (tmpfieldName.StartsWith("A", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("ALProrataRoundingRuleID", StringComparison.CurrentCultureIgnoreCase)) { EALProrataRoundingRule obj = new EALProrataRoundingRule(); obj.ALProrataRoundingRuleID = int.Parse(fieldValue); if (EALProrataRoundingRule.db.select(dbConn, obj)) { return(obj.ALProrataRoundingRuleCode + " - " + obj.ALProrataRoundingRuleDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("AttendancePlanID", StringComparison.CurrentCultureIgnoreCase)) { EAttendancePlan obj = new EAttendancePlan(); obj.AttendancePlanID = int.Parse(fieldValue); if (EAttendancePlan.db.select(dbConn, obj)) { return(obj.AttendancePlanCode + " - " + obj.AttendancePlanDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("AuthorizationGroupID", StringComparison.CurrentCultureIgnoreCase)) { EAuthorizationGroup obj = new EAuthorizationGroup(); obj.AuthorizationGroupID = int.Parse(fieldValue); if (EAuthorizationGroup.db.select(dbConn, obj)) { return(obj.AuthorizationCode + " - " + obj.AuthorizationDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("AVCPlanID", StringComparison.CurrentCultureIgnoreCase)) { EAVCPlan obj = new EAVCPlan(); obj.AVCPlanID = int.Parse(fieldValue); if (EAVCPlan.db.select(dbConn, obj)) { return(obj.AVCPlanCode + " - " + obj.AVCPlanDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("C", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("CessationReasonID", StringComparison.CurrentCultureIgnoreCase)) { ECessationReason obj = new ECessationReason(); obj.CessationReasonID = int.Parse(fieldValue); if (ECessationReason.db.select(dbConn, obj)) { return(obj.CessationReasonCode + " - " + obj.CessationReasonDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("CompanyID", StringComparison.CurrentCultureIgnoreCase)) { ECompany obj = new ECompany(); obj.CompanyID = int.Parse(fieldValue); if (ECompany.db.select(dbConn, obj)) { return(obj.CompanyCode + " - " + obj.CompanyName); } else { return(string.Empty); } } if (tmpfieldName.Equals("CostAllocationDetailID", StringComparison.CurrentCultureIgnoreCase)) { ECostAllocationDetail obj = new ECostAllocationDetail(); obj.CostAllocationDetailID = int.Parse(fieldValue); if (ECostAllocationDetail.db.select(dbConn, obj)) { return(GetValueFromID(dbConn, "PayCodeID", obj.PaymentCodeID.ToString()) + ", " + GetValueFromID(dbConn, "CostCenterID", obj.CostCenterID.ToString())); } else { return(string.Empty); } } if (tmpfieldName.Equals("CostAllocationID", StringComparison.CurrentCultureIgnoreCase)) { ECostAllocation obj = new ECostAllocation(); obj.CostAllocationID = int.Parse(fieldValue); if (ECostAllocation.db.select(dbConn, obj)) { return(GetValueFromID(dbConn, "EmpPayrollID", obj.EmpPayrollID.ToString())); } else { return(string.Empty); } } if (tmpfieldName.Equals("CostCenterID", StringComparison.CurrentCultureIgnoreCase)) { ECostCenter obj = new ECostCenter(); obj.CostCenterID = int.Parse(fieldValue); if (ECostCenter.db.select(dbConn, obj)) { return(obj.CostCenterCode + " - " + obj.CostCenterDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("D", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("DocumentTypeID", StringComparison.CurrentCultureIgnoreCase)) { EDocumentType obj = new EDocumentType(); obj.DocumentTypeID = int.Parse(fieldValue); if (EDocumentType.db.select(dbConn, obj)) { return(obj.DocumentTypeCode + " - " + obj.DocumentTypeDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("E", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("EmpAccID", StringComparison.CurrentCultureIgnoreCase)) { EEmpBankAccount obj = new EEmpBankAccount(); obj.EmpBankAccountID = int.Parse(fieldValue); if (EEmpBankAccount.db.select(dbConn, obj)) { return(obj.EmpBankCode + "-" + obj.EmpBranchCode + "-" + obj.EmpAccountNo); } //return obj.EmpBankCode + "-" + obj.EmpBranchCode + "-" + string.Empty.PadRight(obj.EmpAccountNo.Length, 'X'); else { return(string.Empty); } } if (tmpfieldName.Equals("EmpCostCenterID", StringComparison.CurrentCultureIgnoreCase)) { EEmpCostCenter obj = new EEmpCostCenter(); obj.EmpCostCenterID = int.Parse(fieldValue); if (EEmpCostCenter.db.select(dbConn, obj)) { return(GetValueFromID(dbConn, "EmpID", obj.EmpID.ToString())); } else { return(string.Empty); } } if (tmpfieldName.Equals("EmpExtraFieldID", StringComparison.CurrentCultureIgnoreCase)) { EEmpExtraField obj = new EEmpExtraField(); obj.EmpExtraFieldID = int.Parse(fieldValue); if (EEmpExtraField.db.select(dbConn, obj)) { return(obj.EmpExtraFieldName); } else { return(string.Empty); } } if (tmpfieldName.Equals("EmpID", StringComparison.CurrentCultureIgnoreCase)) { EEmpPersonalInfo obj = new EEmpPersonalInfo(); obj.EmpID = int.Parse(fieldValue); if (EEmpPersonalInfo.db.select(dbConn, obj)) { return(obj.EmpNo + " - " + obj.EmpEngFullName); } else { return(string.Empty); } } if (tmpfieldName.Equals("EmpPayrollID", StringComparison.CurrentCultureIgnoreCase)) { EEmpPayroll obj = new EEmpPayroll(); obj.EmpPayrollID = int.Parse(fieldValue); if (EEmpPayroll.db.select(dbConn, obj)) { return(GetValueFromID(dbConn, "EmpID", obj.EmpID.ToString()) + " : " + GetValueFromID(dbConn, "PayPeriodID", obj.PayPeriodID.ToString())); } else { return(string.Empty); } } if (tmpfieldName.Equals("EmpPosID", StringComparison.CurrentCultureIgnoreCase)) { EEmpPositionInfo obj = new EEmpPositionInfo(); obj.EmpPosID = int.Parse(fieldValue); if (EEmpPositionInfo.db.select(dbConn, obj)) { return(obj.EmpPosEffFr.ToString("yyyy-MM-dd") + " - " + (obj.EmpPosEffTo.Ticks.Equals(0) ? "Present" : obj.EmpPosEffTo.ToString("yyyy-MM-dd"))); } else { return(string.Empty); } } if (tmpfieldName.Equals("EmploymentTypeID", StringComparison.CurrentCultureIgnoreCase)) { EEmploymentType obj = new EEmploymentType(); obj.EmploymentTypeID = int.Parse(fieldValue); if (EEmploymentType.db.select(dbConn, obj)) { return(obj.EmploymentTypeCode + " - " + obj.EmploymentTypeDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("F", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("FunctionID", StringComparison.CurrentCultureIgnoreCase)) { ESystemFunction obj = new ESystemFunction(); obj.FunctionID = int.Parse(fieldValue); if (ESystemFunction.db.select(dbConn, obj)) { return(obj.FunctionCode + " - " + obj.Description); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("H", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("HElementID", StringComparison.CurrentCultureIgnoreCase)) { EHierarchyElement obj = new EHierarchyElement(); obj.HElementID = int.Parse(fieldValue); if (EHierarchyElement.db.select(dbConn, obj)) { return(obj.HElementCode + " - " + obj.HElementDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("HLevelID", StringComparison.CurrentCultureIgnoreCase)) { EHierarchyLevel obj = new EHierarchyLevel(); obj.HLevelID = int.Parse(fieldValue); if (EHierarchyLevel.db.select(dbConn, obj)) { return(obj.HLevelCode + " - " + obj.HLevelDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("L", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("LeaveTypeID", StringComparison.CurrentCultureIgnoreCase)) { ELeaveType obj = new ELeaveType(); obj.LeaveTypeID = int.Parse(fieldValue); if (ELeaveType.db.select(dbConn, obj)) { return(obj.LeaveType + " - " + obj.LeaveTypeDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("LeaveCodeID", StringComparison.CurrentCultureIgnoreCase)) { ELeaveCode obj = new ELeaveCode(); obj.LeaveCodeID = int.Parse(fieldValue); if (ELeaveCode.db.select(dbConn, obj)) { return(obj.LeaveCode + " - " + obj.LeaveCodeDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("LeavePlanID", StringComparison.CurrentCultureIgnoreCase)) { ELeavePlan obj = new ELeavePlan(); obj.LeavePlanID = int.Parse(fieldValue); if (ELeavePlan.db.select(dbConn, obj)) { return(obj.LeavePlanCode + " - " + obj.LeavePlanDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("M", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("MPFPlanID", StringComparison.CurrentCultureIgnoreCase)) { EMPFPlan obj = new EMPFPlan(); obj.MPFPlanID = int.Parse(fieldValue); if (EMPFPlan.db.select(dbConn, obj)) { return(obj.MPFPlanCode + " - " + obj.MPFPlanDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("MPFSchemeID", StringComparison.CurrentCultureIgnoreCase)) { EMPFScheme obj = new EMPFScheme(); obj.MPFSchemeID = int.Parse(fieldValue); if (EMPFScheme.db.select(dbConn, obj)) { return(obj.MPFSchemeCode + " - " + obj.MPFSchemeDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("MPFSchemeCessationReasonID", StringComparison.CurrentCultureIgnoreCase)) { EMPFSchemeCessationReason obj = new EMPFSchemeCessationReason(); obj.MPFSchemeCessationReasonID = int.Parse(fieldValue); if (EMPFSchemeCessationReason.db.select(dbConn, obj)) { return(obj.MPFSchemeCessationReasonCode + " - " + obj.MPFSchemeCessationReasonDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("O", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("ORSOPlanID", StringComparison.CurrentCultureIgnoreCase)) { EORSOPlan obj = new EORSOPlan(); obj.ORSOPlanID = int.Parse(fieldValue); if (EORSOPlan.db.select(dbConn, obj)) { return(obj.ORSOPlanCode + " - " + obj.ORSOPlanDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("P", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("PayGroupID", StringComparison.CurrentCultureIgnoreCase) || tmpfieldName.Equals("PayrollGroupID", StringComparison.CurrentCultureIgnoreCase)) { EPayrollGroup obj = new EPayrollGroup(); obj.PayGroupID = int.Parse(fieldValue); if (EPayrollGroup.db.select(dbConn, obj)) { return(obj.PayGroupCode + " - " + obj.PayGroupDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("PayFormID", StringComparison.CurrentCultureIgnoreCase)) { EPayrollProrataFormula obj = new EPayrollProrataFormula(); obj.PayFormID = int.Parse(fieldValue); if (EPayrollProrataFormula.db.select(dbConn, obj)) { return(obj.PayFormCode + " - " + obj.PayFormDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("PaymentCodeID", StringComparison.CurrentCultureIgnoreCase) || tmpfieldName.Equals("PayCodeID", StringComparison.CurrentCultureIgnoreCase)) { EPaymentCode obj = new EPaymentCode(); obj.PaymentCodeID = int.Parse(fieldValue); if (EPaymentCode.db.select(dbConn, obj)) { return(obj.PaymentCode + " - " + obj.PaymentCodeDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("PaymentTypeID", StringComparison.CurrentCultureIgnoreCase)) { EPaymentType obj = new EPaymentType(); obj.PaymentTypeID = int.Parse(fieldValue); if (EPaymentType.db.select(dbConn, obj)) { return(obj.PaymentTypeCode + " - " + obj.PaymentTypeDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("PayPeriodID", StringComparison.CurrentCultureIgnoreCase)) { EPayrollPeriod obj = new EPayrollPeriod(); obj.PayPeriodID = int.Parse(fieldValue); if (EPayrollPeriod.db.select(dbConn, obj)) { return(GetValueFromID(dbConn, "PayrollGroupID", obj.PayGroupID.ToString()) + ": " + obj.PayPeriodFr.ToString("yyyy-MM-dd") + " to " + obj.PayPeriodTo.ToString("yyyy-MM-dd")); } else { return(string.Empty); } } if (tmpfieldName.Equals("PermitTypeID", StringComparison.CurrentCultureIgnoreCase)) { EPermitType obj = new EPermitType(); obj.PermitTypeID = int.Parse(fieldValue); if (EPermitType.db.select(dbConn, obj)) { return(obj.PermitTypeCode + " - " + obj.PermitTypeDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("PositionID", StringComparison.CurrentCultureIgnoreCase)) { EPosition obj = new EPosition(); obj.PositionID = int.Parse(fieldValue); if (EPosition.db.select(dbConn, obj)) { return(obj.PositionCode + " - " + obj.PositionDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("Q", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("QualificationID", StringComparison.CurrentCultureIgnoreCase)) { EQualification obj = new EQualification(); obj.QualificationID = int.Parse(fieldValue); if (EQualification.db.select(dbConn, obj)) { return(obj.QualificationCode + " - " + obj.QualificationDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("R", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("RankID", StringComparison.CurrentCultureIgnoreCase)) { ERank obj = new ERank(); obj.RankID = int.Parse(fieldValue); if (ERank.db.select(dbConn, obj)) { return(obj.RankCode + " - " + obj.RankDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("ReminderTypeID", StringComparison.CurrentCultureIgnoreCase)) { EReminderType obj = new EReminderType(); obj.ReminderTypeID = int.Parse(fieldValue); if (EReminderType.db.select(dbConn, obj)) { return(obj.ReminderTypeCode + " - " + obj.ReminderTypeDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("RosterClientID", StringComparison.CurrentCultureIgnoreCase)) { ERosterClient obj = new ERosterClient(); obj.RosterClientID = int.Parse(fieldValue); if (ERosterClient.db.select(dbConn, obj)) { return(obj.RosterClientCode + " - " + obj.RosterClientName); } else { return(string.Empty); } } if (tmpfieldName.Equals("RosterClientSiteID", StringComparison.CurrentCultureIgnoreCase)) { ERosterClientSite obj = new ERosterClientSite(); obj.RosterClientSiteID = int.Parse(fieldValue); if (ERosterClientSite.db.select(dbConn, obj)) { return(obj.RosterClientSiteCode); } else { return(string.Empty); } } if (tmpfieldName.Equals("RosterCodeID", StringComparison.CurrentCultureIgnoreCase)) { ERosterCode obj = new ERosterCode(); obj.RosterCodeID = int.Parse(fieldValue); if (ERosterCode.db.select(dbConn, obj)) { return(obj.RosterCode + " - " + obj.RosterCodeDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("S", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("SkillID", StringComparison.CurrentCultureIgnoreCase)) { ESkill obj = new ESkill(); obj.SkillID = int.Parse(fieldValue); if (ESkill.db.select(dbConn, obj)) { return(obj.SkillCode + " - " + obj.SkillDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("SkillLevelID", StringComparison.CurrentCultureIgnoreCase)) { ESkillLevel obj = new ESkillLevel(); obj.SkillLevelID = int.Parse(fieldValue); if (ESkillLevel.db.select(dbConn, obj)) { return(obj.SkillLevelCode + " - " + obj.SkillLevelDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("StaffTypeID", StringComparison.CurrentCultureIgnoreCase)) { EStaffType obj = new EStaffType(); obj.StaffTypeID = int.Parse(fieldValue); if (EStaffType.db.select(dbConn, obj)) { return(obj.StaffTypeCode + " - " + obj.StaffTypeDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("T", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("TaxCompID", StringComparison.CurrentCultureIgnoreCase)) { ETaxCompany obj = new ETaxCompany(); obj.TaxCompID = int.Parse(fieldValue); if (ETaxCompany.db.select(dbConn, obj)) { return(obj.TaxCompEmployerName); } else { return(string.Empty); } } if (tmpfieldName.Equals("TaxEmpID", StringComparison.CurrentCultureIgnoreCase)) { ETaxEmp obj = new ETaxEmp(); obj.TaxEmpID = int.Parse(fieldValue); if (ETaxEmp.db.select(dbConn, obj)) { return(obj.TaxEmpSurname + ", " + obj.TaxEmpOtherName + ", " + GetValueFromID(dbConn, "TaxFormID", obj.TaxFormID.ToString())); } else { return(string.Empty); } } if (tmpfieldName.Equals("TaxFormID", StringComparison.CurrentCultureIgnoreCase)) { ETaxForm obj = new ETaxForm(); obj.TaxFormID = int.Parse(fieldValue); if (ETaxForm.db.select(dbConn, obj)) { return("Tax Year :" + obj.TaxFormYear + ", Form: IR56" + obj.TaxFormType); } else { return(string.Empty); } } if (tmpfieldName.Equals("TaxPayID", StringComparison.CurrentCultureIgnoreCase)) { ETaxPayment obj = new ETaxPayment(); obj.TaxPayID = int.Parse(fieldValue); if (ETaxPayment.db.select(dbConn, obj)) { return(obj.TaxPayCode + " - " + obj.TaxPayDesc); } else { return(string.Empty); } } if (tmpfieldName.Equals("TrainingCourseID", StringComparison.CurrentCultureIgnoreCase)) { ETrainingCourse obj = new ETrainingCourse(); obj.TrainingCourseID = int.Parse(fieldValue); if (ETrainingCourse.db.select(dbConn, obj)) { return(obj.TrainingCourseCode + " - " + obj.TrainingCourseName); } else { return(string.Empty); } } if (tmpfieldName.Equals("TrainingSeminarID", StringComparison.CurrentCultureIgnoreCase)) { ETrainingSeminar obj = new ETrainingSeminar(); obj.TrainingSeminarID = int.Parse(fieldValue); if (ETrainingSeminar.db.select(dbConn, obj)) { return(GetValueFromID(dbConn, "TrainingCourseID", obj.TrainingCourseID.ToString()) + ": " + obj.TrainingSeminarDateFrom.ToString("yyyy-MM-dd") + " to " + obj.TrainingSeminarDateTo.ToString("yyyy-MM-dd")); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("U", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("UserID", StringComparison.CurrentCultureIgnoreCase)) { EUser obj = new EUser(); obj.UserID = int.Parse(fieldValue); if (EUser.db.select(dbConn, obj)) { return(obj.LoginID + " - " + obj.UserName); } else { return(string.Empty); } } if (tmpfieldName.Equals("UserGroupID", StringComparison.CurrentCultureIgnoreCase)) { EUserGroup obj = new EUserGroup(); obj.UserGroupID = int.Parse(fieldValue); if (EUserGroup.db.select(dbConn, obj)) { return(obj.UserGroupName + " - " + obj.UserGroupDesc); } else { return(string.Empty); } } } else if (tmpfieldName.StartsWith("Y", StringComparison.CurrentCultureIgnoreCase)) { if (tmpfieldName.Equals("YebPlanID", StringComparison.CurrentCultureIgnoreCase)) { EYEBPlan obj = new EYEBPlan(); obj.YEBPlanID = int.Parse(fieldValue); if (EYEBPlan.db.select(dbConn, obj)) { return(obj.YEBPlanCode + " - " + obj.YEBPlanDesc); } else { return(string.Empty); } } } if (tmpfieldName.EndsWith("ID") && !tmpfieldName.EndsWith("HKID") && !tmpfieldName.EndsWith("LoginID") && !tmpfieldName.EndsWith("CurrencyID") && !tmpfieldName.EndsWith("LeaveAppID") && !tmpfieldName.EndsWith("EmpPaymentID") && !tmpfieldName.EndsWith("PayBatchID") && !tmpfieldName.EndsWith("PayRecID") && !tmpfieldName.EndsWith("RosterTableID") && !tmpfieldName.EndsWith("SynID") && !tmpfieldName.EndsWith("CNDImportBatchID")) { if (ESystemParameter.getParameter(dbConn, "DebugMode").Equals("Y")) { throw new Exception("ID field not define:" + fieldName); } } return(string.Empty); } catch (Exception ex) { if (ESystemParameter.getParameter(dbConn, "DebugMode").Equals("Y")) { throw ex; } else { return(string.Empty); } } }
private ArrayList CreateCostAllocationRecordList(DateTime startDate, DateTime endDate, ArrayList empPosList, ArrayList empCostCenterList, int PaymentCodeID, double Amount, int PaymentRecordID, bool IsContribution, int overrideCostCenterID) { if (!Amount.Equals(0)) { ArrayList costAllocationDetailList = new ArrayList(); int daysTotal = 0; foreach (EEmpPositionInfo empPos in empPosList) { DateTime posStartDate = startDate; DateTime posEndDate = endDate; if (empPos.EmpPosEffFr > posStartDate) { posStartDate = empPos.EmpPosEffFr; } if (!empPos.EmpPosEffTo.Ticks.Equals(0)) { if (empPos.EmpPosEffTo < posEndDate) { if (empPos.EmpPosEffTo >= posStartDate) { posEndDate = empPos.EmpPosEffTo; } else { posEndDate = new DateTime(); } } } DBFilter empHierarchyElementFilter = new DBFilter(); empHierarchyElementFilter.add(new Match("EmpPosID", empPos.EmpPosID)); ArrayList empHiererchyElementList = EEmpHierarchy.db.select(dbConn, empHierarchyElementFilter); ECostCenter overrideCostCenter = new ECostCenter(); overrideCostCenter.CostCenterID = overrideCostCenterID; if (ECostCenter.db.select(dbConn, overrideCostCenter)) { DateTime costStartDate = posStartDate; DateTime costEndDate = posEndDate; int numOfDays = ((TimeSpan)costEndDate.AddDays(1).Subtract(costStartDate)).Days; daysTotal += numOfDays; ECostAllocationDetail costAllocDetail = new ECostAllocationDetail(); costAllocDetail.HierarchyElementList = new ArrayList(); costAllocDetail.CostCenterID = overrideCostCenterID; costAllocDetail.CostAllocationDetailRoundCalAmount = Amount * numOfDays * 100; costAllocDetail.PaymentCodeID = PaymentCodeID; costAllocDetail.PayRecID = PaymentRecordID; costAllocDetail.CompanyID = empPos.CompanyID; costAllocDetail.CostAllocationDetailIsContribution = IsContribution; costAllocationDetailList.Add(costAllocDetail); foreach (EEmpHierarchy empHierarchy in empHiererchyElementList) { ECostAllocationDetailHElement costAllocHierarchy = new ECostAllocationDetailHElement(); costAllocHierarchy.HElementID = empHierarchy.HElementID; costAllocHierarchy.HLevelID = empHierarchy.HLevelID; costAllocHierarchy.RelatedCostAllocationDetailObject = costAllocDetail; costAllocDetail.HierarchyElementList.Add(costAllocHierarchy); } } else { //double percentagePaymentTotal = 0; foreach (EEmpCostCenter empCostCenter in empCostCenterList) { DateTime costStartDate = posStartDate; DateTime costEndDate = posEndDate; if (empCostCenter.EmpCostCenterEffFr > costStartDate) { costStartDate = empCostCenter.EmpCostCenterEffFr; } if (!empCostCenter.EmpCostCenterEffTo.Ticks.Equals(0)) { if (empCostCenter.EmpCostCenterEffTo < costEndDate) { if (empCostCenter.EmpCostCenterEffTo >= costStartDate) { costEndDate = empCostCenter.EmpCostCenterEffTo; } else { costEndDate = new DateTime(); } } } if (costStartDate > costEndDate) { continue; } int numOfDays = ((TimeSpan)costEndDate.AddDays(1).Subtract(costStartDate)).Days; daysTotal += numOfDays; DBFilter empCostCenterDetailFilter = new DBFilter(); empCostCenterDetailFilter.add(new Match("EmpCostCenterID", empCostCenter.EmpCostCenterID)); ArrayList empCostCenterDetailList = EEmpCostCenterDetail.db.select(dbConn, empCostCenterDetailFilter); double percentageCostCenterTotal = 0; foreach (EEmpCostCenterDetail empCostCenterDetail in empCostCenterDetailList) { ECostAllocationDetail costAllocDetail = new ECostAllocationDetail(); costAllocDetail.HierarchyElementList = new ArrayList(); costAllocDetail.CostCenterID = empCostCenterDetail.CostCenterID; costAllocDetail.CostAllocationDetailRoundCalAmount = Amount * numOfDays * empCostCenterDetail.EmpCostCenterPercentage; costAllocDetail.PaymentCodeID = PaymentCodeID; costAllocDetail.PayRecID = PaymentRecordID; costAllocDetail.CompanyID = empPos.CompanyID; costAllocDetail.CostAllocationDetailIsContribution = IsContribution; costAllocationDetailList.Add(costAllocDetail); foreach (EEmpHierarchy empHierarchy in empHiererchyElementList) { ECostAllocationDetailHElement costAllocHierarchy = new ECostAllocationDetailHElement(); costAllocHierarchy.HElementID = empHierarchy.HElementID; costAllocHierarchy.HLevelID = empHierarchy.HLevelID; costAllocHierarchy.RelatedCostAllocationDetailObject = costAllocDetail; costAllocDetail.HierarchyElementList.Add(costAllocHierarchy); } percentageCostCenterTotal += empCostCenterDetail.EmpCostCenterPercentage; } if (Math.Round(Math.Abs(percentageCostCenterTotal - 100), 2, MidpointRounding.AwayFromZero) > 0) { throw new Exception(HROne.Common.WebUtility.GetLocalizedStringByCode(ERROR_TOTAL_PERCENTAGE_NOT_100, "Total percentage must be 100%.") + "(" + HROne.Common.WebUtility.GetLocalizedStringByCode("EmpNo", "Employee No") + ": {0})"); } } } } double totalCostAllocPayment = 0; foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailList) { costAllocationDetail.CostAllocationDetailRoundCalAmount = costAllocationDetail.CostAllocationDetailRoundCalAmount / (100 * daysTotal); costAllocationDetail.CostAllocationDetailAmount = Math.Round(costAllocationDetail.CostAllocationDetailRoundCalAmount, 2, MidpointRounding.AwayFromZero); totalCostAllocPayment += costAllocationDetail.CostAllocationDetailAmount; } double diff = Math.Round(Amount - totalCostAllocPayment, 2, MidpointRounding.AwayFromZero); if (Math.Abs(diff) >= 0.01 && costAllocationDetailList.Count > 0) { if (diff > 0) { while (diff >= 0.01) { ECostAllocationDetail minCostAllocationDetail = null; double minDiff = 1; foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailList) { double costAllocDiff = costAllocationDetail.CostAllocationDetailAmount - costAllocationDetail.CostAllocationDetailRoundCalAmount; if (costAllocDiff < minDiff) { minDiff = costAllocDiff; minCostAllocationDetail = costAllocationDetail; } } if (minCostAllocationDetail != null) { minCostAllocationDetail.CostAllocationDetailAmount += 0.01; diff -= 0.01; } } } else { while (diff <= -0.01) { ECostAllocationDetail maxCostAllocationDetail = null; double maxDiff = -1; foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailList) { double costAllocDiff = costAllocationDetail.CostAllocationDetailAmount - costAllocationDetail.CostAllocationDetailRoundCalAmount; if (costAllocDiff > maxDiff) { maxDiff = costAllocDiff; maxCostAllocationDetail = costAllocationDetail; } } if (maxCostAllocationDetail != null) { maxCostAllocationDetail.CostAllocationDetailAmount -= 0.01; diff += 0.01; } } } } //costAllocationDetailList.AddRange(costAllocationDetailList); return(costAllocationDetailList); } else { return(new ArrayList()); } //ArrayList mpfRecordList = EMPFRecord.db.select(dbConn, paymentRecordFilter); //foreach (EMPFRecord mpfRecord in mpfRecordList) //{ // ArrayList costAllocationDetailListByMPFRecordMCEE = new ArrayList(); // ArrayList costAllocationDetailListByMPFRecordMCER = new ArrayList(); // ArrayList costAllocationDetailListByMPFRecordVCEE = new ArrayList(); // ArrayList costAllocationDetailListByMPFRecordVCER = new ArrayList(); // int daysTotal = 0; // foreach (EEmpPositionInfo empPos in empPosList) // { // DateTime posStartDate = startDate; // DateTime posEndDate = endDate; // if (empPos.EmpPosEffFr > posStartDate) // posStartDate = empPos.EmpPosEffFr; // if (empPos.EmpPosEffTo < posEndDate && empPos.EmpPosEffTo > posStartDate) // posEndDate = empPos.EmpPosEffTo; // DBFilter empHierarchyElementFilter = new DBFilter(); // empHierarchyElementFilter.add(new Match("EmpPosID", empPos.EmpPosID)); // ArrayList empHiererchyElementList = EEmpHierarchy.db.select(dbConn, empHierarchyElementFilter); // double percentagePaymentTotal = 0; // foreach (EEmpCostCenter empCostCenter in empCostCenterList) // { // DateTime costStartDate = posStartDate; // DateTime costEndDate = posEndDate; // if (empCostCenter.EmpCostCenterEffFr > costStartDate) // costStartDate = empCostCenter.EmpCostCenterEffFr; // if (empCostCenter.EmpCostCenterEffTo < costEndDate && empCostCenter.EmpCostCenterEffTo > costStartDate) // costEndDate = empCostCenter.EmpCostCenterEffTo; // if (costStartDate > costEndDate) // continue; // int numOfDays = ((TimeSpan)costEndDate.Subtract(costStartDate)).Days; // daysTotal += numOfDays; // DBFilter empCostCenterDetailFilter = new DBFilter(); // empCostCenterDetailFilter.add(new Match("EmpCostCenterID", empCostCenter.EmpCostCenterID)); // ArrayList empCostCenterDetailList = EEmpCostCenterDetail.db.select(dbConn, empCostCenterDetailFilter); // double percentageCostCenterTotal = 0; // foreach (EEmpCostCenterDetail empCostCenterDetail in empCostCenterDetailList) // { // ECostAllocationDetail costAllocMCEEDetail = new ECostAllocationDetail(); // ECostAllocationDetail costAllocMCERDetail = new ECostAllocationDetail(); // ECostAllocationDetail costAllocVCEEDetail = new ECostAllocationDetail(); // ECostAllocationDetail costAllocVCERDetail = new ECostAllocationDetail(); // costAllocMCEEDetail.CostCenterID = empCostCenterDetail.CostCenterID; // costAllocMCEEDetail.CostAllocationDetailRoundCalAmount = mpfRecord.MPFRecActMCEE * daysTotal * empCostCenterDetail.EmpCostCenterPercentage; // costAllocMCEEDetail.PaymentCodeID = ((EPaymentCode)PayrollProcess.GetPaymentCodeByPaymentType(dbConn, "MPFEE")[0]).PaymentCode; // costAllocMCEEDetail.PayRecID = mpfRecord.MPFRecordID; // costAllocMCEEDetail.CompanyID = empPos.CompanyID; // costAllocationDetailListByMPFRecordMCEE.Add(costAllocMCEEDetail); // foreach (EEmpHierarchy empHierarchy in empHiererchyElementList) // { // ECostAllocationDetailHElement costAllocHierarchy = new ECostAllocationDetailHElement(); // costAllocHierarchy.HElementID = empHierarchy.HElementID; // costAllocHierarchy.HLevelID = empHierarchy.HLevelID; // costAllocHierarchy.RelatedCostAllocationDetailObject = costAllocMCEEDetail; // costAllocationDetailHierarchyLIst.Add(costAllocHierarchy); // } // costAllocMCERDetail.CostCenterID = empCostCenterDetail.CostCenterID; // costAllocMCERDetail.CostAllocationDetailRoundCalAmount = mpfRecord.MPFRecActMCER * daysTotal * empCostCenterDetail.EmpCostCenterPercentage; // costAllocMCERDetail.PaymentCodeID = ((EPaymentCode)PayrollProcess.GetPaymentCodeByPaymentType(dbConn, "MPFER")[0]).PaymentCode; // costAllocMCERDetail.PayRecID = mpfRecord.MPFRecordID; // costAllocMCERDetail.CompanyID = empPos.CompanyID; // costAllocationDetailListByMPFRecordMCER.Add(costAllocMCERDetail); // foreach (EEmpHierarchy empHierarchy in empHiererchyElementList) // { // ECostAllocationDetailHElement costAllocHierarchy = new ECostAllocationDetailHElement(); // costAllocHierarchy.HElementID = empHierarchy.HElementID; // costAllocHierarchy.HLevelID = empHierarchy.HLevelID; // costAllocHierarchy.RelatedCostAllocationDetailObject = costAllocMCERDetail; // costAllocationDetailHierarchyLIst.Add(costAllocHierarchy); // } // costAllocVCEEDetail.CostCenterID = empCostCenterDetail.CostCenterID; // costAllocVCEEDetail.CostAllocationDetailRoundCalAmount = mpfRecord.MPFRecActVCEE * daysTotal * empCostCenterDetail.EmpCostCenterPercentage; // costAllocVCEEDetail.PaymentCodeID = ((EPaymentCode)PayrollProcess.GetPaymentCodeByPaymentType(dbConn, "TOPUPEE")[0]).PaymentCode; // costAllocVCEEDetail.PayRecID = mpfRecord.MPFRecordID; // costAllocVCEEDetail.CompanyID = empPos.CompanyID; // costAllocationDetailListByMPFRecordVCEE.Add(costAllocVCEEDetail); // foreach (EEmpHierarchy empHierarchy in empHiererchyElementList) // { // ECostAllocationDetailHElement costAllocHierarchy = new ECostAllocationDetailHElement(); // costAllocHierarchy.HElementID = empHierarchy.HElementID; // costAllocHierarchy.HLevelID = empHierarchy.HLevelID; // costAllocHierarchy.RelatedCostAllocationDetailObject = costAllocVCEEDetail; // costAllocationDetailHierarchyLIst.Add(costAllocHierarchy); // } // costAllocVCERDetail.CostCenterID = empCostCenterDetail.CostCenterID; // costAllocVCERDetail.CostAllocationDetailRoundCalAmount = mpfRecord.MPFRecActVCER * daysTotal * empCostCenterDetail.EmpCostCenterPercentage; // costAllocVCERDetail.PaymentCodeID = ((EPaymentCode)PayrollProcess.GetPaymentCodeByPaymentType(dbConn, "TOPUPER")[0]).PaymentCode; // costAllocVCERDetail.PayRecID = mpfRecord.MPFRecordID; // costAllocVCERDetail.CompanyID = empPos.CompanyID; // costAllocationDetailListByMPFRecordVCER.Add(costAllocVCERDetail); // foreach (EEmpHierarchy empHierarchy in empHiererchyElementList) // { // ECostAllocationDetailHElement costAllocHierarchy = new ECostAllocationDetailHElement(); // costAllocHierarchy.HElementID = empHierarchy.HElementID; // costAllocHierarchy.HLevelID = empHierarchy.HLevelID; // costAllocHierarchy.RelatedCostAllocationDetailObject = costAllocVCERDetail; // costAllocationDetailHierarchyLIst.Add(costAllocHierarchy); // } // percentageCostCenterTotal += empCostCenterDetail.EmpCostCenterPercentage; // } // if (Math.Round(Math.Abs(percentageCostCenterTotal - 100), 2, MidpointRounding.AwayFromZero) > 0) // { // errorLogBuiler.AppendLine( // string.Format( // HROne.Common.WebUtility.GetLocalizedStringByCode(MESSAGE_NOT_100_PERCENTAGE, "Total Percentage of Employee ({0}) is not 100%.") // , new string[] { empInfo.EmpNo }) // ); // } // } // } // //SortedList sortedCostAllocationDetailbyDecimalPlaceRoundDown = new SortedList(); // //SortedList sortedCostAllocationDetailbyDecimalPlaceRoundUp = new SortedList(); // double totalCostAllocPaymentMCEE = 0; // double totalCostAllocPaymentMCER = 0; // double totalCostAllocPaymentVCEE = 0; // double totalCostAllocPaymentVCER = 0; // foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailListByMPFRecordMCEE) // { // costAllocationDetail.CostAllocationDetailRoundCalAmount = costAllocationDetail.CostAllocationDetailRoundCalAmount / (100 * daysTotal); // costAllocationDetail.CostAllocationDetailAmount = Math.Round(costAllocationDetail.CostAllocationDetailRoundCalAmount, 2, MidpointRounding.AwayFromZero); // totalCostAllocPaymentMCEE += costAllocationDetail.CostAllocationDetailAmount; // } // foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailListByMPFRecordMCER) // { // costAllocationDetail.CostAllocationDetailRoundCalAmount = costAllocationDetail.CostAllocationDetailRoundCalAmount / (100 * daysTotal); // costAllocationDetail.CostAllocationDetailAmount = Math.Round(costAllocationDetail.CostAllocationDetailRoundCalAmount, 2, MidpointRounding.AwayFromZero); // totalCostAllocPaymentMCER += costAllocationDetail.CostAllocationDetailAmount; // } // foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailListByMPFRecordVCEE) // { // costAllocationDetail.CostAllocationDetailRoundCalAmount = costAllocationDetail.CostAllocationDetailRoundCalAmount / (100 * daysTotal); // costAllocationDetail.CostAllocationDetailAmount = Math.Round(costAllocationDetail.CostAllocationDetailRoundCalAmount, 2, MidpointRounding.AwayFromZero); // totalCostAllocPaymentVCEE += costAllocationDetail.CostAllocationDetailAmount; // } // foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailListByMPFRecordVCER) // { // costAllocationDetail.CostAllocationDetailRoundCalAmount = costAllocationDetail.CostAllocationDetailRoundCalAmount / (100 * daysTotal); // costAllocationDetail.CostAllocationDetailAmount = Math.Round(costAllocationDetail.CostAllocationDetailRoundCalAmount, 2, MidpointRounding.AwayFromZero); // totalCostAllocPaymentVCER += costAllocationDetail.CostAllocationDetailAmount; // } // double diff = Math.Round(mpfRecord.PayRecActAmount - totalCostAllocPayment, 2, MidpointRounding.AwayFromZero); // if (Math.Abs(diff) >= 0.01 && costAllocationDetailListByMPFRecord.Count > 0) // { // if (diff > 0) // { // while (Math.Abs(diff) >= 0.01) // { // ECostAllocationDetail minCostAllocationDetail = null; // double minDiff = 1; // foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailListByMPFRecord) // { // double costAllocDiff = costAllocationDetail.CostAllocationDetailAmount - costAllocationDetail.CostAllocationDetailRoundCalAmount; // if (costAllocDiff < minDiff) // { // minDiff = costAllocDiff; // minCostAllocationDetail = costAllocationDetail; // } // } // if (minCostAllocationDetail != null) // { // minCostAllocationDetail.CostAllocationDetailAmount += 0.01; // diff -= 0.01; // } // } // } // else // { // while (Math.Abs(diff) >= 0.01) // { // ECostAllocationDetail maxCostAllocationDetail = null; // double maxDiff = 1; // foreach (ECostAllocationDetail costAllocationDetail in costAllocationDetailListByMPFRecord) // { // double costAllocDiff = costAllocationDetail.CostAllocationDetailAmount - costAllocationDetail.CostAllocationDetailRoundCalAmount; // if (costAllocDiff > maxDiff) // { // maxDiff = costAllocDiff; // maxCostAllocationDetail = costAllocationDetail; // } // } // if (maxCostAllocationDetail != null) // { // maxCostAllocationDetail.CostAllocationDetailAmount -= 0.01; // diff += 0.01; // } // } // } // } // costAllocationDetailList.AddRange(costAllocationDetailListByMPFRecord); //} }
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); } else if (b.ID.Equals("Cancel")) { Repeater.EditItemIndex = -1; AddPanel.Visible = IsAllowEdit; view = loadData(info, db, Repeater); } else if (b.ID.Equals("Save")) { Binding eBinding; eBinding = new Binding(dbConn, db); eBinding.add(CostAllocationID); eBinding.add((HtmlInputHidden)e.Item.FindControl("CostAllocationDetailID")); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("PaymentCodeID"), EPaymentCode.VLPaymentCode)); eBinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("CostCenterID"), ECostCenter.VLCostCenter)); eBinding.add((TextBox)e.Item.FindControl("CostAllocationDetailAmount")); eBinding.init(Request, Session); ECostAllocationDetail obj = new ECostAllocationDetail(); 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); ECostAllocation costAllocation = new ECostAllocation(); costAllocation.CostAllocationID = obj.CostAllocationID; if (ECostAllocation.db.select(dbConn, costAllocation)) { WebUtils.StartFunction(Session, m_FunctionCode, costAllocation.EmpID); db.update(dbConn, obj); WebUtils.EndFunction(dbConn); } Repeater.EditItemIndex = -1; AddPanel.Visible = IsAllowEdit; view = loadData(info, db, Repeater); } }