public void Retention()
{
Cls_BLL_Dashboard objAsPl = new Cls_BLL_Dashboard();
DataTable Tblretention = objAsPl.getRetention(username, Session["DASHOperid"].ToString(), Session["DASHCatid"].ToString());
if (Tblretention.Rows.Count > 0)
{
DataTable Tblretention1 = new DataTable();
DataTable Tblretention2 = new DataTable();
DataTable Tblretention3 = new DataTable();
Tblretention1 = Tblretention.Clone();
Tblretention2 = Tblretention.Clone();
Tblretention3 = Tblretention.Clone();
for (int i = 0; i < Tblretention.Rows.Count; i++)
{
if (i < 4)
{
Tblretention1.ImportRow(Tblretention.Rows[i]);
}
else if (i < 7)
{
Tblretention2.ImportRow(Tblretention.Rows[i]);
}
else
{
Tblretention3.ImportRow(Tblretention.Rows[i]);
}
}
if (Tblretention1.Rows.Count > 0)
{
lblCurrentStb.Text = Tblretention1.Rows[0]["col1"].ToString();
lblLastSTB.Text = Tblretention1.Rows[0]["col2"].ToString();
lblLastAchievement.Text = Tblretention1.Rows[0]["col3"].ToString();
lblTotExpiry.Text = Tblretention1.Rows[1]["col1"].ToString();
lblLastReduction.Text = Tblretention1.Rows[1]["col2"].ToString();
lblRenewlMTD.Text = Tblretention1.Rows[2]["col1"].ToString();
lblLastExpiry.Text = Tblretention1.Rows[2]["col2"].ToString();
lblMTDAchieved.Text = Tblretention1.Rows[3]["col1"].ToString() + "%";
lblLastRenewal.Text = Tblretention1.Rows[3]["col2"].ToString();
}
grdretention1.DataSource = Tblretention2;
grdretention1.DataBind();
grdretention2.Columns[1].FooterText = Tblretention3.AsEnumerable().Select(x => x.Field <decimal>("col1")).Sum().ToString();
grdretention2.Columns[2].FooterText = Tblretention3.AsEnumerable().Select(x => x.Field <decimal>("col2")).Sum().ToString();
grdretention2.Columns[3].FooterText = Tblretention3.AsEnumerable().Select(x => x.Field <decimal>("col3")).Sum().ToString();
grdretention2.Columns[4].FooterText = Tblretention3.AsEnumerable().Select(x => x.Field <decimal>("col4")).Sum().ToString();
grdretention2.Columns[5].FooterText = Tblretention3.AsEnumerable().Select(x => x.Field <decimal>("col5")).Sum().ToString();
grdretention2.Columns[6].FooterText = Tblretention3.AsEnumerable().Select(x => x.Field <decimal>("col6")).Sum().ToString();
grdretention2.DataSource = Tblretention3;
grdretention2.DataBind();
}
}
