protected void BtnUpload_Click(object sender, EventArgs e) { if (ImportFile.HasFile) { // Get the file extension string fileExtension = System.IO.Path.GetExtension(ImportFile.FileName); if (fileExtension.ToLower() != ".csv" && fileExtension.ToLower() != ".xlsx") { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Only files with .csv and .xlsx extension are allowed"; } else { // Upload the file //string Fname = System.DateTime.Now.ToString("ddMMyyhhmmss") + FileUpload1.FileName; ImportFile.SaveAs(Server.MapPath("~/Upload/ClientsInvoices/" + ImportFile.FileName)); //FileUpload1.SaveAs(Server.MapPath("~/Archive/" + FileUpload1.FileName)); lblMessage.ForeColor = System.Drawing.Color.Green; lblMessage.Text = "File uploaded successfully"; } } else { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Please select a file"; } ReadWriteCSVFile(); GetClinetInvoice(null, null, 0, DateTime.MinValue, DateTime.MinValue); }
protected void Upload_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(null, Page.Master); errors.clear(); if (ImportFile.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_") + ImportFile.FileName); ImportFile.SaveAs(strTmpFile); ImportTimeCardRecordProcess timeCardRecordImport = new ImportTimeCardRecordProcess(dbConn, Session.SessionID); timeCardRecordImport.DateSequence = this.Attendance_ImportFormatParameterControl1.DateSequence; timeCardRecordImport.DateSeparator = this.Attendance_ImportFormatParameterControl1.DateSeparator; timeCardRecordImport.YearFormat = this.Attendance_ImportFormatParameterControl1.YearFormat; timeCardRecordImport.TimeSeparator = this.Attendance_ImportFormatParameterControl1.TimeSeparator; timeCardRecordImport.DateColumnIndex = this.Attendance_ImportFormatParameterControl1.DateColumnIndex; timeCardRecordImport.TimeColumnIndex = this.Attendance_ImportFormatParameterControl1.TimeColumnIndex; timeCardRecordImport.DateColumnIndex2 = this.Attendance_ImportFormatParameterControl1.DateColumnIndex2; timeCardRecordImport.TimeColumnIndex2 = this.Attendance_ImportFormatParameterControl1.TimeColumnIndex2; timeCardRecordImport.LocationColumnIndex = this.Attendance_ImportFormatParameterControl1.LocationColumnIndex; timeCardRecordImport.TimeCardNumColumnIndex = this.Attendance_ImportFormatParameterControl1.TimeCardNumColumnIndex; timeCardRecordImport.ColumnDelimiter = this.Attendance_ImportFormatParameterControl1.ColumnDelimiter; timeCardRecordImport.UploadFileHasHeader = this.Attendance_ImportFormatParameterControl1.UploadFileHasHeader; //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 { timeCardRecordImport.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty); timeCardRecordImport.ImportToDatabase(); errors.addError(HROne.Translation.PageMessage.IMPORT_SUCCESSFUL); Attendance_ImportFormatParameterControl1.SaveSettings(); } catch (HRImportException ex) { if (timeCardRecordImport.errors.List.Count > 0) { foreach (string errorString in timeCardRecordImport.errors.List) { errors.addError(errorString); } } else { errors.addError(ex.Message); } } System.IO.File.Delete(strTmpFile); } else { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE); } }
protected void Upload_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); if (ImportFile.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_") + ImportFile.FileName); ImportFile.SaveAs(strTmpFile); ImportLeaveBalanceAdjustmentProcess leaveBalanceAdjustImport = new ImportLeaveBalanceAdjustmentProcess(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 { Repeater.DataSource = leaveBalanceAdjustImport.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty); Repeater.DataBind(); ImportSection.Visible = true; } catch (HRImportException ex) { if (leaveBalanceAdjustImport.errors.List.Count > 0) { foreach (string errorString in leaveBalanceAdjustImport.errors.List) { errors.addError(errorString); } } else { errors.addError(ex.Message); } } //System.IO.File.Delete(strTmpFile); } else { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE); } }
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); ImportHitRateBasedPaymentProcess m_import = new ImportHitRateBasedPaymentProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID); try { DataTable m_table = m_import.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty); ImportSection.Visible = true; txtRemark.Text = string.Empty; } 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); } }