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());
}
