public DataView loadData(ListInfo info, DBManager db, DataList repeater) { //filter.add(new Match("EmpPayrollID",EmpPayrollID.Value)); ImportCommissionAchievementProcess CAImport = new ImportCommissionAchievementProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID); DataTable table = CAImport.GetImportDataFromTempDatabase(info); if (info != null) { if (!string.IsNullOrEmpty(info.orderby)) { if (info.orderby.Equals("EmpEngFullName", StringComparison.CurrentCultureIgnoreCase)) { if (!table.Columns.Contains("EmpEngFullName")) { table.Columns.Add("EmpEngFullName", typeof(string)); foreach (System.Data.DataRow row in table.Rows) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = (int)row["EmpID"]; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { row["EmpEngFullName"] = empInfo.EmpEngFullName; } } } } } } table = WebUtils.DataTableSortingAndPaging(table, info); view = new DataView(table); if (repeater != null) { repeater.DataSource = view; repeater.DataBind(); } if (table.Rows.Count > 0) { ImportSection.Visible = true; } else { ImportSection.Visible = false; } return(view); }
protected void Import_Click(object sender, EventArgs e) { if (txtRemark.Text != "") { ImportCommissionAchievementProcess CAImport = new ImportCommissionAchievementProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID); CAImport.Remark = txtRemark.Text; WebUtils.StartFunction(Session, FUNCTION_CODE); CAImport.ImportToDatabase(); WebUtils.EndFunction(dbConn); PageErrors.getErrors(db, Page).addError(HROne.Translation.PageMessage.IMPORT_SUCCESSFUL); } else { PageErrors.getErrors(db, Page).addError("Please input batch remarks"); } }
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); } }