protected void GenerateCalculatedReport_Click(object sender, EventArgs e)
{
//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);
string exportFileName = System.IO.Path.GetTempFileName();
System.IO.File.Delete(exportFileName);
exportFileName += ".xls";
//HROne.Export.ExcelExport export = new HROne.Export.ExcelExport(exportFileName);
ArrayList empList = EEmpPersonalInfo.db.select(dbConn, new DBFilter());
ImportAttendancePreparationProcess.ExportCalculatedTemplate(dbConn, empList, exportFileName, CurID);
WebUtils.TransmitFile(Response, exportFileName, "calculated_attendance_record_" + AppUtils.ServerDateTime().ToString("yyyyMMddHHmmss") + ".xls", true);
}
protected void Import_Click(object sender, EventArgs e)
{
ImportAttendancePreparationProcess m_import = new ImportAttendancePreparationProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID);
WebUtils.StartFunction(Session, FUNCTION_CODE);
m_import.ImportToDatabase();
// Set employee count
DBFilter m_countFilter = new DBFilter();
m_countFilter.add(new Match("AttendancePreparationProcessID", gPID));
int empCount = EEmpAttendancePreparationProcess.db.count(dbConn, m_countFilter);
EAttendancePreparationProcess attendancePreparationProcess = EAttendancePreparationProcess.GetObject(dbConn, gPID);
attendancePreparationProcess.AttendancePreparationProcessEmpCount = empCount;
EAttendancePreparationProcess.db.update(dbConn, attendancePreparationProcess);
DBFilter m_clearTempFilter = new DBFilter();
m_clearTempFilter.add(new Match("AttendancePreparationProcessID", gPID));
EUploadAttendancePreparationProcess.db.delete(dbConn, m_clearTempFilter);
WebUtils.EndFunction(dbConn);
PageErrors.getErrors(db, Page).addError(HROne.Translation.PageMessage.IMPORT_SUCCESSFUL);
}
public DataView loadData(ListInfo info, DBManager db, DataList repeater)
{
HROne.Import.ImportAttendancePreparationProcess m_import = new ImportAttendancePreparationProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID);
DataTable m_table = m_import.GetImportDataFromTempDatabase(info);
if (info != null)
{
if (!string.IsNullOrEmpty(info.orderby))
{
if (info.orderby.Equals("EmpEngFullName", StringComparison.CurrentCultureIgnoreCase))
{
if (!m_table.Columns.Contains("EmpEngFullName"))
{
m_table.Columns.Add("EmpEngFullName", typeof(string));
foreach (System.Data.DataRow row in m_table.Rows)
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = (int)row["EmpID"];
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
row["EmpEngFullName"] = empInfo.EmpEngFullName;
}
}
}
}
}
}
m_table = WebUtils.DataTableSortingAndPaging(m_table, info);
view = new DataView(m_table);
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
if (m_table.Rows.Count > 0)
{
ImportSection.Visible = true;
}
else
{
ImportSection.Visible = false;
}
return(view);
}
protected void Upload_Click(object sender, EventArgs e)
{
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
if (ImportFile.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_") + ImportFile.FileName);
ImportFile.SaveAs(strTmpFile);
ImportAttendancePreparationProcess m_import = new ImportAttendancePreparationProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, this.gPID);
try
{
DataTable m_table = m_import.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty, gPID);
ImportSection.Visible = true;
}
catch (HRImportException ex)
{
if (m_import.errors.List.Count > 0)
{
foreach (string errorString in m_import.errors.List)
{
errors.addError(errorString);
}
}
else
{
errors.addError(ex.Message);
}
m_import.ClearTempTable();
}
System.IO.File.Delete(strTmpFile);
}
else
{
errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE);
}
}
