Boolean ImportFile(string strFilePath1) { string _yrmo = ddlYrmo.SelectedItem.Text; bool importStat = false; ImportDAL iObj = new ImportDAL(); try { DataSet ds = new DataSet(); ImportExcelReport tObj = new ImportExcelReport(); ds = tObj.importAnthemBill(strFilePath1); parseDataSet pObj = new parseDataSet(); pObj.parseAnthem(ds, _yrmo); counter = iObj.insertAnthemHeadcounts(_yrmo); importStat = true; int _counter = iObj.getImportCount("ANTH", _yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "billing_details", "Anthem Bill Import", _yrmo, _counter); } catch (Exception ex) { File.Delete(strFilePath1); iObj.Rollback("ANTH", _yrmo); throw ex; } finally { File.Delete(strFilePath1); } return(importStat); }