public Supplier GetLListByStockID(string connString, int stockID) { try { string query = "select Id, Name, Address,Company, Contact from Supplier where Id=(select Sup_id from _Stokc where stock_id=" + stockID + " )"; SqlConnection conn = DBHelper.GetConnection(connString); conn.Open(); BusinessObjects.Supplier pObj = new BusinessObjects.Supplier(); SqlDataReader reader = DBHelper.ReadData(query, conn); while (reader.Read()) { pObj.Id = Convert.ToInt32(reader[0].ToString()); pObj.Name = reader[1].ToString(); pObj.Address = reader[2].ToString(); pObj.Company = reader[3].ToString(); pObj.Contact = reader[4].ToString(); } conn.Close(); return(pObj); } catch (Exception ex) { throw ex; } }
public List <BusinessObjects.Supplier> GetLList(string connString) { try { List <BusinessObjects.Supplier> ProductList = new List <BusinessObjects.Supplier>(); string query = "select Id, Name, Address,Company, Contact from Supplier"; SqlConnection conn = DBHelper.GetConnection(connString); conn.Open(); SqlDataReader reader = DBHelper.ReadData(query, conn); while (reader.Read()) { BusinessObjects.Supplier pObj = new BusinessObjects.Supplier(); pObj.Id = Convert.ToInt32(reader[0].ToString()); pObj.Name = reader[1].ToString(); pObj.Address = reader[2].ToString(); pObj.Company = reader[3].ToString(); pObj.Contact = reader[4].ToString(); ProductList.Add(pObj); } conn.Close(); return(ProductList); } catch (Exception ex) { throw ex; } }