public static List <Personnels> GetAll()
{
using (var context = new TacheContext())
{
return(context.Personnel.ToList());
}
}
public static Users Find(int id)
{
using (var context = new TacheContext())
{
return(context.Set <Users>().Find(id));
}
}
// GET BY ID
public static Personnels GetById(int id)
{
using (var context = new TacheContext())
{
return(context.Set <Personnels>().Find(id));
}
}
public static List <Taches> GetAll()
{
using (var context = new TacheContext())
{
return(context.Tache.ToList());
}
}
// CREATE PERSONNEL
public static void create(Personnels Personnel)
{
using (var context = new TacheContext())
{
context.Personnel.Add(Personnel);
context.SaveChanges();
}
}
public static void addPersonnelToTask(Taches taches, Personnels personnels)
{
using (var context = new TacheContext())
{
context.Tache.Update(taches);
context.SaveChanges();
}
}
public static Boolean Create(Taches taches)
{
using (var context = new TacheContext())
{
context.Tache.Add(taches);
context.SaveChanges();
return(true);
}
return(false);
}
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());
}
}
public static List <dynamic> GetTask(int idTache = 0, int page = 0)
{
int count = 5;
if (page == 0)
{
page = 1;
}
if (page > GetAll().Count + count)
{
page = 1;
}
int skip = (page * count) - count;
using (var context = new TacheContext())
{
return(context.Tache
.Where(e => (e.IdTache == idTache) || idTache == 0)
.Select(tache => new
{
idTache = tache.IdTache,
TacheName = tache.TacheName,
Description = tache.Description,
TimeStart = tache.TimeStart,
Deadline = tache.Deadline,
Completed = tache.Completed,
Personnel = tache.personnels
.Select(personnel => new
{
idPersonnel = personnel.IdPersonnel,
Name = personnel.Name,
Email = personnel.Email,
filename = personnel.ImagePersonnel
}).ToList()
})
.Skip(skip)
.OrderByDescending(t => t.TimeStart)
.Take(count)
.ToList <dynamic>());
}
}
public PersonnelController(IWebHostEnvironment webHostEnvironment, TacheContext context)
{
this._context = context;
_webHostEnvironment = webHostEnvironment;
}
public DepartementController(TacheContext context)
{
this.context = context;
}
public TacheController(TacheContext context)
{
this.context = context;
}
public TachesController(TacheContext context)
{
_context = context;
}
public AuthentificationController(IConfiguration config, TacheContext context)
{
this._conf = config;
this.context = context;
}
