public ssmtbl_CustomerVendorMasterModel GetOneVendor(int Id) { ssmtbl_CustomerVendorMasterModel objVend = new ssmtbl_CustomerVendorMasterModel(); try { var connection = gConnection.Connection(); connection.Open(); string sqlstr = "ssmsp_Get_AllVendor"; SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", Id); cmd.Parameters.AddWithValue("@Action", "GetVendorByID"); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objVend.Name = sdr["Name"].ToString(); objVend.Telephone_No = (sdr["Telephone_No"].ToString()); objVend.STD_Code = Convert.ToInt32(sdr["STD_Code"].ToString()); objVend.Address = sdr["Address"].ToString(); objVend.City = sdr["City"].ToString(); objVend.Pincode = Convert.ToInt32(sdr["Pincode"].ToString()); objVend.Contact_Person = sdr["Contact_Person"].ToString(); objVend.Email_ID = sdr["Email_ID"].ToString(); objVend.Mobile_No = Convert.ToInt32(sdr["Mobile_No"].ToString()); objVend.Remarks = sdr["Remarks"].ToString(); objVend.Vendor_Code = sdr["Vendor_Code"].ToString(); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objVend); }
// # region Insert Contact Person //public string InsertCPIntoDB(long id) //{ // string s = ""; // string vc = "0"; // try // { // var connection = gConnection.Connection(); // connection.Open(); // string sqlstr = "ssmsp_Get_AllVendor"; // SqlCommand cmd = new SqlCommand(sqlstr, connection); // cmd.CommandType = System.Data.CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@type", "vendor"); // cmd.Parameters.AddWithValue("@Action", "FindmaxVendorCode"); // SqlDataReader sdr = cmd.ExecuteReader(); // while (sdr.Read()) // { // vc = (sdr["Vendor_Code"].ToString()); // s = vc == "" ? "VC-00001" : ("VC-" + ((Convert.ToInt64(vc.Split('-')[1]) + 1).ToString("00000"))); // } // connection.Close(); // } // catch (Exception ex) // { // s = "VC-00001"; // ErrorHandlerClass.LogError(ex); // } // return s; //} //#endregion #region Get All Vendor public List <ssmtbl_CustomerVendorMasterModel> GetAllVendor() { List <ssmtbl_CustomerVendorMasterModel> objVendorList = new List <ssmtbl_CustomerVendorMasterModel>(); try { var connection = gConnection.Connection(); connection.Open(); string sqlstr = "ssmsp_Get_AllVendor"; SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "Select"); cmd.Parameters.AddWithValue("@Type", "vendor"); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_CustomerVendorMasterModel objtemp = new ssmtbl_CustomerVendorMasterModel(); objtemp.ID = Convert.ToInt32(sdr["ID"].ToString()); objtemp.Name = sdr["Name"].ToString(); objtemp.Address = (sdr["Address"].ToString()); objtemp.City = sdr["City"].ToString(); objtemp.Pincode = Convert.ToInt32(sdr["Pincode"].ToString()); objtemp.Vendor_Code = ((sdr["Vendor_Code"])).ToString(); var remark = ((sdr["Remarks"])).ToString(); objtemp.Remarks = remark == "" ? "NA" : remark; objVendorList.Add(objtemp); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objVendorList); }