private void SetInitialRowForESICGrid()
{
DataTable table = new DataTable();
DataRow dr = null;
table.Columns.Add("COMP_CODE", typeof(string));
table.Columns.Add("TRAN_TYPE", typeof(string));
table.Columns.Add("TRAN_NO", typeof(string));
table.Columns.Add("FRDT", typeof(string));
table.Columns.Add("TODT", typeof(string));
table.Columns.Add("WRK_HOURS", typeof(string));
table.Columns.Add("CAL_HOURS", typeof(string));
table.Columns.Add("CAL_RATE1", typeof(string));
table.Columns.Add("CAL_RATE2", typeof(string));
dr = table.NewRow();
dr["COMP_CODE"] = string.Empty;
dr["TRAN_TYPE"] = string.Empty;
dr["TRAN_NO"] = string.Empty;
dr["FRDT"] = string.Empty;
dr["TODT"] = string.Empty;
dr["WRK_HOURS"] = string.Empty;
dr["CAL_HOURS"] = string.Empty;
dr["CAL_RATE1"] = string.Empty;
dr["CAL_RATE2"] = string.Empty;
table.Rows.Add(dr);
ViewState["ESICCalculateTable"] = table;
GvESICCalculateMaster.DataSource = table;
GvESICCalculateMaster.DataBind();
}
public void FillGENEARL_MASTERGrid(string CompCode)
{
DataTable Dt = new DataTable();
Dt = GENERAL_MASLogicLayer.GetAllGENERAL_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
DataView DvP = new DataView(Dt);
DvP.RowFilter = "TRAN_TYPE='P'";
DataView DvE = new DataView(Dt);
DvE.RowFilter = "TRAN_TYPE='E'";
DataView DvO = new DataView(Dt);
DvO.RowFilter = "TRAN_TYPE='O'";
DataView DvA = new DataView(Dt);
DvA.RowFilter = "TRAN_TYPE='A'";
GvPFCalculateMaster.DataSource = DvP.ToTable();
GvPFCalculateMaster.DataBind();
GvESICCalculateMaster.DataSource = DvE.ToTable();
GvESICCalculateMaster.DataBind();
GvOTCalculateMaster.DataSource = DvO.ToTable();
GvOTCalculateMaster.DataBind();
GvAllowanceClaculateMaster.DataSource = DvA.ToTable();
GvAllowanceClaculateMaster.DataBind();
//DtSearch = Dv.ToTable();
}