internal DataTable FillGridCLientGstin(ClientGstinModel ObjClientGSTINModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPGSTR1"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjClientGSTINModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjClientGSTINModel.OrgID); // ClsCon.cmd.Parameters.AddWithValue("@ItemID", ObjClientGSTINModel.ItemID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjClientGSTINModel.BrID); //ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjopenStockModel.YrCD); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtClientGstin = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtClientGstin); dtClientGstin.TableName = "success"; } catch (Exception) { dtClientGstin = new DataTable(); dtClientGstin.TableName = "error"; return(dtClientGstin); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtClientGstin); }
public DataTable FillGridGstin(ClientGstinModel ObjClientGstinModel) { DataTable dtFillClientGstin = objClientGstinDA.FillGridCLientGstin(ObjClientGstinModel); return(dtFillClientGstin); }