protected void lnk_genRateRpt_OnClick(object sender, EventArgs e)
{
lblErr1.Text = "";
string _filterPY = ddlFilterPY.SelectedItem.Text;
string _filterPgCd = ddlFilterPgCd.SelectedItem.Text;
DataSet dsrptfinal1 = new DataSet(); dsrptfinal1.Clear();
if (_filterPgCd.Equals("All"))
{
dsrptfinal1 = BenhierDAL.rateReport(_filterPY);
}
else
{
dsrptfinal1 = BenhierDAL.rateReport(_filterPY, _filterPgCd);
}
string filename = "Rates_" + _filterPY;
string[] sheetnames = { "rates_" + _filterPY };
string[][] titles = { new string[] { "Rates Information for Plan year " + _filterPY } };
string[][] colsFormat = { new string[] { "number", "string", "string", "string", "string", "string", "string", "decimal", "decimal", "number" } };
int[][] colsWidth = { new int[] { 70, 100, 90, 70, 200, 80, 80, 75, 90, 100 } };
CreateExcelRpt xlobj = new CreateExcelRpt();
xlobj.ExcelXMLRpt(dsrptfinal1, filename, sheetnames, titles, colsFormat, colsWidth, String.Empty);
}
protected void UpdateRecordRates(object sender, GridViewUpdateEventArgs e)
{
lblErrRate.Text = "";
GridViewRow row = (GridViewRow)grdvRates.Rows[e.RowIndex];
int _rid = Int32.Parse(grdvRates.DataKeys[e.RowIndex].Value.ToString());
TextBox _rateTxt = (TextBox)row.FindControl("txtRateamtA");
TextBox _corateTxt = (TextBox)row.FindControl("txtcoRateamtA");
decimal rate1 = Convert.ToDecimal(_rateTxt.Text);
decimal corate = Convert.ToDecimal(_corateTxt.Text);
ratecolumns oldRValues = BenhierDAL.oldRatesValues(_rid);
try
{
BenhierDAL.updateRates(_rid, rate1, corate);
auditUpdateRates(oldRValues, _rid, rate1, corate);
grdvRates.EditIndex = -1;
bindRateResult();
}
catch (Exception ex)
{
lblErrRate.Text = ex.Message;
}
}
//Delete Planhier table
protected void DeleteRecordBen(object sender, GridViewDeleteEventArgs e)
{
lblErrBen.Text = "";
GridViewRow row = (GridViewRow)grdvBen.Rows[e.RowIndex];
int _phid = Int32.Parse(grdvBen.DataKeys[e.RowIndex].Value.ToString());
planhierRecord delRec = new planhierRecord();
Label _glbl = (Label)row.FindControl("lblGrp");
Label _tlbl = (Label)row.FindControl("lblTier");
Label _plbl = (Label)row.FindControl("lblPlancd");
Label _dlbl = (Label)row.FindControl("lblDesc");
Label _ylbl = (Label)row.FindControl("lblYrmo");
delRec.PlanGroup = _glbl.Text;
delRec.TierCode = _tlbl.Text;
delRec.PlanCode = _plbl.Text;
delRec.PlanDesc = _dlbl.Text;
delRec.EffYrmo = _ylbl.Text;
try
{
BenhierDAL.deletePlanhier(_phid);
auditDeleteBen(delRec, _phid, ddlProgCd.SelectedItem.Value);
//ddlEffYrmo.DataBind();
//ddlProgCd.DataBind();
bindResult();
}
catch (Exception ex)
{
lblErrBen.Text = ex.Message;
}
}
protected void lnk_genTemplateRpt_OnClick(object sender, EventArgs e)
{
lblErr1.Text = "";
string _PY = txtTempPlanYear.Text;
bool _exists = BenhierDAL.checkRatePY(_PY);
if (_exists)
{
string msg = "Rates for entered plan year already defined!";
string alertScript = "<script language=JavaScript> alert('" + msg + "'); <" + "/script>";
if (!ClientScript.IsClientScriptBlockRegistered("alert"))
{
ClientScript.RegisterClientScriptBlock(typeof(Page), "alert", alertScript);
}
}
else
{
DataSet dsrptTemp1 = new DataSet(); dsrptTemp1.Clear();
dsrptTemp1 = BenhierDAL.rateTemplate(_PY);
string filename = "Rates_Template_" + _PY;
string[] sheetnames = { "rates" + _PY };
string[][] titles = { new string[] { "" } };
string[][] colsFormat = { new string[] { "number", "string", "string", "string", "string", "string", "string", "decimal", "decimal", "number" } };
int[][] colsWidth = { new int[] { 70, 100, 90, 70, 200, 80, 80, 75, 90, 100 } };
CreateExcelRpt xlobj = new CreateExcelRpt();
xlobj.ExcelXMLRpt(dsrptTemp1, filename, sheetnames, titles, colsFormat, colsWidth, String.Empty);
}
}
//Update Planhier table
protected void UpdateRecordBen(object sender, GridViewUpdateEventArgs e)
{
lblErrBen.Text = "";
GridViewRow row = (GridViewRow)grdvBen.Rows[e.RowIndex];
int _phid = Int32.Parse(grdvBen.DataKeys[e.RowIndex].Value.ToString());
DropDownList _grpDDLU = (DropDownList)row.FindControl("ddlGrp");
DropDownList _tierDDLU = (DropDownList)row.FindControl("ddlTier");
TextBox _planTxtU = (TextBox)row.FindControl("txtPlancd");
TextBox _dscTxtU = (TextBox)row.FindControl("txtDesc");
TextBox _yrmoTxtU = (TextBox)row.FindControl("txtYrmo");
string _grp = _grpDDLU.SelectedItem.Text;
string _tier = _tierDDLU.SelectedItem.Text;
string _plan = _planTxtU.Text;
string _dsc = _dscTxtU.Text;
string _yrmoeff = _yrmoTxtU.Text;
string _bid = ddlProgCd.SelectedItem.Value;
planhierRecord oldValues = BenhierDAL.oldplanhierValues(_phid);
try
{
BenhierDAL.updatePlanhier(_phid, _grp, _plan, _dsc, _tier, _yrmoeff);
auditUpdateBen(oldValues, _phid, _grp, _tier, _plan, _dsc, _yrmoeff, _bid);
grdvBen.EditIndex = -1;
bindResult();
}
catch (Exception ex)
{
lblErrBen.Text = ex.Message;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
lblErrBen.Text = "";
DropDownList _groupDL = grdvBen.FooterRow.FindControl("ddlGrpA") as DropDownList;
DropDownList _tiercdDL = grdvBen.FooterRow.FindControl("ddlTierA") as DropDownList;
TextBox _plancdTB = grdvBen.FooterRow.FindControl("txtPlancdA") as TextBox;
TextBox _descTB = grdvBen.FooterRow.FindControl("txtDescA") as TextBox;
TextBox _effyrmoTB = grdvBen.FooterRow.FindControl("txtYrmoA") as TextBox;
int _benId = Convert.ToInt32(ddlProgCd.SelectedItem.Value);
string _group = _groupDL.SelectedValue;
string _tier = _tiercdDL.SelectedValue;
string _plancd = _plancdTB.Text;
string _desc = _descTB.Text;
string _eyrmo = _effyrmoTB.Text;
string _progcd = ddlProgCd.SelectedItem.Text;
try
{
BenhierDAL.insertPlanhier(_benId, _progcd, _group, _plancd, _desc, _tier, _eyrmo);
auditInsertBen(_benId, _progcd, _group, _plancd, _desc, _tier, _eyrmo);
bindResult();
}
catch (Exception ex)
{
lblErrBen.Text = ex.Message;
}
}
protected void lnk_genBenRpt_OnClick(object sender, EventArgs e)
{
lblErr1.Text = "";
string _filter = ddlFilter1.SelectedItem.Text;
DataSet dsrptfinal = new DataSet(); dsrptfinal.Clear();
if (_filter.Equals("All"))
{
dsrptfinal = BenhierDAL.benhierReport();
}
else
{
dsrptfinal = BenhierDAL.benhierReport(_filter);
}
string filename = "Benefits_Hierarchy";
string[] sheetnames = { "ben_hierarchy" };
string[][] titles = { new string[] { "Benefits Hierarchy Report" } };
string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "number" } };
int[][] colsWidth = { new int[] { 100, 100, 70, 200, 80, 80, 100 } };
CreateExcelRpt xlobj = new CreateExcelRpt();
xlobj.ExcelXMLRpt(dsrptfinal, filename, sheetnames, titles, colsFormat, colsWidth, String.Empty);
}
protected void DeleteRecordRates(object sender, GridViewDeleteEventArgs e)
{
lblErrRate.Text = "";
GridViewRow row = (GridViewRow)grdvRates.Rows[e.RowIndex];
int _rid = Int32.Parse(grdvRates.DataKeys[e.RowIndex].Value.ToString());
ratecolumns delRec = new ratecolumns();
Label _r1lbl = (Label)row.FindControl("lblRateamtA");
Label _r2lbl = (Label)row.FindControl("lblcoRateamtA");
Label _ylbl = (Label)row.FindControl("lblRateYrmoA");
delRec.EErate = Convert.ToDecimal(_r1lbl.Text);
delRec.COrate = Convert.ToDecimal(_r2lbl.Text);
delRec.EffYrmo = _ylbl.Text;
try
{
BenhierDAL.deleteRates(_rid);
auditDeleteRates(delRec, _rid);
bindRateResult();
}
catch (Exception ex)
{
lblErrRate.Text = ex.Message;
}
}
protected void btn_import_Click(object sender, EventArgs e)
{
string strFilePath1 = "";
lbl_error.Text = "";
lbl_result.Text = "";
string _yr = txtTempPlanYearImp.Text;
if (FileUpload1.GotFile && Page.IsValid)
{
try
{
bool _pycheck = BenhierDAL.checkRatePY(_yr);
if (!_pycheck)
{
string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName);
if (fn.Contains(_yr))
{
strFilePath1 = Server.MapPath("~/uploads/") + fn;
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.SaveAs(strFilePath1);
int _cnt = IPBAImport.importRatesTemplate(strFilePath1, _yr);
lbl_result.Text = "Imported Rates successfully for year - " + _yr;
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskINRC(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "IPBA", "New Rates Import", "Rates", "New Rates", _yr, _cnt);
}
else
{
throw (new Exception("File Plan year doesn't match with entered Plan year!"));
}
}
else
{
throw (new Exception("Rates for the entered Plan Year already defined!"));
}
}
catch (Exception ex)
{
lbl_error.Text = "Error in importing file. " + ex.Message;
}
finally
{
FileUpload1.FilePost.InputStream.Flush();
FileUpload1.FilePost.InputStream.Close();
FileUpload1.FilePost.InputStream.Dispose();
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
}
}
}
protected void bindratefooterplan()
{
string _prgcd = ddlRProgcd.SelectedItem.Text;
DropDownList _planDDL = grdvRates.FooterRow.FindControl("ddlRatePlancdA") as DropDownList;
List <string> _pln = BenhierDAL.getRatePlancodes(_prgcd);
_planDDL.Items.Clear();
_planDDL.Items.Add("--Select--");
foreach (string p in _pln)
{
_planDDL.Items.Add(p);
}
}
protected void lnk_genDtlRptA2_OnClick(object sender, EventArgs e)
{
string filename = "Planhier_Rate_Audit";
string[] sheetnames = { "rate_audit" };
string[] titles = { "Audit Information for Planhier Rates" };
string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string", "string", "string" } };
CAExcelRpt xlobj = new CAExcelRpt();
DataSet dsrptA2 = new DataSet();
dsrptA2 = BenhierDAL.getRateAuditReport();
xlobj.ExcelXMLRpt(dsrptA2, filename, sheetnames, titles, colsFormat);
}
protected void lnk_genDtlRptA1_OnClick(object sender, EventArgs e)
{
string filename = "Benefit_Hierarchy_Audit";
string[] sheetnames = { "ben_audit" };
string[] titles = { "Audit Information for Benefit Hierarchy" };
string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string" } };
CAExcelRpt xlobj = new CAExcelRpt();
DataSet dsrptA1 = new DataSet();
dsrptA1 = BenhierDAL.getPlanhierAuditReport();
xlobj.ExcelXMLRpt(dsrptA1, filename, sheetnames, titles, colsFormat);
}
//Bind effyrmo based on planyear selected
protected void ddlRpy_onSelectedindexchange(object sender, EventArgs e)
{
string _py = ddlRpy.SelectedItem.Text;
ddlREffYrmo.Items.Clear();
ddlREffYrmo.Items.Add("--Select--");
List <string> _yrmorate = new List <string>();
_yrmorate = BenhierDAL.getPYyrmo(_py);
foreach (string _x in _yrmorate)
{
ddlREffYrmo.Items.Add(_x);
}
}
private void bindResult()
{
string _progcd = ddlProgCd.SelectedItem.Text;
string _eyrmo = ddlEffYrmo.SelectedItem.Text;
DataSet ds1 = new DataSet();
lblHeading.Text = "Benefit Hierarchy Information for Program Code - '" + _progcd + "'";
ds1 = BenhierDAL.getplanhierA(_progcd, _eyrmo);
//if (ds1.Tables[0].Rows.Count > 0)
//{
grdvBen.DataSource = ds1;
grdvBen.DataBind();
//}
}
private void bindRateResult()
{
string _py = ddlRpy.SelectedItem.Text;
string _Rprogcd = ddlRProgcd.SelectedItem.Text;
//string _Rbencd = ddlRBencd.SelectedItem.Text;
string _Reyrmo = ddlREffYrmo.SelectedItem.Text;
DataSet dsR = new DataSet();
lblRateHeading.Text = "Rates Information for Program Code - '" + _Rprogcd + "'";
dsR = BenhierDAL.getplanRatesA(_py, _Reyrmo, _Rprogcd);
grdvRates.DataSource = dsR;
grdvRates.DataBind();
bindratefooterplan();
}
private void SortGridView(string sortExpression, string direction, string src)
{
DataTable dt;
DataView dv;
if (src.Equals("Ben"))
{
string _progcd = ddlProgCd.SelectedItem.Text;
//string _bencd = ddlBencd.SelectedItem.Text;
string _eyrmo = ddlEffYrmo.SelectedItem.Text;
dt = BenhierDAL.getplanhierA(_progcd, _eyrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvBen.DataSource = dv;
grdvBen.DataBind();
}
else if (src.Equals("Rate"))
{
string _py = ddlRpy.SelectedItem.Text;
string _Rprogcd = ddlRProgcd.SelectedItem.Text;
//string _Rbencd = ddlRBencd.SelectedItem.Text;
string _Reyrmo = ddlREffYrmo.SelectedItem.Text;
dt = BenhierDAL.getplanRatesA(_py, _Reyrmo, _Rprogcd).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvRates.DataSource = dv;
grdvRates.DataBind();
bindratefooterplan();
}
else if (src.Equals("PAudit"))
{
dt = BenhierDAL.getPlanhierAuditReport().Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdv_dtlBenAud.DataSource = dv;
grdv_dtlBenAud.DataBind();
}
else if (src.Equals("RAudit"))
{
dt = BenhierDAL.getRateAuditReport().Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdv_dtlrateAud.DataSource = dv;
grdv_dtlrateAud.DataBind();
}
}
//Bind effyrmo based on planyear selected
protected void ddlRPlancd_onSelectedindexchange(object sender, EventArgs e)
{
TextBox _descTB = grdvRates.FooterRow.FindControl("txtRateDescA") as TextBox;
_descTB.Text = "";
string _pcode = ((DropDownList)grdvRates.FooterRow.FindControl("ddlRatePlancdA")).SelectedItem.Text;
_descTB.Text = BenhierDAL.planDesc(_pcode);
DropDownList _tierDDL = (DropDownList)grdvRates.FooterRow.FindControl("ddlRateTierA");
List <string> _tr = BenhierDAL.getRateTiercodes(_pcode);
_tierDDL.Items.Clear();
_tierDDL.Items.Add("--Select--");
foreach (string t in _tr)
{
_tierDDL.Items.Add(t);
}
}
void bindAuditReport(string _src)
{
DataSet bindDs = new DataSet();
bindDs.Clear();
switch (_src)
{
case "Planhier":
bindDs = BenhierDAL.getPlanhierAuditReport();
grdv_dtlBenAud.DataSource = bindDs;
grdv_dtlBenAud.DataBind();
break;
case "Rates":
bindDs = BenhierDAL.getRateAuditReport();
grdv_dtlrateAud.DataSource = bindDs;
grdv_dtlrateAud.DataBind();
break;
}
}
protected void Button1R_Click(object sender, EventArgs e)
{
lblErrRate.Text = "";
string _progcd = ddlRProgcd.SelectedItem.Text;
ratecolumns insertRec = new ratecolumns();
insertRec.PlanCode = ((DropDownList)grdvRates.FooterRow.FindControl("ddlRatePlancdA")).SelectedItem.Text;
insertRec.TierCode = ((DropDownList)grdvRates.FooterRow.FindControl("ddlRateTierA")).SelectedItem.Text;
insertRec.EErate = Convert.ToDecimal(((TextBox)grdvRates.FooterRow.FindControl("txtRateamtA")).Text);
insertRec.COrate = Convert.ToDecimal(((TextBox)grdvRates.FooterRow.FindControl("txtcoRateamtA")).Text);
insertRec.PlanDesc = ((TextBox)grdvRates.FooterRow.FindControl("txtRateDescA")).Text;
insertRec.EffYrmo = ((TextBox)grdvRates.FooterRow.FindControl("txtRateYrmoA")).Text;
try
{
BenhierDAL.insertRates(insertRec, _progcd);
auditInsertRates(insertRec);
bindRateResult();
}
catch (Exception ex)
{
lblErrRate.Text = ex.Message;
}
}
