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