public static dynamic TraerPelicula(int IdPelicula) { myContext ctx = new myContext(); var Pelicula = ctx.Peliculas.Where(x => x.IdPelicula == IdPelicula); return(Pelicula); }
// GET: Supplier public ActionResult Index() { using (myContext connection = new myContext()) { return(View(connection.Suppliers.ToList())); } }
public static List <CookingInstruction> GetAllCookInst() { using (myContext db1 = new myContext()) { return(db1.CookingInstructions.ToList()); } }
public ActionResult FinalizarReserva() { if (Request["Sede"] == "0" || Request["Version"] == "0" || Request["Horario"] == "0" || Request["Dia"] == "0" || Request["Sede"] == "" || Request["Version"] == "" || Request["Horario"] == "" || Request["Dia"] == "") { TempData["IdPelicula"] = Request["Pelicula"]; return(RedirectToAction("Reserva")); } else { myContext ctx = new myContext(); int IdPelicula, IdSede, IdVersion; Int32.TryParse(Request["Pelicula"], out IdPelicula); Int32.TryParse(Request["Sede"], out IdSede); Int32.TryParse(Request["Version"], out IdVersion); var a = ctx.Carteleras.Where(x => x.IdPelicula == IdPelicula && x.IdSede == IdSede && x.IdVersion == IdVersion).First(); ViewBag.ImagenPelicula = ctx.Peliculas.Where(x => x.IdPelicula == IdPelicula).FirstOrDefault().Imagen; ViewBag.TiposDocumentos = PeliculaServicio.TraeTiposDeDocumentos(); CarteleraReserva cr = new CarteleraReserva(); cr.IdPelicula = a.IdPelicula; cr.IdSede = a.IdSede; cr.NumeroSala = a.NumeroSala; cr.IdVersion = a.IdVersion; cr.Peliculas = a.Peliculas; cr.Sedes = a.Sedes; cr.Versiones = a.Versiones; cr.Horario = Request["Horario"]; cr.Dia = Request["Dia"]; return(View(cr)); } }
public static List <Discount> GetAllDiscounts() { using (myContext db1 = new myContext()) { return(db1.Discounts.ToList()); } }
public static Usuarios IniciarSesion(Usuarios us) { cnt = new myContext(); var existeUsuario = cnt.Usuarios.Where(x => x.NombreUsuario == us.NombreUsuario && x.Password == us.Password).FirstOrDefault(); return(existeUsuario); }
public static dynamic TraeTiposDeDocumentos() { myContext ctx = new myContext(); var tiposDoc = ctx.TiposDocumentos; return(tiposDoc); }
public ActionResult ListaReportes(Reporte reporte) { myContext ctx = new myContext(); if (ModelState.IsValid) { int IdPelicula; Int32.TryParse(Request["Pelicula"], out IdPelicula); var a = ctx.Reservas.Where(x => x.IdPelicula == IdPelicula && x.FechaCarga >= reporte.FechaInicio && x.FechaCarga <= reporte.FechaFin); return(View(a)); } IEnumerable <SelectListItem> ReportesItems = ctx.Peliculas.AsEnumerable().Select(c => new SelectListItem() { Text = c.Nombre, Value = c.IdPelicula.ToString(), Selected = true, }); SelectList Peliculas = new SelectList(ReportesItems, "Value", "Text"); ViewData["Pelicula"] = Peliculas; return(View("Reportes")); }
private void EFbuttonAdd_Click(object sender, EventArgs e) { // Add new Blog entry to Blogs table try { using var dbContext = new myContext(); var newBlog = new Blog() { Title = "from EF", CreatedAt = DateTime.Now, Subtitle = "SubFromEF" // Note : There is an issue with EF with this subtitle field // Although this field IS marked as 'allow nulls' in the sql server, the EF doesn't work if it is null // It is NOT a profiler issue, it is some issue with the EF core // See: https://stackoverflow.com/a/55889874/5737562 }; dbContext.Blogs.Add(newBlog); dbContext.SaveChanges(); var lastBlogId = newBlog.Id; Console.WriteLine($"Added Blog: Blog with id {lastBlogId} was added"); } catch (Exception ex) { Console.WriteLine(ex); } }
//Listado de peliculas public ActionResult Peliculas() { myContext ctx = new myContext(); var a = (ctx.Peliculas).ToList();//(from peliculas in ctx.Peliculas select peliculas).ToList(); return(View(a)); }
protected override void OnCreate(Bundle bundle) { TabLayoutResource = Resource.Layout.Tabbar; ToolbarResource = Resource.Layout.Toolbar; base.OnCreate(bundle); global::Xamarin.Forms.Forms.Init(this, bundle); var dbFolder = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); var fileName = "Cats.db"; var dbFullPath = Path.Combine(dbFolder, fileName); try { using (var db = new myContext(dbFullPath)) { db.Database.Migrate(); } } catch (Exception ex) { } LoadApplication(new App()); }
//Listado de Sedes public ActionResult Sedes() { myContext ctx = new myContext(); var a = (ctx.Sedes).ToList(); return(View(a)); }
// GET: Peliculas public ActionResult Reserva(int idPelicula = -1) { ViewData["error"] = null; if (TempData["IdPelicula"] != null) { ViewData["error"] = "Por favor, no deje ningun campo vacio"; string temp = (string)TempData["IdPelicula"]; int IdPelicula2; Int32.TryParse(temp, out IdPelicula2); idPelicula = IdPelicula2; } myContext ctx = new myContext(); var Pelicula = PeliculaServicio.TraerPelicula(idPelicula); SelectList Versiones = PeliculaServicio.MostrarVersionCascada(idPelicula); ViewData["version"] = Versiones; return(View(Pelicula)); }
public ActionResult ConfirmarReserva(CarteleraReserva cr) { myContext ctx = new myContext(); if (ModelState.IsValid) { Reservas reserva = new Reservas(); string HoraInicio = cr.Horario.ToString(); int sitioDeCorte = 2; string parte1 = HoraInicio.Substring(0, sitioDeCorte); string parte2 = HoraInicio.Substring(3, sitioDeCorte); int HoraInicioParte1, HoraInicioParte2; Int32.TryParse(parte1, out HoraInicioParte1); Int32.TryParse(parte2, out HoraInicioParte2); DateTime Hora = DateTime.Today; Hora = Hora.AddHours(HoraInicioParte1); Hora = Hora.AddMinutes(HoraInicioParte2); reserva.IdPelicula = cr.IdPelicula; reserva.IdVersion = cr.IdVersion; reserva.IdSede = cr.IdSede; reserva.FechaHoraInicio = Hora; reserva.FechaCarga = DateTime.Now; reserva.Email = cr.Email; reserva.IdTipoDocumento = cr.IdTipoDocumento; reserva.NumeroDocumento = cr.NumeroDocumento; reserva.CantidadEntradas = cr.CantidadEntradas; ctx.Reservas.Add(reserva); ctx.SaveChanges(); cr.IdReserva = reserva.IdReserva; var sede = ctx.Sedes.Where(x => x.IdSede == cr.IdSede).FirstOrDefault(); ViewBag.PrecioTotal = cr.CantidadEntradas * sede.PrecioGeneral; return(View(cr)); } var a = ctx.Carteleras.Where(x => x.IdPelicula == cr.IdPelicula && x.IdSede == cr.IdSede && x.IdVersion == cr.IdVersion).First(); ViewBag.ImagenPelicula = ctx.Peliculas.Where(x => x.IdPelicula == cr.IdPelicula).FirstOrDefault().Imagen; ViewBag.TiposDocumentos = PeliculaServicio.TraeTiposDeDocumentos(); cr.IdPelicula = a.IdPelicula; cr.IdSede = a.IdSede; cr.NumeroSala = a.NumeroSala; cr.IdVersion = a.IdVersion; cr.Peliculas = a.Peliculas; cr.Sedes = a.Sedes; cr.Versiones = a.Versiones; cr.Horario = cr.Horario; cr.Dia = cr.Dia; return(View("FinalizarReserva", cr)); }
public static int GetUnAssignedDeliveriesCount() { using (myContext db1 = new myContext()) { var count = db1.DeliveriestoDespatch.Where(m => m.AssignedDriverId == 0).ToList().Count; return(count); } }
public static Order GetOrder(int OrderId) { using (myContext db1 = new myContext()) { var Order = db1.Orders.FirstOrDefault(order => order.OrderId == OrderId); return(Order); } }
public static Customer FindCustomerById(int Id) { using (myContext db = new myContext()) { var customer = db.Customers.FirstOrDefault(m => m.Id == Id); return(customer); } }
public static List <Staff> GetAllDriversFromStatff() { using (myContext db1 = new myContext()) { var drivers = db1.Staff.Where(m => m.Driver == true).ToList(); return(drivers); } }
public static List <DeliverytoDespatch> GetUnAssignedDeliveries() { using (myContext db1 = new myContext()) { var deliveries = db1.DeliveriestoDespatch.Where(m => m.AssignedDriverId == 0).ToList(); return(deliveries); } }
public static int GetCollectionCount() { using (myContext db1 = new myContext()) { var count = db1.AwaitOrders.ToList().Count; return(count); } }
public static List <AwaitOrder> GetCollectionOrders() { using (myContext db1 = new myContext()) { var orders = db1.AwaitOrders.ToList(); return(orders); } }
public static Customer FindCustomerByPhone(string type, string value) { using (myContext db = new myContext()) { var customer = db.Customers.FirstOrDefault(m => m.Phone == value); return(customer); } }
public static List <Order> GetAllOrdersDesc() { using (myContext db1 = new myContext()) { var Orders = db1.Orders.OrderByDescending(m => m.OrderId).ToList(); return(Orders); } }
public static dynamic CarteleraActual() { myContext ctx = new myContext(); DateTime todaysDate = DateTime.Now; var a = ctx.Carteleras.Where(cartelera => cartelera.FechaFin >= todaysDate && cartelera.FechaInicio < todaysDate).GroupBy(x => x.IdPelicula).Select(group => group.FirstOrDefault()); return(a); }
public static CookingInstruction AddCookInstr(CookingInstruction instr) { using (myContext db1 = new myContext()) { var newItem = db1.CookingInstructions.Add(instr); db1.SaveChanges(); return(newItem); } }
public UserRepository(IUnitOfWork unitOfWork) { if (unitOfWork == null) { throw new ArgumentNullException("unitOfWork"); } _context = unitOfWork as myContext; }
public static void RemoveCollectionOrder(int Id) { using (myContext db1 = new myContext()) { var order = db1.AwaitOrders.First(m => m.Id == Id); //db1.AwaitOrders.Remove(order); db1.Entry(order).State = EntityState.Deleted; db1.SaveChanges(); } }
public static dynamic CarteleraProximamente() { myContext ctx = new myContext(); DateTime todaysDate = DateTime.Now; DateTime OneMoreMonth = DateTime.Now.Date.AddMonths(1); var a = ctx.Carteleras.Where(cartelera => cartelera.FechaInicio > todaysDate && cartelera.FechaInicio < OneMoreMonth).GroupBy(x => x.IdPelicula).Select(group => group.FirstOrDefault()); return(a); }
//Redirecciona y envía model public ActionResult editarPelicula() { myContext ctx = new myContext(); var idPeli = Int32.Parse(Request.QueryString["id"]); var a = (from peli in ctx.Peliculas where peli.IdPelicula == idPeli select peli).FirstOrDefault(); ViewBag.Generos = AdministracionServicio.GetGeneros(); ViewBag.Calificaciones = AdministracionServicio.GetCalificaciones(); return(View(a)); }
//Accion para redireccionar a la vista para agragar una nueva pelicula public ActionResult AltaPelicula() { myContext ctx = new myContext(); var a = (ctx.Generos).ToList(); ViewBag.Generos = a; var b = (ctx.Calificaciones).ToList(); ViewBag.Calificaciones = b; return(View()); }