public string AddModWeather(Weather model, string delete = "0")
{
try
{
var db = new AmericaVirtualContext();
if (delete != "0")
{
var modDel = db.Weather.Where(x => x.Id == model.Id).FirstOrDefault();
db.Weather.Remove(modDel);
AddLog("Eliminar Clima Fecha " + modDel.Date);
}
else
{
if (model.Id == 0)
{
db.Weather.Add(model);
AddLog("Agregar Clima Fecha " + model.Date);
}
else
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
AddLog("Modificar Clima Fecha " + model.Date);
}
}
db.SaveChanges();
return(model.Id.ToString());
}
catch (Exception ex)
{
return("0");
}
}
public void AddLog(string Services)
{
var db = new AmericaVirtualContext();
var Log = new Services_Log()
{
Service = Services, Date_Add = DateTime.Today
};
db.Services_Log.Add(Log);
db.SaveChanges();
}
public string GetUsers(int Id_User = 0)
{
try
{
var db = new AmericaVirtualContext();
var Users = db.Users.Where(x => (Id_User == 0 || x.Id == Id_User)).ToList();
AddLog("Obtener Usuario");
return(JsonConvert.SerializeObject(Users));
}
catch (Exception ex)
{
return(String.Empty);
}
}
public string GetProvinces(int Id_Province = 0, int Id_Country = 0)
{
try
{
var db = new AmericaVirtualContext();
var Provinces = db.Provinces.Include("Countries").Where(x => (Id_Country == 0 || x.Id_Country == Id_Country) && (Id_Province == 0 || x.Id == Id_Province)).ToList();
AddLog("Obtener Provincias");
return(JsonConvert.SerializeObject(Provinces));
}
catch (Exception ex)
{
return(String.Empty);
}
}
public string GetCountries(int Id_Country = 0)
{
try
{
var db = new AmericaVirtualContext();
var Countries = db.Countries.Where(x => (Id_Country == 0 || x.Id == Id_Country)).ToList();
AddLog("Obtener Países");
return(JsonConvert.SerializeObject(Countries));
}
catch (Exception ex)
{
return(String.Empty);
}
}
public string GetWeathersWeek(int Id_Weather = 0, int Id_Province = 0)
{
try
{
var db = new AmericaVirtualContext();
var Weathers = db.Weather.Include("Countries").Include("Provinces").Where(x => (Id_Weather == 0 || x.Id == Id_Weather) && (Id_Province == 0 || x.Id_Province == Id_Province) && (x.Date > DateTime.Today)).OrderByDescending(x => x.Id).OrderBy(x => x.Date).Take(5).ToList();
AddLog("Obtener Los ultimos 5 Dias del Clima");
return(JsonConvert.SerializeObject(Weathers));
}
catch (Exception ex)
{
return(String.Empty);
}
}
public string GetWeathers(int Id_Weather = 0, int Id_Province = 0)
{
try
{
var db = new AmericaVirtualContext();
var Weathers = db.Weather.Include("Countries").Include("Provinces").Where(x => (Id_Weather == 0 || x.Id == Id_Weather) && (Id_Province == 0 || x.Id_Province == Id_Province)).OrderBy(x => x.Date).ToList();
AddLog("Obtener Climas");
return(JsonConvert.SerializeObject(Weathers));
}
catch (Exception ex)
{
return(String.Empty);
}
}
public string ValidateLogin(string user, string pass)
{
try
{
var db = new AmericaVirtualContext();
var UserExist = db.Users.Where(x => x.Email == user && x.Password == pass).FirstOrDefault();
AddLog("Login Usuario " + UserExist.Name);
if (UserExist != null)
{
return(JsonConvert.SerializeObject(UserExist));
}
else
{
return("");
}
}
catch (Exception ex)
{
return("");
}
}
