private void FillEmpWiseMovementText(GridView gr)
{
DataTable dtMovText = new DataTable();
dtMovText.Columns.Add("EMPID");
dtMovText.Columns.Add("PAYID");
dtMovText.Columns.Add("EMPLOYEE");
dtMovText.Columns.Add("REMARKS");
dtMovText.AcceptChanges();
foreach (GridViewRow gRow in gr.Rows)
{
DataRow nRow = dtMovText.NewRow();
nRow["EMPID"] = gRow.Cells[1].Text.Trim();
nRow["PAYID"] = gRow.Cells[0].Text.Trim();
nRow["EMPLOYEE"] = gRow.Cells[1].Text.Trim() + " " + gRow.Cells[2].Text.Trim();
nRow["REMARKS"] = objPayRptMgr.GetPayrollRemarks(gRow.Cells[1].Text.Trim(), ddlMonth.SelectedValue.Trim(), ddlYear.SelectedValue.Trim());
if (Common.CheckNullString(nRow["REMARKS"].ToString().Trim()) == "")
{
if (gRow.Cells[0].Text.Trim() == "0")
{
nRow["REMARKS"] = "Seperated effective from " + Common.DisplayDate(objPayRptMgr.GetEmpJoinOrSeperateDate(gRow.Cells[1].Text.Trim(), "SeparateDate"));
}
}
dtMovText.Rows.Add(nRow);
}
dtMovText.AcceptChanges();
grMoveText.DataSource = dtMovText;
grMoveText.DataBind();
}