public List <Target> GetListForHomePage()
{
using var context = new NuevoContext();
DateTime date = DateTime.Now;
var result = context.Targets.AsQueryable();
return(result.Include(u => u.Status).Where(u => u.EndOfPeriod >= date && u.StartOfPeriod <= date).OrderBy(u => u.Status.FirstOrDefault().CheckDateTime).ToList());
}
public List <Target> GetListForWork()
{
using var context = new NuevoContext();
DateTime date = DateTime.Now;
var result = context.Targets.AsQueryable();
return(result.Where(u => u.EndOfPeriod >= date && u.StartOfPeriod <= date).ToList());
}
public List <Target> GetList(out int count, int page, string search)
{
using var context = new NuevoContext();
var result = context.Targets.AsQueryable();
count = (int)Math.Ceiling((double)result.Count() / 7);
if (!string.IsNullOrWhiteSpace(search))
{
result = result.Where(u => u.Url.Trim().ToLower().Contains(search.Trim().ToLower()) ||
u.Name.Trim().ToLower().Contains(search.Trim().ToLower()));
count = (int)Math.Ceiling((double)result.Count() / 7);
}
result = result.Skip((page - 1) * 7).Take(7);
result = result.Include(u => u.Status).Include(u => u.User);
return(result.ToList());
}
public Statu GetStatuForTargetId(int id)
{
using var context = new NuevoContext();
var data = context.Status.FirstOrDefault(u => u.TargetId == id);
if (data == null)
{
Statu newStatu = new Statu
{
IsSendAnEmail = false,
CheckDateTime = DateTime.Now,
TargetId = id,
Code = "Not Checked Yet",
};
context.Set <Statu>().Add(newStatu);
context.SaveChanges();
return(newStatu);
}
return(data);
}
public void Update(T obj)
{
using var context = new NuevoContext();
context.Set <T>().Update(obj);
context.SaveChanges();
}
public List <T> GetList()
{
using var context = new NuevoContext();
return(context.Set <T>().ToList());
}
public T GetItem(int id)
{
using var context = new NuevoContext();
return(context.Set <T>().Find(id));
}
public void Delete(T obj)
{
using var context = new NuevoContext();
context.Set <T>().Remove(obj);
context.SaveChanges();
}
public void Add(T obj)
{
using var context = new NuevoContext();
context.Set <T>().Add(obj);
context.SaveChanges();
}
