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");
}
}
