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.importHTH(strFilePath1, _yrmo); parseDataSet pObj = new parseDataSet(); pObj.parseHTH(ds, _yrmo); counter = iObj.insertHTHHeadcounts(_yrmo); importStat = true; int _counter = iObj.getImportCount("HTH", _yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "Headcount", "International HTH Report Import", _yrmo, _counter); } catch (Exception ex) { iObj.Rollback("HTH", _yrmo); throw ex; } finally { File.Delete(strFilePath1); FileUpload1.FilePost.InputStream.Flush(); FileUpload1.FilePost.InputStream.Close(); FileUpload1.FilePost.InputStream.Dispose(); } return(importStat); }
protected bool importfile(string strFilePath1) { bool status = false; string yrmo = ddlYrmo.Text; //ImportText adpImport = new ImportText(); try { //adpImport.ParseADP(strFilePath1); ImportCobra.importADPDetail(yrmo, strFilePath1); status = true; ImportDAL iobj = new ImportDAL(); int _cnt = iobj.getImportCount("ADP", yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "ADP_Details", "ADP Cobra Import", yrmo, _cnt); } catch (Exception e) { ImportDAL iObj = new ImportDAL(); iObj.Rollback("ADP", yrmo); throw e; } finally { File.Delete(strFilePath1); } return(status); }
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); }
protected bool importfile(string filepath) { bool status = false; string yrmo = ddlYrmo.Text; ImportText grImport = new ImportText(); try { grImport.ParseGRS(filepath); grImport.importGRSRecords(yrmo); status = true; ImportDAL iobj = new ImportDAL(); int _cnt = iobj.getImportCount("GRS", yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "HeadCounts", "GRS Report Import", yrmo, _cnt); } catch (Exception e) { ImportDAL iObj = new ImportDAL(); iObj.Rollback("GRS", yrmo); throw e; } finally { ImportTextDAL storeData = new ImportTextDAL(); storeData.deleteStage("GRS"); File.Delete(filepath); } return(status); }
protected bool importfile(string filepath) { string yrmo = ddlYrmo.SelectedItem.Text.ToString(); bool status = false; ImportText boaImport = new ImportText(); try { boaImport.parseBOA(filepath); status = true; ImportDAL iobj = new ImportDAL(); int _cnt = iobj.getImportCount("BOA", yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Claims Reconciliation", "BOAStatement", "BOA Statement Import", yrmo, _cnt); } catch (Exception e) { status = false; throw e; } return(status); }