private void PopulateGrid()
{
DataTable dt = new DataTable();
dt = IncentiveDL.SelectIncGen();
grdIncDet.DataSource = dt;
grdIncDetView.PopulateColumns();
grdIncDetView.Columns["IncentiveId"].Visible = false;
grdIncDetView.Columns["Narration"].Visible = false;
grdIncDetView.Columns["TotalAmount"].Visible = false;
grdIncDetView.Columns["IDate"].Caption = "Date";
grdIncDetView.Columns["FDate"].Caption = "From Date";
grdIncDetView.Columns["TDate"].Caption = "To Date";
grdIncDetView.Columns["IRefNo"].Caption = "Reference No";
}
private void EditIncGen()
{
btnGenerate.Enabled = false;
DataTable dt = new DataTable();
dt_IncGen = new DataTable();
dt_IncGenTrans = new DataTable();
dt_IncGen = IncentiveDL.SelectIncGen();
using (DataView dv = new DataView(dt_IncGen)
{
RowFilter = String.Format("IncentiveId={0}", i_mId)
})
{
dt_IncGen = dv.ToTable();
if (dt_IncGen.Rows.Count > 0)
{
IncGenBO.i_IncGenId = i_mId;
DEDate.EditValue = Convert.ToDateTime(dt_IncGen.Rows[0]["IDate"].ToString());
DEFrom.EditValue = Convert.ToDateTime(dt_IncGen.Rows[0]["FDate"].ToString());
DETo.EditValue = Convert.ToDateTime(dt_IncGen.Rows[0]["TDate"].ToString());
txtRefNo.Text = dt_IncGen.Rows[0]["IRefNo"].ToString();
txtNarration.Text = dt_IncGen.Rows[0]["Narration"].ToString();
dt_IncGenTrans = IncentiveDL.SelectIncGenTrans(IncGenBO);
if (dt_IncGenTrans.Rows.Count > 0)
{
dt = (grdIG.DataSource) as DataTable;
for (int i = 0; i <= dt_IncGenTrans.Rows.Count - 1; i++)
{
grdIGView.SetRowCellValue(i, grdIGView.Columns["Amount"].ToString(), dt_IncGenTrans.Rows[i]["Amount"].ToString());
}
}
}
}
grdIGView.UpdateSummary();
}
public static DataTable SelectIncGen()
{
return(IncentiveDL.SelectIncGen());
}
