public void insert()
{
using (var db = new RentaCarContext())
{
db.NCF.Add(this);
db.SaveChanges();
}
}
public ActionResult GetInspeccion(int id)
{
using (RentaCarContext db = new RentaCarContext())
{
Inspeccion inspeccion = db.Inspecciones.Find(id);
return Json(inspeccion, JsonRequestBehavior.AllowGet);
}
}
private void Update()
{
using (var db = new RentaCarContext())
{
db.Entry(this).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Delete()
{
using (RentaCarContext db = new RentaCarContext())
{
db.Fotos.Remove(this);
db.SaveChanges();
}
}
public void Insert()
{
using (RentaCarContext db = new RentaCarContext())
{
db.Errores.Add(this);
db.SaveChanges();
}
}
public void Modificar()
{
using (var db = new RentaCarContext())
{
db.NCF.Attach(this);
db.Entry(this).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public static NCF GetOne()
{
using (var db = new RentaCarContext())
{
var n = db.NCF.Single(x => x.IdNCF == db.NCF.Where(d => d.Estado == "Pendiente").Min().IdNCF);
return n;
}
}
public static List<TipoFacturacion> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var all = (from b in db.TiposFacturacion
select b).ToList();
return all;
}
}
public static List<Color> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var colores = from b in db.Colores
select b;
return colores.ToList();
}
}
public static List<Municipio> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var tipoDocs = from b in db.Municipios
select b;
return tipoDocs.ToList();
}
}
public static List<TipoDocumento> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var tipoDocs = from b in db.TiposDocumentos
select b;
return tipoDocs.ToList();
}
}
public static List<Modelo> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var modelos = from b in db.Modelos
select b;
return modelos.ToList();
}
}
public static List<TipoSeguro> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var s = from b in db.TipoSeguro
select b;
return s.ToList();
}
}
public static List<Marca> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var marcas = from b in db.Marcas
select b;
return marcas.ToList();
}
}
public static List<Aseguradoras> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var s = from b in db.Aseguradoras
select b;
return s.ToList();
}
}
public static List<Provincia> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var tipoDocs = from b in db.Provincias
select b;
return tipoDocs.ToList();
}
}
public static List<ConceptoPago> GetAll()
{
using (RentaCarContext db = new RentaCarContext())
{
var ps = (from b in db.ConceptosPagos
select b).ToList();
return ps;
}
}
public static string GetSecuencia()
{
using (var db = new RentaCarContext())
{
var secuencia = db.SecuenciaFactura.Find(1);
int num =secuencia.Secuencia;
secuencia.Secuencia++;
secuencia.Update();
return num.ToString("0000");
}
}
public static List<Foto> GetAll(int id)
{
using (var db = new RentaCarContext())
{
var fs = (from b in db.Fotos
where b.IdVehiculo == id
select b).ToList();
foreach (var f in fs)
{
f.GetVirtualPath();
}
return fs;
}
}
public ActionResult GetInspeccionComentarios(int id)
{
using (RentaCarContext db = new RentaCarContext())
{
var coment = (from b in db.ComentariosInspecciones
where b.IdInspeccion == id
select b).ToList();
foreach (var c in coment)
{
c.GetUsuario();
}
return Json(coment, JsonRequestBehavior.AllowGet);
}
}
public static Cotizacion GetOne(int id)
{
using (RentaCarContext db = new RentaCarContext())
{
var a = db.Cotizaciones
.Include("TipoFacturacion")
.Single(x =>x.IdCotizacion == id);
a.Vehiculo = Vehiculo.GetOne(a.IdVehiculo);
a.cliente = Cliente.GetOne(a.IdCliente);
return a;
}
}
public void Update()
{
this.Provincia = null;
this.Municipio =null;
using (var db = new RentaCarContext())
{
db.Sucursales.Attach(this);
db.Entry(this).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public static List<Sucursal> GetAll()
{
using (var db = new RentaCarContext())
{
var all = (from b in db.Sucursales
select b).ToList();
foreach (var s in all)
{
s.GetProvincia();
}
return all;
}
}
public void GetTipoPago()
{
using (var db = new RentaCarContext())
{
this.TipoPago = db.TipoPagos.Find(this.IdTipoPago);
}
}
public static void Eliminar(int id)
{
using (RentaCarContext db = new RentaCarContext())
{
var f = db.Facturas.Find(id);
db.Facturas.Remove(f);
db.SaveChanges();
}
}
public void Update()
{
this.Vehiculo = null;
this.cliente = null;
using (RentaCarContext db = new RentaCarContext())
{
db.Cotizaciones.Attach(this);
db.Entry(this).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void GetConcepto()
{
using (var db = new RentaCarContext())
{
this.Concepto = db.ConceptosPagos.Find(this.IdConcepto);
}
}
public void GuardarCotizacion()
{
using (RentaCarContext db = new RentaCarContext())
{
db.Cotizaciones.Add(this);
db.SaveChanges();
}
}
internal static ICollection<Factura> GetByAlquiler(int p)
{
using (RentaCarContext db = new RentaCarContext())
{
var c = (from b in db.Facturas
where b.IdAlquiler == p
select b)
.OrderByDescending(x => x.IdAlquiler)
.ToList();
foreach (var co in c)
{
co.GetConcepto();
co.GetTipoPago();
}
return c;
}
}
public static List<Cotizacion> GetAll(int page, int? pagesize = null, int? idcotizacion = null,
DateTime? inicia = null, DateTime? termina = null, string cliente = null, string placa = null,
string matricula = null)
{
var cs = new List<Cotizacion>();
using (RentaCarContext db = new RentaCarContext())
{
SqlCommand cb = new SqlCommand("GetCotizaciones");
cb.Parameters.AddWithValue("@page", page);
cb.Parameters.AddWithValue("@pagesize", pagesize);
cb.Parameters.AddWithValue("@IdCotizacion", idcotizacion);
cb.Parameters.AddWithValue("@inicia", inicia);
cb.Parameters.AddWithValue("@cliente", cliente);
cb.Parameters.AddWithValue("@placa", placa);
cb.Parameters.AddWithValue("@matricula", matricula);
Cotizacion c;
foreach (DataRow r in db.get_tabla(cb).Rows)
{
c = new Cotizacion();
c.TotalRow = int.Parse(r["TotalRow"].ToString());
c.IdCotizacion = int.Parse(r["IdCotizacion"].ToString());
c.Fecha = DateTime.Parse(r["Fecha"].ToString());
c.cliente = new Cliente();
c.cliente.Nombre = r["nombre"].ToString();
c.Vehiculo = new Vehiculo();
c.Vehiculo.Placa = r["placa"].ToString();
c.Vehiculo.Matricula = r["Matricula"].ToString();
cs.Add(c);
}
return cs;
}
}
