public ActionResult QR(int id) { BodyShopFlowEntities contexto = new BodyShopFlowEntities(); Models.OrdenModel ordens = (from e in contexto.orden where e.idOrden == id select new Models.OrdenModel { idOrden = e.idOrden, referenciaInterna = e.referenciaInterna, fechaRegistro = e.fechaRegistro, adicional1 = e.adicional1, adicional2 = e.adicional2, md5orden = e.md5Orden, usuarioCierre = e.usuarioCierre, fechaCierre = e.fechaCierre, idVehiculo = e.idVehiculo, activo = e.activo }).FirstOrDefault(); QRCodeGenerator qrGenerator = new QRCodeGenerator(); QRCodeData qrCodeData = qrGenerator.CreateQrCode(ordens.md5orden, QRCodeGenerator.ECCLevel.Q); QRCode qrCode = new QRCode(qrCodeData); Bitmap qrCodeImage = qrCode.GetGraphic(20); return(View(BitmapToBytes(qrCodeImage))); }
public ActionResult CerrarOrden(int id) { BodyShopFlowEntities contexto = new BodyShopFlowEntities(); orden ordens = (from a in contexto.orden where a.idOrden == id select a).FirstOrDefault(); string user = Session["Iduser"].ToString(); ordens.usuarioCierre = user; ordens.fechaCierre = DateTime.Now; contexto.SaveChanges(); return(RedirectToAction("Index")); }
public static List <Models.VehiculoModel> LlenarDrp() { BodyShopFlowEntities contexto = new BodyShopFlowEntities(); List <Models.VehiculoModel> lista = (from e in contexto.vehiculo select new Models.VehiculoModel { idVehiculo = e.idVehiculo, Placa = e.placa }).ToList(); return(lista); }