protected void Undo_Click(object sender, EventArgs e) { DBFilter filter = sbinding.createFilter(); filter.add("EmpID", true); // filter.add(new IN("PayRecID", "Select PayRecID from " + EPaymentRecord.db.dbclass.tableName + " pr", new DBFilter())); WebUtils.StartFunction(Session, FUNCTION_CODE); EDoublePayAdjustment.db.delete(dbConn, filter); EDoublePayAdjustmentImportBatch.db.delete(dbConn, filter); WebUtils.EndFunction(dbConn); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.addError("Upload Batch undone."); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Payroll_DoublePayAdjustment_Import_History.aspx"); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); EEmpBeneficiaries obj = new EEmpBeneficiaries(); obj.EmpBeneficiariesID = CurID; if (EEmpBeneficiaries.db.select(dbConn, obj)) { WebUtils.StartFunction(Session, FUNCTION_CODE, obj.EmpID); db.delete(dbConn, obj); WebUtils.EndFunction(dbConn); } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "EmpTab_Beneficiaries_View.aspx?EmpID=" + EmpID.Value); }
private void ValidateData(ETaxEmpPayment obj, PageErrors errors) { if (obj.TaxEmpPayPeriodFr > obj.TaxEmpPayPeriodTo) { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INCORRECT_DATE_RANGE); return; } ETaxEmp taxEmp = new ETaxEmp(); taxEmp.TaxEmpID = obj.TaxEmpID; if (ETaxEmp.db.select(dbConn, taxEmp)) { if (taxEmp.TaxEmpStartDate > obj.TaxEmpPayPeriodFr || taxEmp.TaxEmpEndDate < obj.TaxEmpPayPeriodTo) { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INCORRECT_DATE_RANGE); } } }
protected void btnConfirm_Click(object sender, EventArgs e) { ArrayList list = WebUtils.SelectedRepeaterItemToBaseObjectList(ECostAllocation.db, Repeater, "ItemSelect"); CostAllocationProcess costAllocationProcess = new CostAllocationProcess(dbConn); foreach (ECostAllocation obj in list) { ECostAllocation.db.select(dbConn, obj); WebUtils.StartFunction(Session, FUNCTION_CODE, obj.EmpID, true); costAllocationProcess.Confirm(obj.CostAllocationID, WebUtils.GetCurUser(Session)); WebUtils.EndFunction(dbConn); } PageErrors.getErrors(db, Page).addError("Complete"); view = loadData(info, EEmpPayroll.db, Repeater); }
protected void Save_Click(object sender, EventArgs e) { EEmpPermit c = new EEmpPermit(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); //if (!AppUtils.checkDuplicate(dbConn, CurEmpID, db, c, errors, "PermitTypeID")) // return; WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID); if (CurID < 0) { // Utils.MarkCreate(Session, c); db.insert(dbConn, c); CurID = c.EmpPermitID; // url = Utils.BuildURL(-1, CurID); } else { // Utils.Mark(Session, c); db.update(dbConn, c); } WebUtils.EndFunction(dbConn); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Emp_Permit_View.aspx?EmpPermitID=" + CurID + "&EmpID=" + c.EmpID); }
protected void Add_Click(object sender, EventArgs e) { Repeater.EditItemIndex = -1; EEmpWorkingSummary c = new EEmpWorkingSummary(); 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; } WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID); db.insert(dbConn, c); WebUtils.EndFunction(dbConn); EmpWorkingSummaryAsOfDate.Value = string.Empty; EmpWorkingSummaryRestDayEntitled.Text = string.Empty; EmpWorkingSummaryRestDayTaken.Text = string.Empty; EmpWorkingSummaryTotalWorkingDays.Text = string.Empty; EmpWorkingSummaryTotalWorkingHours.Text = string.Empty; EmpWorkingSummaryTotalLunchTimeHours.Text = string.Empty; loadData(info, db, Repeater); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); EAttendancePlan o = new EAttendancePlan(); o.AttendancePlanID = CurID; if (EAttendancePlan.db.select(dbConn, o)) { DBFilter empPosFilter = new DBFilter(); empPosFilter.add(new Match("AttendancePlanID", o.AttendancePlanID)); empPosFilter.add("EmpID", true); ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter); if (empPosList.Count > 0) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_CODE_USED_BY_EMPLOYEE, new string[] { HROne.Common.WebUtility.GetLocalizedString("Attendance Plan"), o.AttendancePlanCode })); foreach (EEmpPositionInfo empPos in empPosList) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = empPos.EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { errors.addError("- " + empInfo.EmpNo + ", " + empInfo.EmpEngFullName); } else { EEmpPositionInfo.db.delete(dbConn, empPos); } } errors.addError(HROne.Translation.PageErrorMessage.ERROR_ACTION_ABORT); return; } else { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, o); WebUtils.EndFunction(dbConn); } } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Attendance_Plan_List.aspx"); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(sdb, Page.Master); errors.clear(); ArrayList list = new ArrayList(); foreach (RepeaterItem i in Repeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); if (cb.Checked) { EEmpBankAccount o = new EEmpBankAccount(); WebFormUtils.GetKeys(sdb, o, cb); list.Add(o); } } foreach (EEmpBankAccount obj in list) { sdb.select(dbConn, obj); DBFilter paymentRecordFilter = new DBFilter(); paymentRecordFilter.add(new Match("EmpAccID", obj.EmpBankAccountID)); IN inTerms = new IN("EmpPayrollID", "Select EmpPayrollID From " + EPaymentRecord.db.dbclass.tableName, paymentRecordFilter); DBFilter empPayrollFilter = new DBFilter(); empPayrollFilter.add(inTerms); empPayrollFilter.add("empid", true); ArrayList empPayrollList = EEmpPayroll.db.select(dbConn, empPayrollFilter); if (empPayrollList.Count > 0) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_CODE_IS_IN_USE, new string[] { HROne.Common.WebUtility.GetLocalizedString("Bank Account") })); errors.addError(HROne.Translation.PageErrorMessage.ERROR_ACTION_ABORT); } else { WebUtils.StartFunction(Session, FUNCTION_CODE, obj.EmpID); sdb.delete(dbConn, obj); WebUtils.EndFunction(dbConn); } } loadData(info, sdb, Repeater); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ArrayList list = WebUtils.SelectedRepeaterItemToBaseObjectList(db, Repeater, "ItemSelect"); foreach (ERosterTableGroup o in list) { if (ERosterTableGroup.db.select(dbConn, o)) { DBFilter empPosFilter = new DBFilter(); empPosFilter.add(new Match("RosterTableGroupID", o.RosterTableGroupID)); empPosFilter.add("EmpID", true); ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter); if (empPosList.Count > 0) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_CODE_USED_BY_EMPLOYEE, new string[] { HROne.Common.WebUtility.GetLocalizedString("Roster Table Group"), o.RosterTableGroupCode })); foreach (EEmpPositionInfo empPos in empPosList) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = empPos.EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { errors.addError("- " + empInfo.EmpNo + ", " + empInfo.EmpEngFullName); } else { EEmpPositionInfo.db.delete(dbConn, empPos); } } errors.addError(HROne.Translation.PageErrorMessage.ERROR_ACTION_ABORT); } else { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, o); WebUtils.EndFunction(dbConn); } } } //loadData(info, db, Repeater); }
protected void btnSubmit_Click(object sender, EventArgs e) { PageErrors pageErrors = PageErrors.getErrors(null, this.Page); if (!IsValidPassCode(txtPassCode.Text)) { pageErrors.addError("Incorrect Pass Code!"); return; } HROne.CommonLib.Crypto crypto = new HROne.CommonLib.Crypto(HROne.CommonLib.Crypto.SymmProvEnum.Rijndael); Session["LoginID"] = crypto.Encrypting("EM", Session.SessionID); //EUser user = new EUser(); //user.UserID = -1; //user.LoginID = "EM"; //Session["User"] = user; Session["IgnoreEM"] = false; Session.Remove("User"); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/Default.aspx"); }
//public DBFilter getPayrollPeriodFilter() //{ // DBFilter filter = new DBFilter(); // filter.add(new Match("PayGroupID", CurPayGroupID)); // DateTime dtPayPeriodFr; // DateTime dtPayPeriodTo; // if (DateTime.TryParse(PayPeriodFr.Value, out dtPayPeriodFr) && DateTime.TryParse(PayPeriodTo.Value, out dtPayPeriodTo)) // { // filter.add(new Match("pp.PayPeriodFr", "<=", dtPayPeriodTo)); // filter.add(new Match("pp.PayPeriodTo", ">=", dtPayPeriodFr)); // } // return filter; //} protected void btnRollback_Click(object sender, EventArgs e) { PageErrors pageErrors = PageErrors.getErrors(db, Page.Master); if (!IsValidRollbackKey(txtPassCode.Text)) { pageErrors.addError("Incorrect pass code!"); return; } else { ArrayList payPeriodList = WebUtils.SelectedRepeaterItemToBaseObjectList(EPayrollPeriod.db, payPeriodRepeater, "ItemSelect"); if (payPeriodList.Count > 0) { WebUtils.StartFunction(Session, FUNCTION_CODE, true); foreach (EPayrollPeriod payPeriod in payPeriodList) { if (EPayrollPeriod.db.select(dbConn, payPeriod)) { payPeriod.PayPeriodStatus = "C"; EPayrollPeriod.db.update(dbConn, payPeriod); } } WebUtils.EndFunction(dbConn); pageErrors.addError("Payroll cycle is re-activated successfully."); payperiodView = payPeriodLoadData(payPeriodInfo, EPayrollPeriod.db, payPeriodRepeater); //if (CurID > 0) //{ // panelPayPeriod.Visible = true; // loadObject(); //} //else //{ // panelPayPeriod.Visible = false; // panelRollbackOption.Visible = false; //} } } // Response.Redirect(Request.Url.LocalPath + "?" + Request.QueryString); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); DateTime dtDeleteFrom, dtDeleteTo; DBFilter timeCardRecordFilter = new DBFilter(); if (DateTime.TryParse(DeleteFrom.Value, out dtDeleteFrom) && DateTime.TryParse(DeleteTo.Value, out dtDeleteTo)) { timeCardRecordFilter.add(new Match("TimeCardRecordDateTime", "<", dtDeleteTo.AddDays(1))); timeCardRecordFilter.add(new Match("TimeCardRecordDateTime", ">=", dtDeleteFrom)); // WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, timeCardRecordFilter); // WebUtils.EndFunction(dbConn); errors.addError("Time card record is removed successfully."); } }
protected void Upload_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); if (ImportFile.HasFile) { //DataTable dataTable = HROne.CSVProcess.CSVReader.parse(CNDImportFile.PostedFile.InputStream); string strTmpFolder = HROne.Common.Folder.GetOrCreateSessionTempFolder(Session.SessionID).FullName;; //Environment.GetFolderPath(Environment.SpecialFolder.InternetCache); string strTmpFile = System.IO.Path.Combine(strTmpFolder, AppUtils.ServerDateTime().ToString("~yyyyMMddHHmmss_") + ImportFile.FileName); ImportFile.SaveAs(strTmpFile); ImportLeaveBalanceAdjustmentProcess leaveBalanceAdjustImport = new ImportLeaveBalanceAdjustmentProcess(dbConn, Session.SessionID); //DataTable dataTable = HROne.Import.ExcelImport.parse(strTmpFile); //using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\csv\;Extended Properties='Text;'")) try { Repeater.DataSource = leaveBalanceAdjustImport.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty); Repeater.DataBind(); ImportSection.Visible = true; } catch (HRImportException ex) { if (leaveBalanceAdjustImport.errors.List.Count > 0) { foreach (string errorString in leaveBalanceAdjustImport.errors.List) { errors.addError(errorString); } } else { errors.addError(ex.Message); } } //System.IO.File.Delete(strTmpFile); } else { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE); } }
protected void btnConfirmProcess_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); HROne.Import.ImportBonusProcess m_importProcess = new HROne.Import.ImportBonusProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, CurID); if (!m_importProcess.ConfirmBonusProcess(errors)) { errors.addError("Confirm failed, please note that Bonus Process must be " + EBonusProcess.STATUS_NORMAL_DESC + " to be confirmed"); } else { errors.addError("Bonus Process confirmed! It is locked and not allow for further operations"); } loadObject(); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ArrayList list = WebUtils.SelectedRepeaterItemToBaseObjectList(db, Repeater, "ItemSelect"); foreach (EPaymentCalculationFormula o in list) { if (db.select(dbConn, o)) { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, o); WebUtils.EndFunction(dbConn); } } loadData(info, db, Repeater); }
// protected void Save_Click(object sender, EventArgs e) // { // ETaxCompany c = new ETaxCompany(); // Hashtable values = new Hashtable(); // binding.toValues(values); // PageErrors errors = PageErrors.getErrors(db, Page.Master); // errors.clear(); // db.validate(errors, values); // if (!errors.isEmpty()) // return; // db.parse(values, c); // if (!errors.isEmpty()) // return; // if (CurID < 0) // { // // Utils.MarkCreate(Session, c); // db.insert(dbConn, c); // CurID = c.TaxCompID; // // url = Utils.BuildURL(-1, CurID); // } // else // { // // Utils.Mark(Session, c); // db.update(dbConn, c); // } //// Response.Redirect(Request.Url.LocalPath + "?PayGroupID=" + CurID); // HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Taxation_Company_View.aspx?TaxCompID=" + CurID); // } protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); DBFilter taxCompanyFilter = new DBFilter(); taxCompanyFilter.add(new Match("TaxCompID", CurID)); DBFilter taxFormFilter = new DBFilter(); taxFormFilter.add(new IN("taxFormID", "Select taxFormID from " + ETaxForm.db.dbclass.tableName + " tf", taxCompanyFilter)); if (ETaxEmp.db.count(dbConn, taxFormFilter) > 0) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_CODE_IS_IN_USE, new string[] { TaxCompEmployerName.Text })); } if (!errors.isEmpty()) { view = loadData(info, ETaxCompanyMap.db, Repeater); return; } ETaxCompany c = new ETaxCompany(); c.TaxCompID = CurID; if (ETaxCompany.db.select(dbConn, c)) { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, c); ArrayList taxCompanyMapList = ETaxCompanyMap.db.select(dbConn, taxCompanyFilter); foreach (ETaxCompanyMap taxCompanyMap in taxCompanyMapList) { ETaxCompanyMap.db.delete(dbConn, taxCompanyMap); } WebUtils.EndFunction(dbConn); } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Taxation_Company_List.aspx"); }
// Start 0000005, Miranda, 2014-03-26 protected void ReCalc_Click(object sender, EventArgs e) { int empID; DBFilter empPosFilter = new DBFilter(); empPosFilter.add(new Match("LeavePlanID", CurID)); empPosFilter.add(new NullTerm("EmpPosEffTo")); // Start 000158, Ricky So, 2015-01-19 //ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter); //if (empPosList.Count > 0) //{ // foreach (EEmpPositionInfo empPos in empPosList) // { // empID = empPos.EmpID; // LeaveBalanceCalc calc = new LeaveBalanceCalc(dbConn, empID); // calc.Recalculate(); // } //} empPosFilter.add(new MatchField("pos.EmpID", "personal.EmpID")); empPosFilter.add(new Match("personal.EmpStatus", "A")); string select = "pos.EmpID"; string from = "from [EmpPositionInfo] pos, [EmpPersonalInfo] personal ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL"; DataTable table = empPosFilter.loadData(dbConn, null, select, from); foreach (DataRow m_row in table.Rows) { LeaveBalanceCalc calc = new LeaveBalanceCalc(dbConn, (int)m_row[0]); calc.Recalculate(); } // End 000158, Ricky So, 2015-01-19 PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); errors.addError(table.Rows.Count.ToString() + " employee(s) leave balances recalculated!"); }
protected void Upload_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); if (CNDImportFile.HasFile) { string strTmpFolder = HROne.Common.Folder.GetOrCreateSessionTempFolder(Session.SessionID).FullName;; //Environment.GetFolderPath(Environment.SpecialFolder.InternetCache); string strTmpFile = System.IO.Path.Combine(strTmpFolder, AppUtils.ServerDateTime().ToString("~yyyyMMddHHmmss_") + CNDImportFile.FileName); CNDImportFile.SaveAs(strTmpFile); ImportPayScaleSalaryIncrement m_ImportProcess = new ImportPayScaleSalaryIncrement(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, this.CurID); DataTable table = m_ImportProcess.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty); if (m_ImportProcess.errors.List.Count > 0) { foreach (string errorString in m_ImportProcess.errors.List) { errors.addError(errorString); } } else { if (table.Rows.Count > 0) { errors.addError(HROne.Translation.PageMessage.IMPORT_SUCCESSFUL); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Payroll_SalaryIncrementBatch_View.aspx?BatchID=" + CurID); } else { errors.addError("No records uploaded"); } } System.IO.File.Delete(strTmpFile); } else { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE); } }
protected void btnGenerate_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(EEmpPersonalInfo.db, this.Master); errors.clear(); DateTime dtBirthdayFrom = new DateTime(); DateTime dtBirthdayTo = new DateTime(); if (!DateTime.TryParse(BirthdayFrom.Value, out dtBirthdayFrom)) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_DATE_FORMAT, new string[] { BirthdayFrom.Value })); } if (!DateTime.TryParse(BirthdayTo.Value, out dtBirthdayTo)) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_DATE_FORMAT, new string[] { BirthdayTo.Value })); } if (dtBirthdayFrom > dtBirthdayTo) { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_PERIOD); } DBFilter filter = new DBFilter(); DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime()); empInfoFilter.add(new MatchField(EEmpPersonalInfo.db.dbclass.tableName + ".EmpID", "ee.EmpID")); filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter)); ArrayList empList = EEmpPersonalInfo.db.select(dbConn, filter); if (errors.isEmpty()) { HROne.Reports.Employee.EmployeeBirthdayProcess rpt = new HROne.Reports.Employee.EmployeeBirthdayProcess(dbConn, empList, dtBirthdayFrom, dtBirthdayTo, chkDisplayYear.Checked); string reportFileName = WebUtils.GetLocalizedReportFile(Server.MapPath("~/Report_Employee_BirthdayList.rpt")); WebUtils.ReportExport(dbConn, user, errors, lblReportHeader.Text, Response, rpt, reportFileName, ((Button)sender).CommandArgument, "BirthdayList", true); //Server.Transfer("Report_Employee_TerminationList_View.aspx?" //+ "EmpTermID=" + strTermEmpList //); } // emploadData(empInfo, EEmpPayroll.db, empRepeater); }
protected void Upload_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); if (CAImportFile.HasFile) { string strTmpFolder = HROne.Common.Folder.GetOrCreateSessionTempFolder(Session.SessionID).FullName;; //Environment.GetFolderPath(Environment.SpecialFolder.InternetCache); string strTmpFile = System.IO.Path.Combine(strTmpFolder, AppUtils.ServerDateTime().ToString("~yyyyMMddHHmmss_") + CAImportFile.FileName); CAImportFile.SaveAs(strTmpFile); ImportCommissionAchievementProcess CAImport = new ImportCommissionAchievementProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID); try { DataTable table = CAImport.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty); ImportSection.Visible = true; txtRemark.Text = string.Empty; } catch (HRImportException ex) { if (CAImport.errors.List.Count > 0) { foreach (string errorString in CAImport.errors.List) { errors.addError(errorString); } } else { errors.addError(ex.Message); } CAImport.ClearTempTable(); } System.IO.File.Delete(strTmpFile); } else { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE); } }
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); }
protected void Save_Click(object sender, EventArgs e) { EMPFParameter c = new EMPFParameter(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (CurID < 0) { // Utils.MarkCreate(Session, c); db.insert(dbConn, c); CurID = c.MPFParamID; // url = Utils.BuildURL(-1, CurID); } else { // Utils.Mark(Session, c); db.update(dbConn, c); } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/MPFParameter_List.aspx"); //HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/MPFParameter_View.aspx?MPFParamID=" + CurID); }
protected void Save_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); if (!System.IO.File.Exists(txtPARAM_CODE_BANKKEY_HSBC_PATH.Text)) { errors.addError("File not found: " + txtPARAM_CODE_BANKKEY_HSBC_PATH.Text); } else if (HROne.HSBC.Utility.isKeyExpired(txtPARAM_CODE_BANKKEY_HSBC_PATH.Text)) { errors.addError("HSBC Bank Key has expired"); } else if (!HROne.HSBC.Utility.verifyCustPwd(txtPARAM_CODE_BANKKEY_HSBC_PATH.Text, txtPARAM_CODE_BANKKEY_HSBC_PASSWORD.Text)) { errors.addError("Invalid password for HSBC Bank Key"); } if (!System.IO.File.Exists(txtPARAM_CODE_BANKKEY_HASE_PATH.Text)) { errors.addError("File not found: " + txtPARAM_CODE_BANKKEY_HASE_PATH.Text); } else if (HROne.HSBC.Utility.isKeyExpired(txtPARAM_CODE_BANKKEY_HASE_PATH.Text)) { errors.addError("Hang Seng Bank Key has expired"); } else if (!HROne.HSBC.Utility.verifyCustPwd(txtPARAM_CODE_BANKKEY_HASE_PATH.Text, txtPARAM_CODE_BANKKEY_HASE_PASSWORD.Text)) { errors.addError("Invalid password for Hang Seng Bank Key"); } if (errors.isEmpty()) { ESystemParameter.setParameter(dbConn, ESystemParameter.PARAM_CODE_BANKKEY_HSBC_PATH, txtPARAM_CODE_BANKKEY_HSBC_PATH.Text); ESystemParameter.setParameterWithEncryption(dbConn, ESystemParameter.PARAM_CODE_BANKKEY_HSBC_PASSWORD, txtPARAM_CODE_BANKKEY_HSBC_PASSWORD.Text); ESystemParameter.setParameter(dbConn, ESystemParameter.PARAM_CODE_BANKKEY_HASE_PATH, txtPARAM_CODE_BANKKEY_HASE_PATH.Text); ESystemParameter.setParameterWithEncryption(dbConn, ESystemParameter.PARAM_CODE_BANKKEY_HASE_PASSWORD, txtPARAM_CODE_BANKKEY_HASE_PASSWORD.Text); Response.Redirect("~/BankKeyManagement.aspx"); } }
protected void Delete_Click(object sender, EventArgs e) { EPayrollProrataFormula c = new EPayrollProrataFormula(); c.PayFormID = CurID; if (EPayrollProrataFormula.db.select(dbConn, c)) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); if (IsInUsed(c, errors)) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, c); WebUtils.EndFunction(dbConn); } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Payroll_Formula_List.aspx"); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ECompanyBankAccount c = new ECompanyBankAccount(); c.CompanyBankAccountID = CurID; if (db.select(dbConn, c)) { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, c); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", c.CompanyBankAccountID)); ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMapFilter); WebUtils.EndFunction(dbConn); } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "CompanyBankAccount_List.aspx"); }
protected void Save_Click(object sender, EventArgs e) { EWorkHourPattern c = new EWorkHourPattern(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (!AppUtils.checkDuplicate(dbConn, db, c, errors, "WorkHourPatternCode")) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE); if (CurID < 0) { db.insert(dbConn, c); CurID = c.WorkHourPatternID; } else { db.update(dbConn, c); } WebUtils.EndFunction(dbConn); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "WorkHourPattern_View.aspx?WorkHourPatternID=" + CurID); }
protected void PointSelect_Changed(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); if (SchemeCode.SelectedIndex > 0 && CapacitySelect.SelectedIndex > 0 && PointSelect.Text != "") { DBFilter filter = new DBFilter(); OR m_OR = new OR(); filter.add(new Match("SchemeCode", AppUtils.Encode(EPayScaleMap.db.getField("SchemeCode"), SchemeCode.SelectedValue.ToString()))); filter.add(new Match("Point", Decimal.Parse(PointSelect.Text))); if (EmpRPEffFr.Value != "") { filter.add(new Match("EffectiveDate", "<=", DateTime.Parse(EmpRPEffFr.Value))); m_OR.add(new Match("ExpiryDate", ">=", DateTime.Parse(EmpRPEffFr.Value))); m_OR.add(new NullTerm("ExpiryDate")); } else { filter.add(new Match("EffectiveDate", "<=", AppUtils.ServerDateTime())); m_OR.add(new Match("ExpiryDate", ">=", AppUtils.ServerDateTime())); m_OR.add(new NullTerm("ExpiryDate")); } filter.add(m_OR); ArrayList m_list = EPayScaleMap.db.select(dbConn, filter); if (m_list.Count > 0) { EmpRPAmount.Text = ((EPayScaleMap)m_list[0]).Salary.ToString("0.00"); } else { EmpRPAmount.Text = "0.00"; errors.addError("Failed to retrieve salary"); } } }
protected void btnGenerate_Click(object sender, EventArgs e) { ArrayList list = WebUtils.SelectedRepeaterItemToBaseObjectList(EEmpPersonalInfo.db, Repeater, "ItemSelect"); list.AddRange(WebUtils.SelectedRepeaterItemToBaseObjectList(EEmpPersonalInfo.db, TaxGenerated_Repeater, "ItemSelect")); DateTime processDateTime = AppUtils.ServerDateTime(); if (list.Count > 0) { Session["GenerateTax_EmpList"] = list; //string strEmpIDList = string.Empty; //foreach (EEmpPersonalInfo o in list) //{ // if (strEmpIDList == string.Empty) // strEmpIDList = ((EEmpPersonalInfo)o).EmpID.ToString(); // else // strEmpIDList += "_" + ((EEmpPersonalInfo)o).EmpID.ToString(); //} int taxFormID = HROne.Taxation.TaxationGeneration.GetOrCreateTaxFormID(dbConn, int.Parse(TaxCompID.SelectedValue), int.Parse(YearSelect.SelectedValue), TaxFormType.SelectedValue); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/Taxation_Generation_Process.aspx?" + "TaxFormID=" + taxFormID + "&Total=" + list.Count); //+ "&EmpID=" + strEmpIDList); //HROne.Taxation.TaxationGeneration.GenerationFormTaxation(int.Parse(TaxCompID.SelectedValue), int.Parse(YearSelect.SelectedValue), TaxFormType.SelectedValue, list); //errors.addError("Complete"); //Response.Write("<script>alert('Completed'); </script>"); } else { PageErrors errors = PageErrors.getErrors(EEmpPayroll.db, Page.Master); errors.addError(HROne.Translation.PageErrorMessage.ERROR_NO_EMPLOYEE_SELECTED); } //view = loadData(info, db, Repeater, false); }
protected void Delete_Click(object sender, EventArgs e) { EUser activeUser = WebUtils.GetCurUser(Session); EUser c = new EUser(); c.UserID = CurID; if (EUser.db.select(dbConn, c)) { bool isAllowDelete = true; if (activeUser.UsersCannotCreateUsersWithMorePermission) { if (!c.UsersCannotCreateUsersWithMorePermission) { isAllowDelete = false; } else if (!c.IsAllowSubmitPermission(dbConn, activeUser.UserID)) { isAllowDelete = false; } } if (isAllowDelete) { WebUtils.StartFunction(Session, FUNCTION_CODE); c.UserAccountStatus = "D"; db.update(dbConn, c); WebUtils.EndFunction(dbConn); EInbox.DeleteAllByUserID(dbConn, c.UserID); } else { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); errors.addError(PageErrorMessage.ERROR_INVALID_PERMISSION); return; } } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "User_List.aspx"); }
protected void btnGenerateCND_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); EAttendancePreparationProcess m_process = EAttendancePreparationProcess.GetObject(dbConn, CurID); if (m_process != null) { DBFilter m_rpFilter = new DBFilter(); OR m_or = new OR(); m_or.add(new NullTerm("EmpRPEffTo")); m_or.add(new Match("EmpRPEffTo", ">=", HROne.CommonLib.Utility.LastDateOfMonth(AppUtils.ServerDateTime()))); m_rpFilter.add(m_or); m_rpFilter.add(new Match("EmpRPEffFr", "<=", HROne.CommonLib.Utility.LastDateOfMonth(AppUtils.ServerDateTime()))); DBFilter m_isRPWinsonFilter = new DBFilter(); m_rpFilter.add(new IN("EmpRPID", "SELECT EmpRPID FROM EmpRPWinson", m_isRPWinsonFilter)); DBFilter m_EmpPersonalFilter = new DBFilter(); m_EmpPersonalFilter.add(new IN("EmpID", "SELECT EmpID FROM EmpRecurringPayment", m_rpFilter)); ArrayList empList = EEmpPersonalInfo.db.select(dbConn, m_EmpPersonalFilter); HROne.Import.ImportAttendancePreparationProcess m_import = new HROne.Import.ImportAttendancePreparationProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, CurID); string exportFileName = System.IO.Path.GetTempFileName(); System.IO.File.Delete(exportFileName); exportFileName += ".xls"; HROne.Export.ExcelExport export = new HROne.Export.ExcelExport(exportFileName); DataSet dataSet = m_import.GenerateCND(dbConn, empList, exportFileName, CurID); export.Update(dataSet); WebUtils.TransmitFile(Response, exportFileName, "CND_" + AppUtils.ServerDateTime().ToString("yyyyMMddHHmmss") + ".xls", true); } else { errors.addError("Failed to open batch"); } }