public void addItemWarehouse(Item_Warehouse iw) { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Insert into Item_Warehouse values(@itemId,@warehouseId,@quantity,@orders)", con); cmd.Parameters.AddWithValue("@itemId", iw.itemId); cmd.Parameters.AddWithValue("@warehouseId", iw.warehouseId); cmd.Parameters.AddWithValue("@quantity", iw.quantity); cmd.Parameters.AddWithValue("@orders", iw.orders); con.Open(); cmd.ExecuteNonQuery(); } }
public void updateItemWarehouse(Item_Warehouse iw) { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Update Item_Warehouse SET quantity=@quantity Where(itemId=@itemId AND warehouseId=@warehouseId)", con); cmd.Parameters.AddWithValue("@quantity", iw.quantity); cmd.Parameters.AddWithValue("@itemId", iw.itemId); cmd.Parameters.AddWithValue("@warehouseId", iw.warehouseId); con.Open(); cmd.ExecuteNonQuery(); } }