private void remitReport()
{
DataTable dtsumTemp = new DataTable();
DataRow rowNew;
_rfdxT = 0; _rvwaT = 0;
dtsumTemp = VWA_DAL.getRemitData_4Balancing(ddlYrmo.SelectedItem.Text);
if (dtsumTemp.Rows.Count > 0)
{
foreach (DataRow dr in dtsumTemp.Rows)
{
rowNew = tbSum2.NewRow();
rowNew["Remit WireDt"] = dr["WireDt"];
rowNew["Remit ClientId"] = dr["ClientId"];
rowNew["Remit Client Name"] = dr["ClientName"];
rowNew["Remit FDX Amount"] = dr["Acme"].ToString().Equals("0") ? "" : dr["Acme"];
rowNew["Remit VWA Amount"] = dr["VWA"].ToString().Equals("0") ? "" : dr["VWA"];
tbSum2.Rows.Add(rowNew);
}
_rfdxT =
Convert.ToDecimal(dtsumTemp.Compute("SUM([Acme])", String.Empty).ToString());
_rvwaT =
Convert.ToDecimal(dtsumTemp.Compute("SUM([VWA])", String.Empty).ToString());
rowNew = tbSum2.NewRow();
rowNew["Remit Client Name"] = "Total:";
rowNew["Remit FDX Amount"] = _rfdxT;
rowNew["Remit VWA Amount"] = _rvwaT;
tbSum2.Rows.Add(rowNew);
}
}
private void getAdjustments()
{
DataTable dtadjTemp = new DataTable();
_radj = new List <decimal>(); _badj = new List <decimal>(); _dadj = new List <decimal>();
_rnotes = new List <string>(); _bnotes = new List <string>(); _dnotes = new List <string>();
dtadjTemp = VWA_DAL.getAdjustmentData_4Balancing(ddlYrmo.SelectedItem.Text);
if (dtadjTemp.Rows.Count > 0)
{
foreach (DataRow dr in dtadjTemp.Rows)
{
string _src = dr["AdjType"].ToString();
switch (_src)
{
case "Remittance":
_radj.Add(Convert.ToDecimal(dr["Amount"]));
_rnotes.Add(dr["Notes"].ToString());
break;
case "Bank Statement":
_badj.Add(Convert.ToDecimal(dr["Amount"]));
_bnotes.Add(dr["Notes"].ToString());
break;
case "Detail File":
_dadj.Add(Convert.ToDecimal(dr["Amount"]));
_dnotes.Add(dr["Notes"].ToString());
break;
}
}
}
}
protected void btnName_Click(Object sender, EventArgs e)
{
clearMessages();
if (txtFirst.Text.Equals("") && txtLast.Text.Equals(""))
{
errorDiv1.Visible = true;
lblError1.Text = "One of the two name fields is required.";
}
else
{
try
{
DataTable dt = new DataTable();
dt = VWA_DAL.employeeData(txtLast.Text, txtFirst.Text);
grdvEmployee.DataSource = dt;
grdvEmployee.DataBind();
EmpListDiv.Visible = true;
}
catch (Exception ex)
{
errorDiv1.Visible = true;
lblError1.Text = ex.Message;
}
}
}
private void SortGridView(string sortExpression, string direction)
{
DataTable dt1 = new DataTable();
dt1 = VWA_DAL.employeeData(txtLast.Text, txtFirst.Text);
DataView dv;
dv = new DataView(dt1);
dv.Sort = sortExpression + direction;
grdvEmployee.DataSource = dv;
grdvEmployee.DataBind();
EmpListDiv.Visible = true;
}
protected void btnNotes_OnClick(Object sender, EventArgs e)
{
clearMessages();
try
{
VWA_DAL.insertCaseNotes(txtNotes.Text, Session["yrmo"].ToString(), txtCon.Text);
lbl_result.Visible = true;
}
catch (Exception ex)
{
errorDiv1.Visible = true;
lblError1.Text = ex.Message;
}
}
private void detailReport()
{
DataTable dttransTemp = new DataTable();
_dfdxT = 0; _dvwaT = 0;
dttransTemp = VWA_DAL.getTransactionData_4Balancing(ddlYrmo.SelectedItem.Text);
if (dttransTemp.Rows.Count > 0)
{
foreach (DataRow dr in dttransTemp.Rows)
{
_dfdxT = Convert.ToDecimal(dr["Acme"]);
_dvwaT = Convert.ToDecimal(dr["VWA"]);
}
}
}
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;
}
}
