// 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();
}
