Boolean ImportFile(string strFilePath1)
{
string _yrmo = Session["yrmo"].ToString();
string logFilePath = Server.MapPath("~/uploads/") + "YEB_Expat_" + _yrmo + ".xls";
bool importStat = false;
ImportYEBData iObj = new ImportYEBData();
HRAExcelImport tObj = new HRAExcelImport();
DataTable dtYEBEXPAT;
DataSet ds = new DataSet(); ds.Clear();
ds = tObj.getExcelData(strFilePath1, "YEBEXPATTable");
dtYEBEXPAT = ds.Tables["YEBEXPATTable"];
if (dtYEBEXPAT.Rows.Count > 0)
{
ImportYEBData.Rollback(source, _yrmo);
ImportYEBData.PrintExpatProgressBar();
//http://www.eggheadcafe.com/articles/20051223.asp
_counter = iObj.insertYEBExpatData(dtYEBEXPAT);
Thread.Sleep(2000);
ImportYEBData.ClearProgressBar(_counter);
//Now update the YEbDetailtable with the matches
//found in the YEBExpat table
ImportYEBData.updateYEBDetailData(_yrmo, "YEBEXPAT");
}
if (File.Exists(logFilePath))
{
File.Delete(logFilePath);
}
importStat = true;
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "YEB", "ImportSourceFile", "YEB_EXPAT", "YEBEXPAT Import", _yrmo, _counter);
return(importStat);
}