public bool AddOrder(Order o) { using (TargilsicumEntities entities = new TargilsicumEntities()) { try { entities.Order.Add(o); entities.SaveChanges(); Console.WriteLine($"Order {o.ID} Added successfully"); return true; } catch (Exception) { Console.WriteLine($"can't add this order {o.ID}"); return false; } } }
public bool UpdateOrder(Order o, int price) { using (TargilsicumEntities entities = new TargilsicumEntities()) { try { entities.Order.Take(1).FirstOrDefault().PRICE = price; entities.SaveChanges(); Console.WriteLine($"order price update successfully"); return true; } catch (Exception) { Console.WriteLine($"can't update order"); return false; } } }
public bool UpdateCustomer(Customer c, string newName) { using (TargilsicumEntities entities = new TargilsicumEntities()) { try { entities.Customer.Take(1).FirstOrDefault().NAME = $"{newName}"; entities.SaveChanges(); Console.WriteLine($"Customer name update successfully"); return true; } catch (Exception) { Console.WriteLine($"can't update customer"); return false; } } }
public bool RemoveOrder(int orderId) { using (TargilsicumEntities entities = new TargilsicumEntities()) { try { entities.Order.Remove(entities.Order.FirstOrDefault(o => o.ID == orderId)); entities.SaveChanges(); Console.WriteLine($"Order id {orderId} removed successfully"); return true; } catch (Exception) { Console.WriteLine($"can't remove order id {orderId}"); return false; } } }
public bool RemoveCustomer(int customerId) { using (TargilsicumEntities entities = new TargilsicumEntities()) { try { entities.Customer.Remove(entities.Customer.FirstOrDefault(c => c.ID == customerId)); entities.SaveChanges(); Console.WriteLine($"Customer id {customerId} removed successfully"); return true; } catch (Exception) { Console.WriteLine($"can't remove customer id {customerId}"); return false; } } }
public bool AddCustomer(Customer c) { using (TargilsicumEntities entities = new TargilsicumEntities()) { try { entities.Customer.Add(c); entities.SaveChanges(); Console.WriteLine($"Customer {c.NAME} Added successfully"); return true; } catch (Exception) { Console.WriteLine($"can't add this customer name {c.NAME}"); return false; } } }