public DomOrder GetMostRecentOrder(DomUser u) { Order order = _db.Order.Where <Order>(o => o.Username == u.Username).OrderByDescending(o => o.OrderDate).FirstOrDefault(); if (order == null) { return(null); } return(DataDomainMapper.Order2DomOrder(order)); }
public DomOrder GetActiveOrder(string Username) { IQueryable <Order> oquery = _db.Order.Where <Order>(o => o.Username == Username && ((int)o.OrderStatus < 4)); if (oquery.FirstOrDefault() == null) { return(null); } return(DataDomainMapper.Order2DomOrder(oquery.FirstOrDefault())); }
public List <DomOrder> GetUserOrderList(DomUser u) { List <Order> orderList = _db.Order.Where <Order>(o => o.Username == u.Username).ToList(); List <DomOrder> outList = new List <DomOrder>(); foreach (var o in orderList) { outList.Add(DataDomainMapper.Order2DomOrder(o)); } return(outList); }
public List <DomOrder> GetAllOrders(int LocationId) { List <Order> orders = _db.Order.Where <Order>(o => o.LocationId == LocationId && o.OrderStatus != 5).ToList(); if (orders == null) { return(null); } List <DomOrder> outOrders = new List <DomOrder>(); foreach (var o in orders) { outOrders.Add(DataDomainMapper.Order2DomOrder(o)); } return(outOrders); }