// GET BY ID
public static Personnels GetById(int id)
{
using (var context = new TacheContext())
{
return(context.Set <Personnels>().Find(id));
}
}
public static Users Find(int id)
{
using (var context = new TacheContext())
{
return(context.Set <Users>().Find(id));
}
}
public static bool verfify(Users user)
{
using (var context = new TacheContext())
{
var _user = context.Set <Users>().Where(u => u.username == user.username);
if (user != null)
{
return(false);
}
return(true);
}
}
public static Users IsUser(Users user)
{
using (var context = new TacheContext())
{
try
{
return(context.Set <Users>().Where(s => s.username == user.username && s.password == user.password).FirstOrDefault());
}
catch (Exception e)
{
return(null);
}
}
}
public static List <Personnels> GetByPage(int page)
{
if (page == 0)
{
page = 1;
}
int count = 5;
var skip = (count * page) - count;
if (GetAll().Count() < skip)
{
skip = 0;
}
using (var context = new TacheContext())
{
return(context.Set <Personnels>().Skip(skip).Take(count).ToList());
}
}