/// <summary>
/// Empries the shopping cart of the user
/// </summary>
/// <param name="userID">users whoes shopping cart we are empting</param>
public void EmptyShoppingCart(int userID)
{
try
{
using (OrderDBEntities context = new OrderDBEntities())
{
int shoppingChartCount = GetAllUserShoppingCarts(userID).Count;
for (int i = 0; i < shoppingChartCount; i++)
{
tblShoppingCart shoppingCartToRemove = (from r in context.tblShoppingCarts
where r.UserID == userID
select r).First();
context.tblShoppingCarts.Remove(shoppingCartToRemove);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
/// <summary>
/// Gets all information about shopping carts from the user
/// </summary>
/// <returns>a list of found shopping carts</returns>
public List <tblShoppingCart> GetAllUserShoppingCarts(int UserID)
{
try
{
List <tblShoppingCart> list = new List <tblShoppingCart>();
using (OrderDBEntities context = new OrderDBEntities())
{
for (int i = 0; i < GetAllShoppingCarts().Count; i++)
{
if (GetAllShoppingCarts()[i].UserID == UserID)
{
list.Add(GetAllShoppingCarts()[i]);
}
}
return(list);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Gets all information about all non pending orders
/// </summary>
/// <returns>a list of found orders</returns>
public List <tblOrder> GetAllNonPendingOrders()
{
try
{
List <tblOrder> list = new List <tblOrder>();
using (OrderDBEntities context = new OrderDBEntities())
{
for (int i = 0; i < GetAllOrders().Count; i++)
{
if (GetAllOrders()[i].OrderStatus != "Waiting")
{
list.Add(GetAllOrders()[i]);
}
}
return(list);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Adds the order if the userID exists
/// </summary>
/// <param name="userID">oreder for the specific user</param>
/// <returns>a new order</returns>
public tblOrder AddOrder(int userID)
{
try
{
using (OrderDBEntities context = new OrderDBEntities())
{
double orderPrice = 0;
for (int i = 0; i < GetAllUserShoppingCarts(userID).Count; i++)
{
int index = GetAllItems().FindIndex(f => f.ItemID == GetAllUserShoppingCarts(userID)[i].ItemID);
double price = double.Parse(GetAllItems()[index].Price);
orderPrice = orderPrice + (double)GetAllUserShoppingCarts(userID)[i].Amount * price;
}
tblOrder newOrder = new tblOrder
{
TotalPrice = orderPrice.ToString(),
OrderStatus = "Waiting",
OrderCreated = DateTime.Now,
UserID = userID
};
context.tblOrders.Add(newOrder);
EmptyShoppingCart(userID);
context.SaveChanges();
return(newOrder);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public IQueryable <tbl_Orders> GetAllProductDetails()
{
OrderDBEntities orderDBEntities = new OrderDBEntities();
return(orderDBEntities.tbl_Orders);
}
public IQueryable <tbl_Product> GetAllProductDetails(int id)
{
OrderDBEntities orderDBEntities = new OrderDBEntities();
return(orderDBEntities.tbl_Product.Where(c => c.OrderitemID == id).Select(e => e));
}
public DataOrder()
{
Db = new OrderDBEntities();
}
public DataProduct()
{
Db = new OrderDBEntities();
}
public DataClient()
{
Db = new OrderDBEntities();
}
public CustomerController()
{
context = new OrderDBEntities();
}
public PerformerController()
{
context = new OrderDBEntities();
}
public CatalogController()
{
context = new OrderDBEntities();
}
public DataCategory()
{
Db = new OrderDBEntities();
}
public ProductdetailsModel Create(OrderDBEntities orderDBEntities)
{
return(new ProductdetailsModel()
{
});
}
public CustomersController()
{
_context = new OrderDBEntities();
}
