public List <WCSA_Entity_Classes.Product> GetAll() { string query = "SELECT ProductCode, ProductName, Price, Quantity FROM PRODUCT"; SqlDataReader reader = DataAccess.GetData(query); WCSA_Entity_Classes.Product product = null; List <WCSA_Entity_Classes.Product> productList = new List <WCSA_Entity_Classes.Product>(); while (reader.Read()) { product = new WCSA_Entity_Classes.Product(); product.ProductName = reader["ProductName"].ToString(); product.ProductCode = reader["ProductCode"].ToString(); product.Price = Convert.ToDouble(reader["Price"].ToString()); product.Quantity = Convert.ToUInt32(reader["Quantity"].ToString()); productList.Add(product); } return(productList); }
public int Edit(WCSA_Entity_Classes.Product product) { string query = "UPDATE PRODUCT SET ProductName='" + product.ProductName + "',Quantity='" + product.Quantity + "', Price='" + product.Price + "' WHERE ProductCode='" + product.ProductCode + "'"; return(DataAccess.ExecuteQuery(query)); }
public int Add(WCSA_Entity_Classes.Product product) { string query = string.Format("INSERT INTO PRODUCT (ProductCode, ProductName, Price, Quantity) VALUES('{0}', '{1}', '{2}', '{3}')", product.ProductCode, product.ProductName, product.Price, product.Quantity); return(DataAccess.ExecuteQuery(query)); }