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