public CVersionCarro RecuperarVersion(int id)
{
var context = HttpContext.RequestServices.GetService(typeof(riviera_businessContext)) as riviera_businessContext;
TbCarros carrito = context.TbCarros.Where(car => car.IdCarros == id).FirstOrDefault();
CVersionCarro cversion = context.CVersionCarro.Where(cver => cver.IdVersionCarro == carrito.IdVersion).FirstOrDefault();
carrito.IdVersionNavigation = null;
return(cversion);
}
public CVersionCarro RecuperarVersion(int id)
{
var context = HttpContext.RequestServices.GetService(typeof(riviera_businessContext)) as riviera_businessContext;
TbCarros carrito = context.TbCarros.Where(car => car.IdCarros == id).FirstOrDefault();
CVersionCarro cversion = context.CVersionCarro.Where(cver => cver.IdVersionCarro == carrito.IdVersion).FirstOrDefault();
if (cversion != null)
{
cversion.TbCarros = null;
cversion.IdModeloNavigation = null;
cversion.CGuiaAutometricaEbc = null;
}
return(cversion);
}
public ActionResult Edit(int id, TbCarros a)
{
try
{
var context = HttpContext.RequestServices.GetService(typeof(riviera_businessContext)) as riviera_businessContext;
var objectEdit = context.TbCarros.FirstOrDefault(tc => tc.IdCarros == a.IdCarros);
if (objectEdit != null)
{
objectEdit.Modelo = a.Modelo;
objectEdit.Antiguedad = a.Antiguedad;
objectEdit.TipoCompraCanal = a.TipoCompraCanal;
objectEdit.ClaveVehicular = a.ClaveVehicular;
objectEdit.IdVersion = a.IdVersion;
objectEdit.ColorExt = a.ColorExt;
objectEdit.ColorInt = a.ColorInt;
objectEdit.DuenoAnterior = a.DuenoAnterior;
objectEdit.FechaFactToma = a.FechaFactToma;
objectEdit.FolioFiscal = a.FolioFiscal;
objectEdit.IdEstado = a.IdEstado;
objectEdit.Kms = a.Kms;
objectEdit.MvaOpc = a.MvaOpc;
objectEdit.NoMotor = a.NoMotor;
objectEdit.NoSerie = a.NoSerie;
objectEdit.NumEconomicoOpc = a.NumEconomicoOpc;
objectEdit.Origen = a.Origen;
objectEdit.PropuestaCliente = a.PropuestaCliente;
objectEdit.Transmision = a.Transmision;
objectEdit.IdProveedor = a.IdProveedor;
objectEdit.Ubicacion = a.Ubicacion;
objectEdit.FechaOferta = a.FechaOferta;
context.TbCarros.Update(objectEdit);
context.SaveChanges();
TbLineaTiempo linea = new TbLineaTiempo();
linea.IdCarro = a.IdCarros;
linea.Fecha = DateTime.Today;
linea.IdEstado = 15;
context.TbLineaTiempo.Add(linea);
context.SaveChanges();
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Delete(int id, TbCarros a)
{
try
{
var context = HttpContext.RequestServices.GetService(typeof(riviera_businessContext)) as riviera_businessContext;
TbCarros objectdel = a;
context.TbCarros.Remove(objectdel);
context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Create(TbCarros a)
{
try
{
var context = HttpContext.RequestServices.GetService(typeof(riviera_businessContext)) as riviera_businessContext;
a.IdEstado = 14;
context.TbCarros.Add(a);
/*
* T
*
* //Order by
* context.TbControl.OrderBy( x => x.IdCarros).Take(1);
* //Order by Descending
* context.TbControl.OrderByDescending(x => x.IdCarros).Take(10);*/
Console.WriteLine("Valor del id" + a.IdVersion);
Console.WriteLine("Aqui si entramos");
Console.WriteLine("Aqui si entramos" + a);
context.SaveChanges();
TbLineaTiempo linea = new TbLineaTiempo();
linea.IdCarro = a.IdCarros;
linea.Fecha = DateTime.Today;
linea.IdEstado = 14;
Console.WriteLine(linea);
context.TbLineaTiempo.Add(linea);
context.SaveChanges();
Console.WriteLine("Aqui no entramos ");
return(RedirectToAction(nameof(Index)));
}
catch (Exception e)
{
Console.WriteLine("Aqui si entramos" + e);
return(View(a));
}
}
public ActionResult Extras(ZMMVCarro copia)
{
try
{
var context = HttpContext.RequestServices.GetService(typeof(riviera_businessContext)) as riviera_businessContext;
TbCarros objectEdit = new TbCarros();
objectEdit.Modelo = copia.Modelo;
objectEdit.Antiguedad = copia.Antiguedad;
objectEdit.TipoCompraCanal = copia.TipoCompraCanal;
objectEdit.ClaveVehicular = copia.ClaveVehicular;
objectEdit.IdVersion = copia.IdVersion;
objectEdit.ColorExt = copia.ColorExt;
objectEdit.ColorInt = copia.ColorInt;
objectEdit.DuenoAnterior = copia.DuenoAnterior;
objectEdit.FechaFactToma = copia.FechaFactToma;
objectEdit.FolioFiscal = copia.FolioFiscal;
objectEdit.IdEstado = copia.IdEstado;
objectEdit.Kms = copia.Kms;
objectEdit.MvaOpc = copia.MvaOpc;
objectEdit.NoMotor = copia.NoMotor;
objectEdit.NoSerie = copia.NoSerie;
objectEdit.NumEconomicoOpc = copia.NumEconomicoOpc;
objectEdit.Origen = copia.Origen;
objectEdit.PropuestaCliente = copia.PropuestaCliente;
objectEdit.Transmision = copia.Transmicion;
objectEdit.IdProveedor = copia.IdProveedor;
objectEdit.Ubicacion = copia.Ubicacion;
objectEdit.FechaOferta = copia.FechaOferta;
/*------------------------------------------------------------*/
context.TbCarros.Add(objectEdit);
context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
catch (Exception e)
{
Console.WriteLine(e);
return(View(copia));
}
}
