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