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