// return MWhareHouse public static List <MWhareHouse> selectAll() { string query = "select * from wharehouse;"; List <MWhareHouse> ware = new List <MWhareHouse>(); connect.Open(); SqlCommand cmd = new SqlCommand(query, connect); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string useID = reader["id"].ToString(); int userid = Convert.ToInt32(useID); MWhareHouse us = new MWhareHouse(); us.id = userid; us.productName = reader["productName"].ToString(); us.quantity = Convert.ToInt32(reader["quantity"].ToString()); us.price = reader["price"].ToString(); us.date = reader["date"].ToString(); us.totalPrice = reader["total price"].ToString(); ware.Add(us); } connect.Close(); return(ware); }
// add new warehouse. public static void addTo(MWhareHouse ware) { string query = "insert into wharehouse values(@prouctName,@quantity,@price,@date,@totprice)"; connect.Open(); SqlCommand cmd = new SqlCommand(query, connect); cmd.Parameters.AddWithValue("@prouctName", ware.productName); cmd.Parameters.AddWithValue("@quantity", ware.quantity); cmd.Parameters.AddWithValue("@price", ware.price); cmd.Parameters.AddWithValue("@date", ware.date); cmd.Parameters.AddWithValue("@totprice", ware.totalPrice); cmd.ExecuteNonQuery(); connect.Close(); }
public static void update(MWhareHouse ware) { string query = "UPDATE wharehouse set productName=@productName,quantity=@quantity, price=@price,date=@date, totalPrice=@totprice where id=@id"; SqlCommand cmd = new SqlCommand(query, connect); connect.Open(); cmd.Parameters.AddWithValue("@id", ware.id); cmd.Parameters.AddWithValue("@productName", ware.productName); cmd.Parameters.AddWithValue("@quantity", ware.quantity); cmd.Parameters.AddWithValue("@price", ware.price); cmd.Parameters.AddWithValue("@date", ware.date); cmd.Parameters.AddWithValue("@totprice", ware.totalPrice); cmd.ExecuteNonQuery(); connect.Close(); }