public void UpdatePurchase(UpdatePurchase purchase) { const string query = @"UPDATE Purchase SET SupplyId = @supplyId WHERE PurchaseId = @purchaseId"; try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@supplyId", purchase.SupplyId); cmd.Parameters.AddWithValue("@purchaseId", purchase.PurchaseId); cmd.ExecuteNonQuery(); } } catch (Exception ex) { Console.WriteLine(ex.Message);; } }
public void Put(UpdatePurchase purchase) { purchaseDataAccess.UpdatePurchase(purchase); }