public ActionResult Index() { var orders = db.Orders.ToList(); var fullOrders = new List <OrderDTO>(); foreach (var order in orders) { var fullOrder = new OrderDTO(order); var orderItems = new List <OrderItemDTO>(); using (CanteenContext ctx = new CanteenContext()) { var orderItemsFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == fullOrder.OrderId select o).ToList(); foreach (var i in orderItemsFull) { var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault(); var orderX = new OrderItemDTO(i); orderX.MenuItem = menuItem; if (menuItem != null) { orderItems.Add(orderX); } } } fullOrder.OrderItems = orderItems; if (fullOrder.OrderItems.Count() > 0) { fullOrders.Add(fullOrder); } } return(View(fullOrders)); }
// // GET: /Profile/Create private UserProfile _getCurrentUser() { var userprofile = new UserProfile(); using (CanteenContext ctx = new CanteenContext()) { userprofile = (from o in ctx.UserProfiles orderby o.UserId where o.UserName == User.Identity.Name select o).ToList().FirstOrDefault(); } return(userprofile); }
public ActionResult MyDetails() { var userprofile = new UserProfile(); using (CanteenContext ctx = new CanteenContext()) { userprofile = (from o in ctx.UserProfiles orderby o.UserId where o.UserName == User.Identity.Name select o).ToList().FirstOrDefault(); } if (userprofile == null) { return(HttpNotFound()); } return(View(userprofile)); }
// POST api/Default1 public HttpResponseMessage PostOrder(IList <CartItem> cartItems) { if (ModelState.IsValid) { var user = new UserProfile(); using (CanteenContext ctx = new CanteenContext()) { user = (from o in ctx.UserProfiles orderby o.UserId where o.UserName == User.Identity.Name select o).ToList().FirstOrDefault(); } db.Entry(user).State = EntityState.Unchanged; var order = new Order() { DateConfirmed = DateTime.Now, DateCreated = DateTime.Now, DateDelivered = DateTime.Now, IsConfirmed = false, IsDelivered = false, User = user }; db.Orders.Add(order); db.SaveChanges(); foreach (var i in cartItems) { var orderItem = new OrderItem() { MenuItemId = i.Id, OrderId = order.OrderId, Quantity = i.Quantity }; db.OrderItems.Add(orderItem); } db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, cartItems); return(response); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public ActionResult IndexCustomer() { var users = new List <UserProfile>(); var usersDTO = new List <UserProfileDTO>(); using (CanteenContext ctx = new CanteenContext()) { var usernames = Roles.GetUsersInRole("Client"); foreach (var user in usernames) { var userprofile = (from o in ctx.UserProfiles where o.UserName == user select o).ToList().FirstOrDefault(); if (userprofile != null) { usersDTO.Add(new UserProfileDTO(userprofile)); } } } return(View("Index", usersDTO)); }
public ActionResult IndexCustomer() { var user = new UserProfile(); using (CanteenContext ctx = new CanteenContext()) { user = (from o in ctx.UserProfiles orderby o.UserId where o.UserName == User.Identity.Name select o).ToList().FirstOrDefault(); } var orders = new List <Order>(); using (CanteenContext ctx = new CanteenContext()) { orders = (from o in ctx.Orders.Include("User") orderby o.OrderId where o.User.UserId == user.UserId select o).ToList(); } var fullOrders = new List <OrderDTO>(); foreach (var order in orders) { var fullOrder = new OrderDTO(order); var orderItems = new List <OrderItemDTO>(); using (CanteenContext ctx = new CanteenContext()) { var orderItemsFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == fullOrder.OrderId select o).ToList(); foreach (var i in orderItemsFull) { var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault(); var orderX = new OrderItemDTO(i); orderX.MenuItem = menuItem; if (menuItem != null) { orderItems.Add(orderX); } } } fullOrder.OrderItems = orderItems; if (fullOrder.OrderItems.Count() > 0) { fullOrders.Add(fullOrder); } } return(View(fullOrders)); }
public ActionResult EditEmployee(int id = 0) { Order order = db.Orders.Find(id); if (order == null) { return(HttpNotFound()); } var fullOrder = new OrderDTO(order); var orderItems = new List <OrderItemDTO>(); var orderItemsSorted = new List <OrderItemDTO>(); using (CanteenContext ctx = new CanteenContext()) { var orderItemsFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == fullOrder.OrderId select o).ToList(); foreach (var i in orderItemsFull) { var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault(); var orderX = new OrderItemDTO(i); orderX.MenuItem = menuItem; if (menuItem != null) { orderItems.Add(orderX); } } } if (orderItems.Count > 0) { fullOrder.OrderItems = orderItems.OrderBy(o => o.MenuItemId).ToList(); } return(View(fullOrder)); /* orig * Order order = db.Orders.Find(id); * if (order == null) * { * return HttpNotFound(); * } * * return View(order);*/ }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return(RedirectToAction("Manage")); } if (ModelState.IsValid) { // Insert a new user into the database using (CanteenContext db = new CanteenContext()) { UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower()); // Check if user already exists if (user == null) { // Insert name into the profile table db.UserProfiles.Add(new UserProfile { UserName = model.UserName }); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); return(RedirectToLocal(returnUrl)); } else { ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name."); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return(View(model)); }
public ActionResult IndexEmployee() { var orders = new List <Order>(); var fullOrders = new List <OrderDTO>(); using (CanteenContext ctx = new CanteenContext()) { orders = (from o in ctx.Orders.Include("User") orderby o.OrderId where o.IsDelivered == false && o.User.Blocked == false select o).ToList(); } foreach (var order in orders) { var fullOrder = new OrderDTO(order); var orderItems = new List <OrderItemDTO>(); if (order.User != null) { fullOrders.Add(fullOrder); } } return(View("IndexEmployee", fullOrders)); }
public SimpleMembershipInitializer() { Database.SetInitializer <CanteenContext>(null); try { using (var context = new CanteenContext()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema ((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); } } WebSecurity.InitializeDatabaseConnection("CanteenConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true); } catch (Exception ex) { throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex); } }
public ActionResult Login(LoginModel model, string returnUrl) { var userprofile = new UserProfile(); using (CanteenContext ctx = new CanteenContext()) { userprofile = (from o in ctx.UserProfiles orderby o.UserId where o.UserName == model.UserName && o.Blocked == false select o).ToList().FirstOrDefault(); } if (userprofile == null) { ModelState.AddModelError("", "You have been blocked."); } else { if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe)) { return(RedirectToLocal(returnUrl)); } // If we got this far, something failed, redisplay form ModelState.AddModelError("", "The user name or password provided is incorrect."); } return(View(model)); }
public ContainerRepository(CanteenContext context) { _context = context; }
public ProductRepository(CanteenContext dbContext) : base(dbContext) { _products = dbContext.Products; // or dbContext.Set<Product>() }
public OperationRepository(CanteenContext context) { _context = context; }
// // GET: /Statistics/ public ActionResult Index() { Statistics statistics = new Statistics(); var today = new DateTime(); //var dayOrders = new List<Order>(); //var monthOrders = new List<Order>(); //var fullOrderDay = new List<OrderDTO>(); //var fullOrderMonth = new List<OrderDTO>(); using (CanteenContext ctx = new CanteenContext()) { statistics.TotalNumberOfUsers = (from o in ctx.UserProfiles select o).Count(); statistics.TotalNumberOfOrders = (from o in ctx.OrderItems select o).Count(); statistics.TotalSalesToday = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Day == today.Day select o).Count(); statistics.TotalSalesThisMonth = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Month == today.Month select o).Count(); var dayOrders = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Day == today.Day select o).ToList(); var monthOrders = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Month == today.Month select o).ToList(); var orderItemsDay = new List <OrderItemDTO>(); var orderItemsMonth = new List <OrderItemDTO>(); var orderItemsDayFull = new List <OrderItem>(); var orderItemsMonthFull = new List <OrderItem>(); var fullOrderDay = new List <OrderDTO>(); var fullOrderMonth = new List <OrderDTO>(); foreach (var i in dayOrders) { fullOrderDay.Add(new OrderDTO(i)); } foreach (var i in monthOrders) { fullOrderMonth.Add(new OrderDTO(i)); } foreach (var i in fullOrderDay) { orderItemsDayFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == i.OrderId select o).ToList(); } foreach (var i in fullOrderMonth) { orderItemsMonthFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == i.OrderId select o).ToList(); } foreach (var i in orderItemsDayFull) { var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault(); var orderX = new OrderItemDTO(i); orderX.MenuItem = menuItem; if (menuItem != null) { orderItemsDay.Add(orderX); } } foreach (var i in orderItemsMonthFull) { var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault(); var orderX = new OrderItemDTO(i); orderX.MenuItem = menuItem; if (menuItem != null) { orderItemsMonth.Add(orderX); } } if (orderItemsDay.Count > 0) { foreach (var i in orderItemsDay) { } } //db.Statistics.Add(statistics); //db.SaveChanges(); } return(View("Details", statistics)); }
public ProductRepository(CanteenContext context) : base(context) { }
public GenericRepository(CanteenContext context) { _context = context; }
public Repository(CanteenContext context) { Context = context; }
public EntityRepository(CanteenContext db) { _db = db; }