protected void ddlYrmoList()
{
string prevYRMO;
for (int i = 0; i < 6; i++)
{
prevYRMO = VWA.getPrevYRMO(i);
ddlYrmo.Items.Add(prevYRMO);
}
ddlYrmo.Items.Add("New Yrmo");
}
void bindData()
{
clearMessages();
string _cnum = Page.Request.QueryString["id"];
DataTable dtcontract = new DataTable();
DataTable dtFinance = new DataTable();
DataRow rowNew;
DataColumn col;
col = new DataColumn("Total Benefit"); dtFinance.Columns.Add(col);
col = new DataColumn("Total Recovery"); dtFinance.Columns.Add(col);
col = new DataColumn("Total Fees"); dtFinance.Columns.Add(col);
col = new DataColumn("Total Net"); dtFinance.Columns.Add(col);
try
{
dtcontract = VWA_DAL.getContractDetails(_cnum);
int i = 0;
foreach (DataRow dr in dtcontract.Rows)
{
if (i < 1)
{
// Contract Tab data
Session["yrmo"] = dr["yrmo"].ToString();
txtCon.Text = dr["ContractNo"].ToString();
txtClient.Text = dr["ClientId"].ToString();
txtClientName.Text = dr["Clientdsc"].ToString();
txtSSN.Text = VWA.formatSSN("dashed", dr["SSNO"].ToString());
txtGroup.Text = dr["GroupNo"].ToString();
txtGroupName.Text = dr["Groupdsc"].ToString();
txtName.Text = dr["Name"].ToString();
txtPatient.Text = dr["PatientName"].ToString();
txtRelation.Text = dr["RelCd"].ToString();
txtDisabled.Text = dr["DisabCd"].ToString();
txtStatusCd1.Text = dr["StatusCd"].ToString();
txtStatusCd2.Text = dr["Statusdsc"].ToString();
txtAcciDt.Text = dr["AccDt"].ToString();
txtRecoveryDt.Text = dr["RecDt"].ToString();
txtOpenDt.Text = dr["OpenDt"].ToString();
txtCloseDt.Text = dr["CloseDt"].ToString();
txtLastUpdate.Text = dr["SysDt"].ToString();
//Financial Tab data - First grid
rowNew = dtFinance.NewRow();
rowNew["Total Benefit"] = Convert.ToDecimal(dr["BenPaid"].ToString()).ToString("C");
rowNew["Total Recovery"] = Convert.ToDecimal(dr["RecAmt"].ToString()).ToString("C");
rowNew["Total Fees"] = Convert.ToDecimal(dr["TotFees"].ToString()).ToString("C");
rowNew["Total Net"] = Convert.ToDecimal(dr["NetAmt"].ToString()).ToString("C");
dtFinance.Rows.Add(rowNew);
grdvFinancial1.DataSource = dtFinance;
grdvFinancial1.DataBind();
//Financial Tab data - Second grid
SqlDataSource1.SelectParameters.Add("cnum", TypeCode.String, dr["ContractNo"].ToString());
SqlDataSource1.SelectParameters.Add("source", TypeCode.String, "FinanceTab2");
grdvFinancial2.DataBind();
//Notes Tab
txtNotes.Text = dr["Notes"].ToString();
i++;
}
else
{
break;
}
}
if (!Session["yrmo"].ToString().Equals(""))
{
DataTable dthis = VWA_DAL.getHistory_4Cases(_cnum);
grdvHistory.DataSource = dthis;
grdvHistory.DataBind();
}
}
catch (Exception ex)
{
errorDiv1.Visible = true;
lblError1.Text = ex.Message;
}
}
protected void btn_autoImport_Click(object sender, EventArgs e)
{
Impersonation _imp = new Impersonation();
string yrmo = ddlYrmo.SelectedItem.Text;
string clientfilename, clientfile, serverPath;
string serverfile = "";
lbl_error.Text = "";
lblError1.Text = "";
if (Page.IsValid)
{
if (txtPrevYRMO.Visible)
{
lbl_error.Text = "Enter YRMO in format 'yyyymm'";
return;
}
try
{
serverPath = Server.MapPath("~/uploads/");
clientfilename = VWA.GetInputFileName(yrmo, source);
serverfile = serverPath + clientfilename;
if (_imp.impersonateValidUser(Session["uid"].ToString(), "CORP", EncryptDecrypt.Decrypt(Session["pwd"].ToString())))
{
clientfile = VWAImportDAL.GetClientFilePath(_category, source) + "\\" + clientfilename;
File.Copy(clientfile, serverfile);
_imp.undoImpersonation();
}
else
{
throw new Exception("Error in accessing network location");
}
if (!(File.Exists(serverfile)))
{
throw new Exception("Unable to import file from specified location.<br/>Please check if file exists and you are logged in to the network.");
}
if (ImportFile(serverfile))
{
bindResults();
VWA_Results.SavePrintFiles(source, yrmo);
MultiView1.SetActiveView(view_result);
lbl_result.Text = "Import completed successfully -- " + _counter + " records imported";
}
else
{
throw new Exception("Unable to parse file.<br/>Please check file type and format.");
}
}
catch (Exception ex)
{
resultDiv.Visible = false;
VWAImportDAL.Rollback(source, yrmo);
lbl_error.Text = "Error - " + ex.Message;
}
finally
{
if (File.Exists(serverfile))
{
File.Delete(serverfile);
}
}
}
}
void SetAutoImport()
{
upload_auto.Visible = true;
upload_manually.Visible = false;
if (VWAImportDAL.GetClientFilePath(_category, source).Trim() == String.Empty)
{
lbl_clientfile.Text = "";
}
else
{
lbl_clientfile.Text = VWAImportDAL.GetClientFilePath(_category, source) + "\\" + VWA.GetInputFileName(ddlYrmo.SelectedItem.Value, source);
}
cbx_autoImport.Checked = false;
}
protected void btn_autoImport_Click(object sender, EventArgs e)
{
Impersonation _imp = new Impersonation();
string yrmo = ddlYrmo.SelectedItem.Text;
string clientfilename1, clientfilename2, clientfilename3, clientfilename4, clientfilename5;
string clientfile1, clientfile2, clientfile3, clientfile4, clientfile5;
string serverfile1, serverfile2, serverfile3, serverfile4, serverfile5;
List <string> filepaths = new List <string>();
List <string> sources = new List <string>();
string wiredt = tbx_autoWiredt.Text;
ErrMsgDiv1.Visible = false;
ErrMsgDiv2.Visible = false;
if (Page.IsValid)
{
if (txtPrevYRMO.Visible)
{
lbl_error1.Text = "Enter YRMO in format 'yyyymm'";
return;
}
serverfile1 = "";
serverfile2 = "";
serverfile3 = "";
serverfile4 = "";
serverfile5 = "";
try
{
clientfilename1 = VWA.GetInputFileName(yrmo, source_OC);
clientfilename2 = VWA.GetInputFileName(yrmo, source_Cigna);
clientfilename3 = VWA.GetInputFileName(yrmo, source_UHC);
clientfilename4 = VWA.GetInputFileName(yrmo, source_Disab);
clientfilename5 = VWA.GetInputFileName(yrmo, source_Anth);
serverfile1 = Server.MapPath("~/uploads/") + clientfilename1;
serverfile2 = Server.MapPath("~/uploads/") + clientfilename2;
serverfile3 = Server.MapPath("~/uploads/") + clientfilename3;
serverfile4 = Server.MapPath("~/uploads/") + clientfilename4;
serverfile5 = Server.MapPath("~/uploads/") + clientfilename5;
if (_imp.impersonateValidUser(Session["uid"].ToString(), "CORP", EncryptDecrypt.Decrypt(Session["pwd"].ToString())))
{
clientfile1 = VWAImportDAL.GetClientFilePath(_category, source) + "\\" + clientfilename1;
clientfile2 = VWAImportDAL.GetClientFilePath(_category, source) + "\\" + clientfilename2;
clientfile3 = VWAImportDAL.GetClientFilePath(_category, source) + "\\" + clientfilename3;
clientfile4 = VWAImportDAL.GetClientFilePath(_category, source) + "\\" + clientfilename4;
clientfile5 = VWAImportDAL.GetClientFilePath(_category, source) + "\\" + clientfilename5;
if (File.Exists(clientfile1) || File.Exists(clientfile2) || File.Exists(clientfile3) || File.Exists(clientfile4) || File.Exists(clientfile5) || wiredt != String.Empty)
{
if (File.Exists(clientfile1))
{
File.Copy(clientfile1, serverfile1);
filepaths.Add(serverfile1);
sources.Add(source_OC);
}
if (File.Exists(clientfile2))
{
File.Copy(clientfile2, serverfile2);
filepaths.Add(serverfile2);
sources.Add(source_Cigna);
}
if (File.Exists(clientfile3))
{
File.Copy(clientfile3, serverfile3);
filepaths.Add(serverfile3);
sources.Add(source_UHC);
}
if (File.Exists(clientfile4))
{
File.Copy(clientfile4, serverfile4);
filepaths.Add(serverfile4);
sources.Add(source_Disab);
}
if (File.Exists(clientfile5))
{
File.Copy(clientfile5, serverfile5);
filepaths.Add(serverfile5);
sources.Add(source_Anth);
}
_imp.undoImpersonation();
}
else
{
throw new Exception("Error in accessing network location");
}
if (ImportFile(filepaths, sources, wiredt))
{
View_Result();
}
else
{
throw new Exception("Unable to parse reports.<br/>Please check reports type and format.");
}
}
}
catch (Exception ex)
{
resultdiv.Visible = false;
VWAImportDAL.DeleteRemit(yrmo);
ErrMsgDiv1.Visible = true;
lbl_error1.Text = "Error - " + ex.Message;
}
finally
{
if (File.Exists(serverfile1))
{
File.Delete(serverfile1);
}
;
if (File.Exists(serverfile2))
{
File.Delete(serverfile2);
}
;
if (File.Exists(serverfile3))
{
File.Delete(serverfile3);
}
;
if (File.Exists(serverfile4))
{
File.Delete(serverfile4);
}
;
if (File.Exists(serverfile5))
{
File.Delete(serverfile5);
}
;
}
}
}
