public List <Users> GetActiveUsers()
{
using (AmericaVirtualEntities context = new AmericaVirtualEntities())
{
return(context.Users.Where(x => x.Active == 1).ToList());
}
}
public List <Countries> GetActiveCountries()
{
using (AmericaVirtualEntities context = new AmericaVirtualEntities())
{
return(context.Countries.Where(x => x.Active == 1).ToList());
}
}
public List <WeatherConditions> GetWeatherConditionsByCity(int idCity, int partFromToday)
{
using (AmericaVirtualEntities context = new AmericaVirtualEntities())
{
return(context.WeatherConditions.Include("Days").Include("Weathers").Where(x => x.IdCity == idCity && x.IdDay >= partFromToday).Take(5).ToList());
}
}
public List <Cities> GetActiveCitiesByCountry(int idCountry)
{
using (AmericaVirtualEntities context = new AmericaVirtualEntities())
{
return(context.Cities.Where(x => x.Active == 1 && x.Country == idCountry).ToList());
}
}
private Usuario GetUser(string username, string hash)
{
//consulto en la base de datos si el usuario y contraseña son correctos
Usuario entity;
using (AmericaVirtualEntities connection = new AmericaVirtualEntities())
{
entity = connection.Usuario.FirstOrDefault(x => x.Usuario1 == username && x.Password == hash);
}
return(entity);
}
protected virtual void Dispose(bool disposing)
{
if (!disposedValue)
{
if (disposing)
{
_context.Dispose();
}
_context = null;
disposedValue = true;
}
}
public void WriteInLog(LogType logType, string message, string username = null, string exception = null)
{
using (AmericaVirtualEntities context = new AmericaVirtualEntities())
{
Logs log = new Logs();
if (!string.IsNullOrEmpty(username))
{
log.Username = username;
}
log.LogType = logType.ToString();
log.Message = message;
if (!string.IsNullOrEmpty(exception))
{
log.Exception = exception;
}
context.Logs.Add(log);
context.SaveChanges();
}
}
public ApplicationFactory(AmericaVirtualEntities context)
{
_context = context;
}
public ApplicationFactory()
{
_context = new AmericaVirtualEntities();
}
