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