internal DataTable LoadGSTINDetails(BranchMasterModel objBMModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPBranch"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objBMModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBMModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@GSTINID", objBMModel.GSTINID); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtBranchMaster = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtBranchMaster); dtBranchMaster.TableName = "success"; } catch (Exception) { dtBranchMaster = new DataTable(); dtBranchMaster.TableName = "error"; return(dtBranchMaster); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtBranchMaster); }
internal DataTable SaveBranch(BranchMasterModel objBMModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPBranch"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objBMModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBMModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@GSTINID", objBMModel.GSTINID); ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objBMModel.GSTIN); ClsCon.cmd.Parameters.AddWithValue("@BrName", objBMModel.BranchName); ClsCon.cmd.Parameters.AddWithValue("@BrAddress", objBMModel.Address); ClsCon.cmd.Parameters.AddWithValue("@City", objBMModel.City); ClsCon.cmd.Parameters.AddWithValue("@StateID", objBMModel.StateID); ClsCon.cmd.Parameters.AddWithValue("@PinCode", objBMModel.PinCode); ClsCon.cmd.Parameters.AddWithValue("@InvoiceNoSeries", objBMModel.InvoiceNoSeries); ClsCon.cmd.Parameters.AddWithValue("@InvoiceNo", objBMModel.InvoiceNo); ClsCon.cmd.Parameters.AddWithValue("@User", objBMModel.User); ClsCon.cmd.Parameters.AddWithValue("@IP", objBMModel.IP); //ClsCon.cmd.Parameters.AddWithValue("@TblSeries", objBMModel.DtSeries); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtBranchMaster = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtBranchMaster); dtBranchMaster.TableName = "success"; } catch (Exception) { dtBranchMaster = new DataTable(); dtBranchMaster.TableName = "error"; return(dtBranchMaster); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtBranchMaster); }
public DataTable LoadGSTINDetails(BranchMasterModel objBMModel) { DataTable dtLoadGSTINDetails = objBMDA.LoadGSTINDetails(objBMModel); return(dtLoadGSTINDetails); }
public DataTable SaveBranch(BranchMasterModel objBMModel) { DataTable dtSaveBranch = objBMDA.SaveBranch(objBMModel); return(dtSaveBranch); }
public DataSet LoadBMDDL(BranchMasterModel objBMModel) { DataSet dsLoadBMDDL = objBMDA.LoadBMDDL(objBMModel); return(dsLoadBMDDL); }