public bool RemoveCustomer(int customerId)
{
if (customerId > 0)
{
using (sql36Entities entities = new sql36Entities())
{
entities.Customers.Remove(entities.Customers.Where(c => c.Id == customerId).Take(1).FirstOrDefault());
entities.SaveChanges();
return(true);
}
}
return(false);
}
public bool AddCustomer(Customer customer)
{
if (customer != null)
{
using (sql36Entities entities = new sql36Entities())
{
entities.Customers.Add(customer);
entities.SaveChanges();
return(true);
}
}
return(false);
}
public bool AddOrder(Order order)
{
if (order != null)
{
using (sql36Entities entities = new sql36Entities())
{
entities.Orders.Add(order);
entities.SaveChanges();
return(true);
}
}
return(false);
}
public bool RemoveOrder(int orderId)
{
using (sql36Entities entities = new sql36Entities())
{
if (entities.Orders.Where(o => o.Id == orderId).FirstOrDefault() != null)
{
entities.Orders.Remove(entities.Orders.Where(o => o.Id == orderId).Take(1).FirstOrDefault());
entities.SaveChanges();
Console.WriteLine("removed successfully!");
return(true);
}
Console.WriteLine("no order with this id was found!");
return(false);
}
}
public bool UpdateCustomer(int customerId, Customer customer)
{
if (customerId > 0 && customer != null)
{
using (sql36Entities entities = new sql36Entities())
{
var selectedCustomer = entities.Customers.Where(c => c.Id == customerId).Take(1).FirstOrDefault();
selectedCustomer.Id = customer.Id;
selectedCustomer.Name = customer.Name;
selectedCustomer.Country = customer.Country;
selectedCustomer.Age = customer.Age;
entities.SaveChanges();
return(true);
}
}
return(false);
}
public bool UpdateOrder(int orderId, Order order)
{
using (sql36Entities entities = new sql36Entities())
{
if (entities.Orders.Where(o => o.Id == orderId).FirstOrDefault() != null && order != null)
{
var selectedOrder = entities.Orders.Where(o => o.Id == orderId).Take(1).FirstOrDefault();
selectedOrder.Id = order.Id;
selectedOrder.Customer_Id = order.Customer_Id;
selectedOrder.Price = order.Price;
selectedOrder.Date = order.Date;
entities.SaveChanges();
return(true);
}
return(false);
}
}