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