internal DataTable SaveData(PL_Bank plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("SpMstBank", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", plobj.Ind); cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode); cmd.Parameters.AddWithValue("@BnkCd", plobj.BnkCd); cmd.Parameters.AddWithValue("@BrCd", plobj.BrCd); cmd.Parameters.AddWithValue("@BankName", plobj.BankName); cmd.Parameters.AddWithValue("@BranchName", plobj.BranchName); cmd.Parameters.AddWithValue("@IFSCCode", plobj.IFSCCode); cmd.Parameters.AddWithValue("@AutoNo", plobj.AutoNo); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }
public DataTable BindGrid(PL_Bank plobj) { DL_Bank objdl = new DL_Bank(); DataTable dt = new DataTable(); if (plobj.Ind == 0) { return(dt); } else { dt = objdl.DL_BindGrid(plobj); return(dt); } }
public DataTable SaveData(PL_Bank plobj) { DL_Bank objdl = new DL_Bank(); DataTable dt = new DataTable(); if (plobj.Ind == 0) { return(dt); } else { dt = objdl.SaveData(plobj); return(dt); } }
public DataTable FillddlBank(PL_Bank plobj) { DL_Bank objdl = new DL_Bank(); DataTable dt = new DataTable(); if (plobj.Ind == 0) { return(dt); } else { dt = objdl.FillddlBank(plobj); return(dt); } }
internal DataTable DL_BindGrid(PL_Bank plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("SpMstBank", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", plobj.Ind); cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }