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;
}
}
}