public Pais Get(int idPais) { using (PaisesEntities paisesentities = new PaisesEntities()) { return(paisesentities.Pais.FirstOrDefault(e => e.codPais == idPais)); } }
public ActionResult Login(AccountSessionViewModel obj) { var db = new PaisesEntities(); var usuario = new Usuario(); var response = default(ActionResult); try { usuario = db.Usuario.Where(x => x.username == obj.username && x.password == obj.password).FirstOrDefault(); if (usuario == null) { response = View(obj); } else { SessionPersister.usuario = usuario; response = RedirectToAction("Index", "Home"); } } catch { response = View(obj); } return(response); }
public IEnumerable <Pais> Get() { using (PaisesEntities paisesentities = new PaisesEntities()) { return(paisesentities.Pais.ToList()); } }
public List <SelectPaises> Fill(String name_pais) { var db = new PaisesEntities(); _paises = (db.Pais.Where(x => x.nombre.Contains(name_pais)).ToList()).Select(x => new SelectPaises(x.id, x.nombre)).ToList(); return(_paises); }
public void Fill(Int32 page, Int32 itemsPerPage, String status = null, String role = null) { var db = new PaisesEntities(); this.QueryStringValues = new RouteValueDictionary(); var predicate = PredicateBuilder.True <Usuario>(); if (!String.IsNullOrEmpty(role)) { predicate = predicate.And(c => c.role == role); this.status = status; } if (!String.IsNullOrEmpty(status)) { predicate = predicate.And(c => c.status == status); this.role = role; } this.usuarios = db.Usuario.Where(predicate) .OrderBy(x => x.id) .Skip((page - 1) * itemsPerPage) .Take(itemsPerPage) .ToList().AsQueryable(); this.totalItems = db.Usuario.Where(predicate).Count(); this.actualPage = page; this.itemsPerPage = itemsPerPage; this.QueryStringValues["status"] = status; this.QueryStringValues["role"] = role; }
public IQueryable <SelectCiudades> Fill(Int32 paisId) { var db = new PaisesEntities(); ciudades = (db.Provincia.Where(x => x.paisId == paisId).ToList()) .Select(x => new SelectCiudades(x.id, x.nombre)).ToList().AsQueryable(); return(ciudades); }
public JsonResult deleteUser(Int32 id) { var db = new PaisesEntities(); var response = new Response(); try { Usuario usuario = db.Usuario.Find(id); usuario.status = "INACTIVO"; db.SaveChanges(); response.ok = true; response.message = "Se eliminó con éxito"; } catch { response.ok = false; response.message = "Ocurrió un problema"; } return(Json(response, JsonRequestBehavior.AllowGet)); }
public static Resultado Getcountries() { try { var query = new DPaises().Getcountries(); List <PaisesEntities> PaisesList = new List <PaisesEntities>(); foreach (var item in query) { PaisesEntities pais = new PaisesEntities { id_Pais = item.id_Pais, descripcion = item.descripcion, nombre = item.nombre, ruta_logo = item.ruta_logo, deal = item.deal_Pais.ToString() }; PaisesList.Add(pais); } if (PaisesList.Count > 0) { return(new Resultado() { Respuesta = 1, Mensaje = "Paises Encontrados", Valores = PaisesList }); } else { return(new Resultado() { Respuesta = 0, Mensaje = "No se encontraron Paises ", Valores = null }); } } catch (Exception ex) { throw ex; } }
public Usuario findUser(String username) { var db = new PaisesEntities(); return(db.Usuario.Where(x => x.username == username).FirstOrDefault()); }
public ListCiudadesViewModel() { var db = new PaisesEntities(); paises = (db.Pais.ToList()).Select(x => new SelectPaises(x.id, x.nombre)).ToList().AsQueryable(); }
public ListUsuarioViewModel() { var db = new PaisesEntities(); usuarios = db.Usuario.ToList().AsQueryable(); }