protected void Import_Click(object sender, EventArgs e) { ImportRosterTableProcess RosterTableImport = new ImportRosterTableProcess(dbConn, Session.SessionID); RosterTableImport.ImportToDatabase(); //loadData(info, db, Repeater); PageErrors.getErrors(db, Page).addError(HROne.Translation.PageMessage.IMPORT_SUCCESSFUL); }
protected void Upload_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); if (CNDImportFile.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_") + CNDImportFile.FileName); CNDImportFile.SaveAs(strTmpFile); ImportRosterTableProcess RosterTableImport = new ImportRosterTableProcess(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 { DataTable table = RosterTableImport.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty); //Repeater.DataSource = table; //Repeater.DataBind(); ImportSection.Visible = true; } catch (HRImportException ex) { if (RosterTableImport.errors.List.Count > 0) { foreach (string errorString in RosterTableImport.errors.List) { errors.addError(errorString); } } else { errors.addError(ex.Message); } RosterTableImport.ClearTempTable(); } //System.IO.File.Delete(strTmpFile); } else { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE); } }
public DataView loadData(ListInfo info, DBManager db, DataList repeater) { //filter.add(new Match("EmpPayrollID",EmpPayrollID.Value)); ImportRosterTableProcess rosterTableImport = new ImportRosterTableProcess(dbConn, Session.SessionID); DataTable table = rosterTableImport.GetImportDataFromTempDatabase(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); }