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); }