protected void btnGenerateCND_Click(object sender, EventArgs e)
{
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
EBonusProcess m_process = EBonusProcess.GetObject(dbConn, CurID);
if (m_process != null)
{
HROne.Import.ImportBonusProcess m_import = new HROne.Import.ImportBonusProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, CurID);
DataSet dataSet = m_import.GenerateCND();
string exportFileName = System.IO.Path.GetTempFileName();
System.IO.File.Delete(exportFileName);
exportFileName += ".xls";
HROne.Export.ExcelExport export = new HROne.Export.ExcelExport(exportFileName);
export.Update(dataSet);
WebUtils.TransmitFile(Response, exportFileName, "CND_" + AppUtils.ServerDateTime().ToString("yyyyMMddHHmmss") + ".xls", true);
}
else
{
errors.addError("Failed to open batch");
}
}
protected DataTable PrepareExportData(string pProcessName, int pPID, ArrayList pEmpList, PageErrors pErrors)
{
if (string.Compare(gProcessName, "BonusProcess", true) == 0) // ignore case compare
{
HROne.Import.ImportBonusProcess m_process = new HROne.Import.ImportBonusProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, pPID);
if (gP1 == "S") // Standard Bonus
{
m_process.ClearUploadedStandardData(pErrors);
m_process.GenerateStandardBonusData(pEmpList);
pErrors.addError("Standard Bonus generation completed");
return(null);
}
else if (gP1 == "D") // Discretionary Bonus
{
return(m_process.ExportDiscretionaryBonusTemplate(pEmpList, true));
}
}
else if (string.Compare(gProcessName, "DoublePayAdjustment", true) == 0)
{
return(HROne.Import.ImportDoublePayAdjustmentProcess.ExportTemplate(dbConn, pEmpList, true));
}
else if (string.Compare(gProcessName, "HitRateProcess", true) == 0)
{
return(HROne.Import.ImportHitRateBasedPaymentProcess.ExportTemplate(dbConn, pEmpList, true));
}
return(null);
}
protected void btnClearPart2Data_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.ClearUploadedDiscretionaryData(errors))
{
errors.addError("Uploaded records cleared");
}
loadObject();
}
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 btnExportPart1Template_Click(object sender, EventArgs e)
{
string exportFileName = System.IO.Path.GetTempFileName();
System.IO.File.Delete(exportFileName);
exportFileName += ".xls";
HROne.Export.ExcelExport export = new HROne.Export.ExcelExport(exportFileName);
DataSet dataSet = new DataSet();// export.GetDataSet();
HROne.Import.ImportBonusProcess m_importProcess = new HROne.Import.ImportBonusProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, CurID);
DataTable m_table = m_importProcess.ExportStandardBonusTemplate(true);
if (m_table != null)
{
dataSet.Tables.Add(m_table);
export.Update(dataSet);
WebUtils.TransmitFile(Response, exportFileName, m_table.TableName + "_" + AppUtils.ServerDateTime().ToString("yyyyMMddHHmmss") + ".xls", true);
}
}
protected void Upload_Click(object sender, EventArgs e)
{
PageErrors errors = PageErrors.getErrors(EEmpPersonalInfo.db, Page.Master);
errors.clear();
if (FileUploadControl.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_") + FileUploadControl.FileName);
FileUploadControl.SaveAs(strTmpFile);
string ZipPassword = "";
DataTable rawDataTable = HROne.Import.ExcelImport.parse(strTmpFile, ZipPassword).Tables[0];
if (string.Compare(gProcessName, "BonusProcess", true) == 0)
{
HROne.Import.ImportBonusProcess m_importProcess = new HROne.Import.ImportBonusProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, gPID);
m_importProcess.ImportEmpBonusProcess(gPID, rawDataTable, gP1, errors);
}
else if (string.Compare(gProcessName, "DoublePayAdjustment", true) == 0)
{
HROne.Import.ImportDoublePayAdjustmentProcess m_importProcess = new HROne.Import.ImportDoublePayAdjustmentProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID);
m_importProcess.UploadToTempDatabase(rawDataTable, WebUtils.GetCurUser(Session).UserID);
}
System.IO.File.Delete(strTmpFile);
if (errors.isEmpty())
{
errors.addError("Import Completed");
}
}
else
{
errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE);
}
}