public TasksViewModel GetTasksViewModelData(UserTaskContext db, string filterType)
{
// Получение значений количества выполненных задач и общего кол-ва задач в различных категориях
DateTime currentDate = DateTime.Now.Date;
DateTime endDate = currentDate.AddDays(7);
int inboxTasksNumber = db.UserTasks.Where(c => c.DeadlineDate >= currentDate).Count();
int doneInboxTasksNumber = db.UserTasks.Where(c => c.TaskDone == true && c.DeadlineDate >= currentDate).Count();
int todayTasksNumber = db.UserTasks.Where(c => c.DeadlineDate == currentDate).Count();
int doneTodayTasksNumber = db.UserTasks.Where(c => c.DeadlineDate == currentDate && c.TaskDone == true).Count();
int weekTasksNumber = db.UserTasks.Where(c => c.DeadlineDate >= currentDate && c.DeadlineDate <= endDate).Count();
int doneWeekTasksNumber = db.UserTasks.Where(c => c.DeadlineDate >= currentDate && c.DeadlineDate <= endDate && c.TaskDone == true).Count();
int archiveTasksNumber = db.UserTasks.Where(c => c.DeadlineDate < currentDate).Count();
int doneArchiveTasksNumber = db.UserTasks.Where(c => c.DeadlineDate < currentDate && c.TaskDone == true).Count();
// Получение значений "Имя страницы", "Количества задач", "Групп задач"
string pageName;
int queryTasksNumber;
IEnumerable <IGrouping <DateTime, UserTask> > groups;
if (filterType == "Today")
{
groups = db.UserTasks.Where(c => c.DeadlineDate == currentDate).GroupBy(p => p.DeadlineDate).ToList();
queryTasksNumber = db.UserTasks.Where(c => c.DeadlineDate == currentDate).Count();
pageName = "Задачи на сегодня";
}
else if (filterType == "Week")
{
groups = db.UserTasks.Where(c => c.DeadlineDate >= currentDate && c.DeadlineDate <= endDate).GroupBy(p => p.DeadlineDate).ToList();
queryTasksNumber = db.UserTasks.Where(c => c.DeadlineDate >= currentDate && c.DeadlineDate <= endDate).Count();
pageName = "Задачи на cледующие 7 дней";
}
else if (filterType == "Archive")
{
groups = db.UserTasks.Where(c => c.DeadlineDate < currentDate).GroupBy(p => p.DeadlineDate).ToList();
queryTasksNumber = db.UserTasks.Where(c => c.DeadlineDate < currentDate).Count();
pageName = "Архив задач";
}
else
{
groups = db.UserTasks.Where(c => c.DeadlineDate >= currentDate).GroupBy(p => p.DeadlineDate).ToList();
queryTasksNumber = db.UserTasks.Where(c => c.DeadlineDate >= currentDate).Count();
pageName = "Входящие задачи";
}
// Занесение вычеслинных значений в объект viewModel
var viewModel = new TasksViewModel()
{
PageName = pageName,
InboxTasksNumber = inboxTasksNumber,
DoneInboxTasksNumber = doneInboxTasksNumber,
TodayTasksNumber = todayTasksNumber,
DoneTodayTasksNumber = doneTodayTasksNumber,
WeekTasksNumber = weekTasksNumber,
DoneWeekTasksNumber = doneWeekTasksNumber,
ArchiveTasksNumber = archiveTasksNumber,
DoneArchiveTasksNumber = doneArchiveTasksNumber,
QueryTasksNumber = queryTasksNumber,
Groups = groups
};
return(viewModel);
}
public UserController(IDistributedCache cache, UserTaskContext context, IOptions <AppSettings> appSettings, ILogger <UserController> logger)
{
_cache = cache;
_logger = logger;
_context = context;
_appSettings = appSettings.Value;
}
public JsonResult GetTaskInfo(int id)
{
UserTaskContext db = new UserTaskContext();
UserTask task = db.UserTasks.Where(c => c.Id == id).FirstOrDefault();
return(Json(task, JsonRequestBehavior.AllowGet));
}
public TaskItemsController(UserTaskContext context, ILogger <TaskItemsController> logger)
{
_logger = logger;
_context = context;
// Create the database if not exists
_context.Database.EnsureCreated();
}
public ActionResult Index(string filterType)
{
using (UserTaskContext db = new UserTaskContext()) {
var viewModel = GetTasksViewModelData(db, filterType);
ViewBag.filterType = filterType;
return(View(viewModel));
}
}
public ActionResult ChangeTaskState(int id, string filterType)
{
using (UserTaskContext db = new UserTaskContext())
{
UserTask task = db.UserTasks.Where(c => c.Id == id).FirstOrDefault();
task.TaskDone = !task.TaskDone;
db.SaveChanges();
}
if (filterType == "")
{
return(Redirect("/Home/Index"));
}
else
{
return(Redirect("/Home/Index/?FilterType=" + filterType));
}
}
public ActionResult DeleteTask(int id, string filterType)
{
using (UserTaskContext db = new UserTaskContext())
{
UserTask task = db.UserTasks.Where(c => c.Id == id).FirstOrDefault();
db.UserTasks.Attach(task);
db.UserTasks.Remove(task);
db.SaveChanges();
}
if (filterType == "")
{
return(Redirect("/Home/Index"));
}
else
{
return(Redirect("/Home/Index/?FilterType=" + filterType));
}
}
public ActionResult AddTask(string taskName, string deadlineDate, string deadlineTime, string highPriority, string filterType)
{
bool HighTaskPriority = (highPriority == "True") ? true : false;
DateTime Date = Convert.ToDateTime(deadlineDate);
using (UserTaskContext db = new UserTaskContext())
{
UserTask task = new UserTask {
TaskName = taskName, TaskDone = false, HighTaskPriority = HighTaskPriority, DeadlineDate = Date, DeadlineTime = deadlineTime
};
db.UserTasks.Add(task);
db.SaveChanges();
}
if (filterType == "")
{
return(Redirect("/Home/Index"));
}
else
{
return(Redirect("/Home/Index/?FilterType=" + filterType));
}
}
public ActionResult ChangeTask(int taskId, string taskName, string deadlineDate, string deadlineTime, string highPriority, string filterType)
{
bool HighTaskPriority = (highPriority == "True") ? true : false;
DateTime Date = Convert.ToDateTime(deadlineDate);
using (UserTaskContext db = new UserTaskContext())
{
UserTask task = db.UserTasks.Where(c => c.Id == taskId).FirstOrDefault();
task.TaskName = taskName;
task.HighTaskPriority = HighTaskPriority;
task.DeadlineDate = Date;
task.DeadlineTime = deadlineTime;
db.SaveChanges();
}
if (filterType == "")
{
return(Redirect("/Home/Index"));
}
else
{
return(Redirect("/Home/Index/?FilterType=" + filterType));
}
}
public UserTasksController(UserTaskContext context, UserManager <AplicationUser> userManager)
{
this.userManager = userManager;
_context = context;
_context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
public UsersController(UserTaskContext context, IServiceProvider serviceProvider)
{
_context = context;
this.serviceProvider = serviceProvider;
}
public TasksController(UserTaskContext context)
{
_context = context;
}
// treba izvuci usera iz jwta
public GenericLogger(UserTaskContext userTaskContext)
{
_userTaskContext = userTaskContext;
type = typeof(T);
}
public UserRepository(UserTaskContext userTaskContext) : base(userTaskContext)
{
_userTaskContext = userTaskContext;
}
public GenericRepository(UserTaskContext userTaskContext) : base(userTaskContext)
{
_userTaskContext = userTaskContext;
}
