public List <Task> GetAllTables(Expression <Func <Task, bool> > filter)
{
using (var context = new BusinessFollowUpProjectContext())
{
return(context.Tasks.Include(I => I.Urgency).Include(I => I.Reports).Include(I => I.AppUser).Where(filter).OrderByDescending(I => I.CreationDate).ToList());
}
}
public List <AppUser> GetNonAdmins(out int totalpage, string searchword, int activepage = 1)
{
//Rolü kullanıcı olanların isimleri admin sayfasında listelenmek için yapılmış sorgu. Bu sayede 3 adet tablo birleştirilmiştir.
using var context = new BusinessFollowUpProjectContext();
var result = 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, role => role.Id, (resultTable, resultRole) => new
{
user = resultTable.user,
userroles = resultTable.userRole,
roles = resultRole
}).Where(I => I.roles.Name == "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
});
totalpage = (int)Math.Ceiling((double)result.Count() / 3);
if (!string.IsNullOrWhiteSpace(searchword))
{
result = result.Where(I => I.Name.ToLower().Contains(searchword.ToLower()) || I.SurName.ToLower().Contains(searchword.ToLower()));
totalpage = (int)Math.Ceiling((double)result.Count() / 3);
}
result = result.Skip((activepage - 1) * 3).Take(3);
return(result.ToList());
}
public List <Task> GetByUrgencyInComplete()
{
using (var context = new BusinessFollowUpProjectContext())
{
return(context.Tasks.Include(I => I.Urgency).
Where(I => !I.Status).OrderByDescending(I => I.CreationDate).ToList());
}
}
public List <DualHelper> MostWorkTaskCompleted()
{
using var context = new BusinessFollowUpProjectContext();
return(context.Tasks.Include(I => I.AppUser).Where(I => !I.Status && I.AppUserId != null).GroupBy(I => I.AppUser.UserName).OrderByDescending(I => I.Count()).Take(5).Select(I => new DualHelper
{
Name = I.Key,
TaskCount = I.Count()
}).ToList());
}
public List <Task> GetAllTablesInCompleted(out int totalPage, int userId, int activePage = 1)
{
using (var context = new BusinessFollowUpProjectContext())
{
var returnvalue = context.Tasks.Include(I => I.Urgency).Include(I => I.Reports).Include(I => I.AppUser).Where(I => I.AppUserId == userId && I.Status).OrderByDescending(I => I.CreationDate);
totalPage = (int)Math.Ceiling((double)returnvalue.Count() / 3);
return(returnvalue.Skip((activePage - 1) * 3).Take(3).ToList());
}
}
public List <AppUser> GetNonAdmins()
{
//Rolü kullanıcı olanların isimleri admin sayfasında listelenmek için yapılmış sorgu. Bu sayede 3 adet tablo birleştirilmiştir.
using var context = new BusinessFollowUpProjectContext();
return(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, role => role.Id, (resultTable, resultRole) => new
{
user = resultTable.user,
userroles = resultTable.userRole,
roles = resultRole
}).Where(I => I.roles.Name == "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
}).ToList());
}
public void Update(Table table)
{
using var context = new BusinessFollowUpProjectContext();
context.Set <Table>().Update(table);
context.SaveChanges();
}
public Table GetId(int id)
{
using var context = new BusinessFollowUpProjectContext();
return(context.Set <Table>().Find(id));
}
public List <Table> GetAll()
{
using var context = new BusinessFollowUpProjectContext();
return(context.Set <Table>().ToList());
}
public Task GetUrgencyId(int id)
{
using var context = new BusinessFollowUpProjectContext();
return(context.Tasks.Include(I => I.Urgency).FirstOrDefault(I => !I.Status && I.Id == id));
}
//TAMAMLANAN İŞLER
public int GetTaskCountCompletedbyAppUserId(int id)
{
using var context = new BusinessFollowUpProjectContext();
return(context.Tasks.Count(I => I.AppUserId == id && I.Status));
}
public int GetTaskCompleted()
{
using var context = new BusinessFollowUpProjectContext();
return(context.Tasks.Count(I => I.Status));
}
public Task GetReportId(int id)
{
using var context = new BusinessFollowUpProjectContext();
return(context.Tasks.Include(I => I.Reports).Include(I => I.AppUser).Where(I => I.Id == id).FirstOrDefault());
}
public List <Task> GetAppUserId(int appUserId)
{
using var context = new BusinessFollowUpProjectContext();
return(context.Tasks.Where(I => I.AppUserId == appUserId).ToList());
}
public int AssignWaitTaskCount()
{
using var context = new BusinessFollowUpProjectContext();
return(context.Tasks.Count(I => I.AppUserId == null && !I.Status));
}
