public IList <T> GetAll(params Expression <Func <T, object> >[] navigationProperties) { IQueryable <T> dbQuery = _context.Set <T>(); foreach (Expression <Func <T, object> > property in navigationProperties) { dbQuery = dbQuery.Include <T, object>(property); } return(dbQuery.ToList()); }
public void test() { OrderManagementContext context = new OrderManagementContext(); IEnumerable <OM_DepartmentDto> test1 = context.Set <OM_Permission>().Where(p => p.ID > 0).Select(p => Mapper.Map <OM_Permission, OM_DepartmentDto>(p)); OM_Permission permission = new OM_Permission(); OM_DepartmentDto test = Mapper.Map <OM_Permission, OM_DepartmentDto>(permission); }
public bool BookYourTable(TblTableOrder tblTableOrder) { int?paymentId = null; if (tblTableOrder != null) { tblTableOrder.TblOrderStatusId = 1; tblTableOrder.TblPaymentTypeId = 4; tblTableOrder.UserCreated = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1; tblTableOrder.UserModified = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1; tblTableOrder.ToDate = tblTableOrder.FromDate; _orderManagementContext.Set <TblTableOrder>().Add(tblTableOrder); _orderManagementContext.SaveChanges(); return(true); } return(false); }
public int AddCart(TblCart tblcart) { if (tblcart != null) { List <TblCart> cart = _context.TblCart.Where(ca => ca.TblCustomerID == tblcart.TblCustomerID).ToList <TblCart>(); if (cart.Count() > 0) { foreach (var item in cart) { if (tblcart.TblRestaurantID != item.TblRestaurantID) { _context.TblCart.RemoveRange(_context.TblCart.Where(c => c.TblCustomerID == tblcart.TblCustomerID)); tblcart.status = true; tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; _context.Set <TblCart>().Add(tblcart); _context.SaveChanges(); return(1); } if (tblcart.TblMenuID == item.TblMenuID) { item.TblCustomerID = tblcart.TblCustomerID; item.TblRestaurantID = tblcart.TblRestaurantID; item.TblMenuID = tblcart.TblMenuID; item.Price = tblcart.Price; item.Quantity = tblcart.Quantity; item.status = tblcart.status; item.RecordTimeStampCreated = DateTime.Now; item.offer = tblcart.offer; item.RecordTimeStamp = DateTime.Now; _context.SaveChanges(); return(1); } if (tblcart.TblRestaurantID == item.TblRestaurantID && tblcart.TblMenuID != item.TblMenuID) { tblcart.status = true; tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; _context.Set <TblCart>().Add(tblcart); _context.SaveChanges(); return(1); } } } else { tblcart.status = true; tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; _context.Set <TblCart>().Add(tblcart); _context.SaveChanges(); return(1); } //if (cart != null) //{ // if (cart.TblRestaurantID != tblcart.TblRestaurantID ) // { // _context.TblCart.RemoveRange(_context.TblCart.Where(c => c.TblCustomerID == tblcart.TblCustomerID)); // //List<TblCart> removecartlist = _context.TblCart.Where(d => d.TblCustomerID == tblcart.TblCustomerID).ToList<TblCart>(); // //_context.Remove(removecartlist); // //_context.SaveChanges(); // tblcart.status = true; // tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // _context.Set<TblCart>().Add(tblcart); // _context.SaveChanges(); // return 1; // } // else if (cart.TblRestaurantID == tblcart.TblRestaurantID && cart.TblMenuID == tblcart.TblMenuID) // { // cart.TblCustomerID = tblcart.TblCustomerID; // cart.TblRestaurantID = tblcart.TblRestaurantID; // cart.TblMenuID = tblcart.TblMenuID; // cart.Price = tblcart.Price; // cart.Quantity = tblcart.Quantity; // cart.status = tblcart.status; // cart.RecordTimeStampCreated = DateTime.Now; // cart.offer = tblcart.offer; // cart.RecordTimeStamp = DateTime.Now; // _context.SaveChanges(); // return 1; // } // else // { // tblcart.status = true; // tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // _context.Set<TblCart>().Add(tblcart); // _context.SaveChanges(); // return 1; // } //} //else //{ // tblcart.status = true; // tblcart.UserCreated = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // tblcart.UserModified = tblcart.TblCustomerID.HasValue ? tblcart.TblCustomerID.Value : 1; // _context.Set<TblCart>().Add(tblcart); // _context.SaveChanges(); // return 1; //} } return(0); }
public virtual IEnumerable <T> GetAll() { return(_context.Set <T>().ToList()); }