internal DataTable FillGridView(UpdateNarrationModel ObjUpdNrraMastModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPNarration";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjUpdNrraMastModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjUpdNrraMastModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjUpdNrraMastModel.DocTypeID);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtNarrationVoucherType = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtNarrationVoucherType);
dtNarrationVoucherType.TableName = "success";
}
catch (Exception)
{
dtNarrationVoucherType = new DataTable();
dtNarrationVoucherType.TableName = "error";
return(dtNarrationVoucherType);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtNarrationVoucherType);
}
public DataTable UpdateProcess(UpdateNarrationModel ObjUpdNrraMastModel)
{
objUpdNarrMasterDA = new UpdateNarrationMasterDataAccess();
DataTable SaveList = objUpdNarrMasterDA.UpdateNarration(ObjUpdNrraMastModel);
return(SaveList);
}
public DataTable FillGrid(UpdateNarrationModel ObjUpdNrraMastModel)
{
objUpdNarrMasterDA = new UpdateNarrationMasterDataAccess();
DataTable fillGrid = objUpdNarrMasterDA.FillGridView(ObjUpdNrraMastModel);
return(fillGrid);
}
public DataTable FillVoucher(UpdateNarrationModel ObjUpdNrraMastModel)
{
objUpdNarrMasterDA = new UpdateNarrationMasterDataAccess();
DataTable fillVoucherType = objUpdNarrMasterDA.LoadVoucherType(ObjUpdNrraMastModel);
return(fillVoucherType);
}
