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);;
            }
        }
예제 #2
0
 public void Put(UpdatePurchase purchase)
 {
     purchaseDataAccess.UpdatePurchase(purchase);
 }