public List <AppUser> GetAllMember(out int totalCount, int pageIndex, string keyword = null)
{
using var context = new BusinessTrackContext();
var query = context.Users.Join(context.UserRoles, user => user.Id, userRole => userRole.UserId, (resultUser, resultUserRole) => new
{
User = resultUser,
UserRole = resultUserRole
}).Join(context.Roles, twoTableResult => twoTableResult.UserRole.RoleId, roles => roles.Id, (resultTable, resultRole) => new
{
resultTable.User,
UserRoles = resultTable.UserRole,
Roles = resultRole
}).Where(i => i.Roles.Name.Equals("Member")).Select(i => new AppUser
{
Id = i.User.Id,
Name = i.User.Name,
Surname = i.User.Surname,
Picture = i.User.Picture,
Email = i.User.Email,
UserName = i.User.UserName
});
if (!string.IsNullOrEmpty(keyword) && !string.IsNullOrWhiteSpace(keyword))
{
query = query.Where(i => i.Name.ToLower().Contains(keyword.ToLower()) ||
i.Surname.ToLower().Contains(keyword.ToLower()));
}
totalCount = query.Count();
query = query.Skip((pageIndex - 1) * 3).Take(3);
return(query.ToList());
}
public List <Assignment> GetAssignmentsByUserId(int userId)
{
using var context = new BusinessTrackContext();
var query = context.Assignments.Where(i => i.AppUserId == userId);
return(query.ToList());
}
public Assignment GetAssignmentWithExigencyById(int id)
{
using var context = new BusinessTrackContext();
var query = context.Assignments.Include(i => i.Exigency).Where(i => !i.Status);
return(query.FirstOrDefault(i => i.Id == id));
}
public Assignment GetAssignmentWithReports(int id)
{
using var context = new BusinessTrackContext();
var query = context.Assignments.Include(i => i.Reports).Include(i => i.AppUser);
return(query.FirstOrDefault(i => i.Id == id));
}
public int GetReportCountByUserId(int id)
{
using var context = new BusinessTrackContext();
var query = context.Assignments.Include(i => i.Reports).Where(i => i.AppUserId == id);
return(query.SelectMany(i => i.Reports).Count());
}
public List <Notification> GetMessagesByReadStatus(int userId, bool readStatus)
{
using var context = new BusinessTrackContext();
var query = context.Notifications.Where(i => i.AppUserId == userId && i.Status == readStatus);
return(query.ToList());
}
public List <Assignment> GetIncompleteAssignmentWithExigency()
{
//Eager Loading : Görevler class'ını çağırırken beraberinde aciliyeti de getirdim.
using var context = new BusinessTrackContext();
var query = context.Assignments.Include(i => i.Exigency).Where(i => !i.Status);
return(query.OrderByDescending(x => x.CreatedOn).ToList());
}
public List <Assignment> GetAllWithAssociatedTables()
{
using var context = new BusinessTrackContext();
var query = context.Assignments.Include(i => i.Exigency)
.Include(i => i.Reports)
.Include(i => i.AppUser);
return(query.Where(i => !i.Status).OrderByDescending(i => i.CreatedOn).ToList());
}
public List <Assignment> GetAllInCompleteWithRelationships(out int totalPageCount, int userId, int pageIndex)
{
using var context = new BusinessTrackContext();
var query = context.Assignments.Include(i => i.Exigency)
.Include(i => i.Reports)
.Include(i => i.AppUser)
.Where(i => i.AppUserId == userId && i.Status)
.OrderByDescending(i => i.CreatedOn);
totalPageCount = query.Count();
return(query.Skip((pageIndex - 1) * 3).Take(3).ToList());
}
public List <DualHelper> GetMostEmployedStaff()
{
using var context = new BusinessTrackContext();
var query = context.Assignments.Include(i => i.AppUser)
.Where(i => !i.Status && i.AppUserId != null)
.GroupBy(i => i.AppUser.UserName)
.OrderByDescending(i => i.Count());
var query2 = query.Take(5).Select(i => new DualHelper
{
Name = i.Key,
AssignmentCount = i.Count()
});
return(query2.ToList());
}
public int GetUnreadNotificationsCountByUserId(int id)
{
using var context = new BusinessTrackContext();
return(context.Notifications.Count(i => i.AppUserId == id && !i.Status));
}
public int GetCompletedTaskCount()
{
using var context = new BusinessTrackContext();
return(context.Assignments.Count(i => i.Status));
}
public List <Report> GetReportsByAssignmentId(int id)
{
using var context = new BusinessTrackContext();
return(context.Reports.Where(i => i.AssignmentId == id).ToList());
}
public Report GetReportWithAssignment(int id)
{
using var context = new BusinessTrackContext();
return(context.Reports.Include(i => i.Assignment).ThenInclude(i => i.Exigency).SingleOrDefault(i => i.Id == id));
}
public List <TEntity> GetAll()
{
using var context = new BusinessTrackContext();
return(context.Set <TEntity>().ToList());
}
public TEntity GetById(int id)
{
using var context = new BusinessTrackContext();
return(context.Set <TEntity>().Find(id));
}
public void Insert(TEntity entity)
{
using var context = new BusinessTrackContext();
context.Set <TEntity>().Add(entity);
context.SaveChanges();
}
public int GetInCompletedTaskCountByUserId(int id)
{
using var context = new BusinessTrackContext();
return(context.Assignments.Count(i => i.AppUserId == id && !i.Status));
}
public void Delete(IEnumerable <TEntity> entities)
{
using var context = new BusinessTrackContext();
context.Set <TEntity>().RemoveRange(entities);
context.SaveChanges();
}
public void Delete(TEntity entity)
{
using var context = new BusinessTrackContext();
context.Set <TEntity>().Remove(entity);
context.SaveChanges();
}
public void Insert(IEnumerable <TEntity> entities)
{
using var context = new BusinessTrackContext();
context.Set <TEntity>().AddRange(entities);
context.SaveChanges();
}
public int GetUnAssignedTaskCount()
{
using var context = new BusinessTrackContext();
return(context.Assignments.Count(i => i.AppUserId == null && !i.Status));
}
public int GetAllReportCount()
{
using var context = new BusinessTrackContext();
return(context.Reports.Count());
}
