public ActionResult SelectDia(int?id) { var menus = new List <Menu>(); var lisCDias = new List <CDias>(); var HomeView = new HomeView(); DateTime Fecha = DateTime.Now.Date.Date; var listDias = db.Dias.ToList(); if (id != null) { var daymenu = db.DayMenu.Where(dm => dm.Cod_Dia == id).ToList(); foreach (var item in daymenu) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } } foreach (var item in listDias) { var Cdias = new CDias { Cantidad = db.DayMenu.Where(t => t.Cod_Dia == item.Cod_Dia).Count(), IdDia = item.Cod_Dia }; lisCDias.Add(Cdias); } ViewBag.SeleDia = id; HomeView.Menu = new Menu(); HomeView.Menus = menus; HomeView.Dias = listDias; HomeView.CantidadD = lisCDias; ViewBag.CMesas = CantidadMesas.CMesas(db); return(View("Index", HomeView)); }
public ActionResult Index() { var listDias = new List <Models.Dias>(); var HomeView = new HomeView(); using (var transacion = db.Database.BeginTransaction()) { try { string correo = WebConfigurationManager.AppSettings["mailAccount"]; var clientes = db.Clientes.ToList(); var cliente = clientes.Where(t => t.Correo_Cli == correo); var listaDT = db.TipoDocumentoes.ToList(); listDias = db.Dias.ToList(); if (listDias.Count() == 0 && cliente.Count() == 0 && listaDT.Count() == 0) { Cliente.idCliente(WebConfigurationManager.AppSettings["mailAccount"], "NRestaurante", "PRestaurante", "3177965608", db); ClasesUtil.Dias.listaDias(db); TipoDocumentos.ListaTD(db); listDias = db.Dias.ToList(); } var menus = new List <Menu>(); var lisCDias = new List <CDias>(); var Dia = DateTime.Now.DayOfWeek; switch (Dia) { case DayOfWeek.Sunday: var Sunday = db.DayMenu.Where(dm => dm.Cod_Dia == 7).ToList(); foreach (var item in Sunday) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } ViewBag.CMesas = CantidadMesas.CMesas(db); break; case DayOfWeek.Monday: var Monday = db.DayMenu.Where(dm => dm.Cod_Dia == 1).ToList(); foreach (var item in Monday) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } ViewBag.CMesas = CantidadMesas.CMesas(db); break; case DayOfWeek.Tuesday: var Tuesday = db.DayMenu.Where(dm => dm.Cod_Dia == 2).ToList(); foreach (var item in Tuesday) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } ViewBag.CMesas = CantidadMesas.CMesas(db); break; case DayOfWeek.Wednesday: var Wednesday = db.DayMenu.Where(dm => dm.Cod_Dia == 3).ToList(); ViewBag.CWednesday = db.DayMenu.Where(dm => dm.Cod_Dia == 3).Count(); ViewBag.Wednesday = "Miercoles"; foreach (var item in Wednesday) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } ViewBag.CMesas = CantidadMesas.CMesas(db); break; case DayOfWeek.Thursday: var Thursday = db.DayMenu.Where(dm => dm.Cod_Dia == 4).ToList(); foreach (var item in Thursday) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } ViewBag.CMesas = CantidadMesas.CMesas(db); break; case DayOfWeek.Friday: var Friday = db.DayMenu.Where(dm => dm.Cod_Dia == 5).ToList(); foreach (var item in Friday) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } ViewBag.CMesas = CantidadMesas.CMesas(db); break; case DayOfWeek.Saturday: var Saturday = db.DayMenu.Where(dm => dm.Cod_Dia == 6).ToList(); foreach (var item in Saturday) { var Menus = db.Menus.Find(item.Cod_Menu); menus.Add(Menus); } ViewBag.CMesas = CantidadMesas.CMesas(db); break; default: break; } var listaD = db.Dias.ToList(); foreach (var item in listaD) { var Cdias = new CDias { Cantidad = db.DayMenu.Where(t => t.Cod_Dia == item.Cod_Dia).Count(), IdDia = item.Cod_Dia }; lisCDias.Add(Cdias); } HomeView.Menu = new Menu(); HomeView.Menus = menus; HomeView.Dias = listDias; HomeView.CantidadD = lisCDias; transacion.Commit(); } catch (Exception ex) { ModelState.AddModelError(string.Empty, ex.Message); transacion.Rollback(); } } return(View(HomeView)); }