protected void btnPriview_Click(object sender, EventArgs e)
{
DataTable dtTS = objTSM.Get_SOF_SummaryData(ddlEmployee.SelectedValue.Trim(), ddlMonthFrom.SelectedValue.Trim(),
ddlYearFrom.SelectedValue.Trim(), ddlMonthTo.SelectedValue.Trim(), ddlYearTo.SelectedValue.Trim());
grReport.DataSource = dtTS;
grReport.DataBind();
foreach (GridViewRow gRow in grReport.Rows)
{
decimal total = 0;
for (int i = 2; i < dtTS.Columns.Count; i++)
{
if (Common.CheckNullString(gRow.Cells[i].Text) != "")
{
total = total + Convert.ToDecimal(gRow.Cells[i].Text);
}
}
for (int i = 2; i < dtTS.Columns.Count; i++)
{
if (Common.CheckNullString(gRow.Cells[i].Text) != "")
{
gRow.Cells[i].Text = Convert.ToString(Math.Round((Convert.ToDecimal(gRow.Cells[i].Text) * 100 / total), 0)) + "%";
}
}
}
}
