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