public RequestGroup Post(RequestGroup requestGroup)
{
using (var db = new PtoContext()){
var user = db.User.FirstOrDefault(x => x.id == requestGroup.userId);
requestGroup.user = user;
db.Add(requestGroup);
db.SaveChanges();
//sendNewRequestEmail(user);
}
return(requestGroup);
}
public RequestGroup Patch(RequestGroup requestGroup)
{
using (var db = new PtoContext()){
var entity = db.RequestGroup.FirstOrDefault(x => x.id == requestGroup.id);
if (entity != null)
{
entity.status = requestGroup.status;
db.SaveChanges();
//sendUpdatedRequestEmail(db.User.FirstOrDefault(x => x.id == 90650));
}
}
return(requestGroup);
}
public PtoController(PtoContext context)
{
_context = context;
if (_context.PtoItems.Count() == 0)
{
// Create a new PtoItem if collection is empty,
// which means you can't delete all PtoItems.
_context.PtoItems.Add(new PtoItem {
Name = "Item1"
});
_context.SaveChanges();
}
}
public List <RequestGroup> GetManagedRequests()
{
using (var db = new PtoContext()){
return(db.RequestGroup.Include(x => x.user).Include(x => x.requests).Where(x => x.managerId == 90650).ToList());
}
}
public User GetUser()
{
using (var db = new PtoContext()){
return(db.User.Include(x => x.manager).Include(x => x.requestGroups).ThenInclude(x => x.requests).FirstOrDefault(x => x.id == 90650));
}
}
