//sort orders by date
public List <OrderManagement.DAL.OrdersTable> GetOrdersByDate(String date)
{
using (OrderManagementDBEntities ct = new OrderManagementDBEntities())
{
List <OrderManagement.DAL.OrdersTable> orders = new List <OrderManagement.DAL.OrdersTable>();
foreach (var c in ct.OrdersTable)
{
OrderManagement.DAL.OrdersTable order = new OrderManagement.DAL.OrdersTable()
{
OrderNumber = c.OrderNumber,
OrderDate = c.OrderDate,
DeliveryAddress = c.DeliveryAddress,
OrderStatus = c.OrderStatus,
Total = c.Total
};
orders.Add(order);
}
if (date == "Ascending")
{
orders.Sort((x, y) => DateTime.Compare(x.OrderDate, y.OrderDate));
}
else if (date == "Descending")
{
orders.Sort((x, y) => DateTime.Compare(y.OrderDate, x.OrderDate));
}
return(orders);
}
}
//edits order in database
public void EditOrder(OrderManagement.DAL.OrdersTable order)
{
using (OrderManagementDBEntities ct = new OrderManagementDBEntities())
{
ct.Entry(order).State = System.Data.EntityState.Modified;
ct.SaveChanges();
}
}
//adds order to teh database
public void AddOrder(OrderManagement.DAL.OrdersTable order)
{
using (OrderManagementDBEntities ct = new OrderManagementDBEntities())
{
ct.OrdersTable.Add(order);
ct.SaveChanges();
}
}
//deletes order from database
public void DeleteOrder(OrderManagement.DAL.OrdersTable order)
{
using (OrderManagementDBEntities ct = new OrderManagementDBEntities())
{
OrdersTable or = ct.OrdersTable.First(t => t.OrderNumber == order.OrderNumber);
//OrdersTable ord = new OrdersTable() { OrderNumber = order.OrderNumber };
ct.Entry(or).State = System.Data.EntityState.Deleted;
ct.SaveChanges();
}
}
//gets processed orders between indicated dates min and max
public List <OrderManagement.DAL.OrdersTable> GetProcessedOrders(DateTime min, DateTime max)
{
using (OrderManagementDBEntities ct = new OrderManagementDBEntities())
{
List <OrderManagement.DAL.OrdersTable> orders = new List <OrderManagement.DAL.OrdersTable>();
foreach (var c in ct.OrdersTable.Where(c => c.OrderDate >= min && c.OrderDate <= max && c.OrderStatus == "Processed"))
{
OrderManagement.DAL.OrdersTable order = new OrderManagement.DAL.OrdersTable()
{
OrderNumber = c.OrderNumber,
OrderDate = c.OrderDate,
DeliveryAddress = c.DeliveryAddress,
OrderStatus = c.OrderStatus,
Total = c.Total
};
orders.Add(order);
}
return(orders);
}
}
//get orders from database by order status
public List <OrderManagement.DAL.OrdersTable> GetOrders(String s)
{
using (OrderManagementDBEntities ct = new OrderManagementDBEntities())
{
List <OrderManagement.DAL.OrdersTable> orders = new List <OrderManagement.DAL.OrdersTable>();
foreach (var c in ct.OrdersTable.Where(c => c.OrderStatus == s))
{
OrderManagement.DAL.OrdersTable order = new OrderManagement.DAL.OrdersTable()
{
OrderNumber = c.OrderNumber,
OrderDate = c.OrderDate,
DeliveryAddress = c.DeliveryAddress,
OrderStatus = c.OrderStatus,
Total = c.Total
};
orders.Add(order);
}
return(orders);
}
}