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.importMCNM(strFilePath1, _yrmo);
parseDataSet pObj = new parseDataSet();
_counter = pObj.parseMCNM(ds, _yrmo);
importStat = true;
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "Headcount", "Retiree Medicare/Non-Medicare Report Import", _yrmo, _counter);
}
catch (Exception ex)
{
iObj.Rollback("RET_NM", _yrmo);
throw ex;
}
finally
{
File.Delete(strFilePath1);
}
return(importStat);
}
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.importDFNORF(strFilePath1);
parseDataSet pObj = new parseDataSet();
counter = pObj.parseDFnoRF(ds, _yrmo);
importStat = true;
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Claims Reconciliation", "RFDF", "DFnoRF Report Import", _yrmo, counter);
}
catch (Exception ex)
{
iObj.Rollback("DF", _yrmo);
throw ex;
}
finally
{
File.Delete(strFilePath1);
}
return(importStat);
}
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 void btn_import_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
if (Page.IsValid)
{
string strFilePath1 = "";
lbl_error.Text = "";
if (FileUpload1.GotFile)
{
try
{
string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName);
if (fn.Contains(yrmo))
{
strFilePath1 = Server.MapPath("~/uploads/") + fn;
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.SaveAs(strFilePath1);
if (ImportFile(strFilePath1))
{
MultiView1.SetActiveView(view_result);
lbl_result.Text = "Imported successfully for year-month (YRMO): " + yrmo;
//auditImport(tbx_YRMO.Text.ToString(), "imp", counter);
}
}
else
{
lbl_error.Text = "The Year Month (YRMO) of the selected file does not match the selected YRMO";
}
}
catch (Exception ex)
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("RET_NM", yrmo);
lbl_error.Text = "Error in importing file.<br />" + ex.Message;
}
finally
{
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.InputStream.Flush();
FileUpload1.FilePost.InputStream.Close();
FileUpload1.FilePost.InputStream.Dispose();
}
}
}
}
protected void btn_reimport_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
lbl_error.Text = "";
try
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("ANTH_RX", yrmo);
MultiView1.SetActiveView(view_main);
}
catch (Exception ex)
{
lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message;
}
}
protected void btn_reimport_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
lbl_error.Text = "";
try
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("HTH", yrmo);
ReconDAL.pastReconcileDelete(yrmo, "INTL");
MultiView1.SetActiveView(view_main);
}
catch (Exception ex)
{
lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message;
}
}
protected void btn_reimport_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
lbl_error.Text = "";
try
{
ClaimsRecon dObj = new ClaimsRecon();
dObj.DeleteNCAReconData(yrmo);
dObj.deleteForced(yrmo, "DFRF");
ImportDAL iObj = new ImportDAL();
iObj.Rollback("DF", yrmo);
MultiView1.SetActiveView(view_main);
}
catch (Exception ex)
{
lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message;
}
}
protected void btn_import_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string strFilePath1 = "";
lbl_error.Text = "";
if (FileUpload1.GotFile)
{
try
{
string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName);
strFilePath1 = Server.MapPath("~/uploads/") + fn;
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.SaveAs(strFilePath1);
if (ImportFile(strFilePath1))
{
MultiView1.SetActiveView(view_result);
lbl_result.Text = "Imported successfully for year-month (YRMO): " + ddlYrmo.SelectedItem.Text;
}
}
catch (Exception ex)
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("DF", ddlYrmo.SelectedItem.Text);
lbl_error.Text = "Error in importing file.<br />" + ex.Message;
}
finally
{
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.InputStream.Flush();
FileUpload1.FilePost.InputStream.Close();
FileUpload1.FilePost.InputStream.Dispose();
}
}
}
}
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.importRXClaims(strFilePath1);
parseDataSet pObj = new parseDataSet();
counter = pObj.parseRXClaims(ds, _yrmo);
importStat = true;
}
catch (Exception ex)
{
File.Delete(strFilePath1);
iObj.Rollback("ANTH_RX", _yrmo);
throw ex;
}
return(importStat);
}