public List <Order> GetAllOrdersByCustomerId(int customerID)
{
List <Order> listOfOrders = new List <Order>();
using (EntityModelConnectionSettings entitySettings = new EntityModelConnectionSettings())
{
listOfOrders.AddRange(entitySettings.Orders.Where(x => x.customer_ID.Equals(customerID)));
}
return(listOfOrders);
}
public List <Order> GetAllOrders()
{
List <Order> listOfOrders = new List <Order>();
using (EntityModelConnectionSettings entitySettings = new EntityModelConnectionSettings())
{
listOfOrders.AddRange(entitySettings.Orders);
}
return(listOfOrders);
}
public bool AddOrder(Order order)
{
bool toReturn = false;
try
{
using (EntityModelConnectionSettings entitySettings = new EntityModelConnectionSettings())
{
entitySettings.Orders.Add(order);
entitySettings.SaveChanges();
toReturn = true;
}
}
catch
{
toReturn = false;
}
return(toReturn);
}
public bool RemoveOrder(int orderID)
{
bool toReturn = false;
try
{
using (EntityModelConnectionSettings entitySettings = new EntityModelConnectionSettings())
{
entitySettings.Orders.ToList().ForEach(x => { if (x.ID == orderID)
{
entitySettings.Orders.Remove(x); entitySettings.SaveChanges(); toReturn = true;
}
});
}
}
catch
{
toReturn = false;
}
return(toReturn);
}
public bool UpdateCustomer(Customer customer)
{
bool toReturn = false;
try
{
using (EntityModelConnectionSettings entitySettings = new EntityModelConnectionSettings())
{
entitySettings.Customers.ToList().ForEach(x => { if (x.ID == customer.ID)
{
entitySettings.Customers.Remove(x);
entitySettings.Customers.Add(customer);
entitySettings.SaveChanges(); toReturn = true;
}
});
}
}
catch
{
toReturn = false;
}
return(toReturn);
}
public bool GetOrderById(int orderID, out Order order)
{
bool toReturn = false;
Order findOrd = null;
try
{
using (EntityModelConnectionSettings entitySettings = new EntityModelConnectionSettings())
{
entitySettings.Orders.ToList().ForEach(x => { if (x.ID == orderID)
{
findOrd = x; toReturn = true;
}
});
}
}
catch
{
toReturn = false;
}
order = findOrd;
return(toReturn);
}
public bool GetCustomerById(int customerID, out Customer customer)
{
bool toReturn = false;
Customer findCust = null;
try
{
using (EntityModelConnectionSettings entitySettings = new EntityModelConnectionSettings())
{
entitySettings.Customers.ToList().ForEach(x => { if (x.ID == customerID)
{
findCust = x; toReturn = true;
}
});
}
}
catch
{
toReturn = false;
}
customer = findCust;
return(toReturn);
}
