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);
ImportClaimsAndDeductionsProcess CNDImport = new ImportClaimsAndDeductionsProcess(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID);
//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 = CNDImport.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty);
//table = WebUtils.DataTableSortingAndPaging(table, info);
//Repeater.DataSource = table;
//Repeater.DataBind();
ImportSection.Visible = true;
txtRemark.Text = string.Empty;
}
catch (HRImportException ex)
{
if (CNDImport.errors.List.Count > 0)
{
foreach (string errorString in CNDImport.errors.List)
{
errors.addError(errorString);
}
}
else
{
errors.addError(ex.Message);
}
CNDImport.ClearTempTable();
}
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 (CNDImportFile.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_") + CNDImportFile.FileName);
CNDImportFile.SaveAs(strTmpFile);
ImportPayScaleSalaryIncrement m_ImportProcess = new ImportPayScaleSalaryIncrement(dbConn, Session.SessionID, WebUtils.GetCurUser(Session).UserID, this.CurID);
DataTable table = m_ImportProcess.UploadToTempDatabase(strTmpFile, WebUtils.GetCurUser(Session).UserID, string.Empty);
if (m_ImportProcess.errors.List.Count > 0)
{
foreach (string errorString in m_ImportProcess.errors.List)
{
errors.addError(errorString);
}
}
else
{
if (table.Rows.Count > 0)
{
errors.addError(HROne.Translation.PageMessage.IMPORT_SUCCESSFUL);
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Payroll_SalaryIncrementBatch_View.aspx?BatchID=" + CurID);
}
else
{
errors.addError("No records uploaded");
}
}
System.IO.File.Delete(strTmpFile);
}
else
{
errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE);
}
}
