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); }