/// <summary>
/// 查询模拟器待处理任务数
/// </summary>
/// <param name="status"></param>
/// <returns></returns>
public static List <TaskSch> GetTasksForSendGroup(string status = "waiting")
{
TasksDAL dal = new TasksDAL();
List <TaskSch> list = (List <TaskSch>)dal.GetTasksForSendGroup(status);
return(list);
}
/// <summary>
/// 变更任务状态
/// </summary>
/// <param name="id"></param>
/// <param name="status"></param>
/// <returns></returns>
public static int UpdateTaskStatus(int id, int status)
{
TasksDAL dal = new TasksDAL();
int res = dal.UpdateTaskStatus(id, status);
return(res);
}
public static int UpdateTaskRes(int id, string resval)
{
TasksDAL dal = new TasksDAL();
int res = dal.UpdateTaskResult(id, resval);
return(res);
}
// Edit a task
public ActionResult EditTask()
{
if (!(User.Identity.IsAuthenticated && User.Identity.Name == "admin"))
{
return(RedirectToAction("Index", "Home"));
}
Guid taskId = Guid.Parse(Request.Form["taskId"]);
if (Request.Form["edit"] != null)
{
Tasks task = TasksDAL.GetTaskById(taskId);
ViewBag.Task = task;
ViewBag.Operation = "Edit";
}
else if (Request.Form["delete"] != null)
{
if (taskId != null)
{
TasksDAL.DeleteTask(taskId);
}
}
else if (Request.Form["save"] != null)
{
TasksDAL.EditTask(Guid.Parse(Request.Form["taskId"]), Request.Form["taskName"], Request.Form["description"],
DateTime.Parse(Request.Form["start"]), DateTime.Parse(Request.Form["end"]),
int.Parse(Request.Form["estimation"]), Request.Form["status"]);
}
return(View("../Admin/Task"));
}
public static int UpdateTimedTaskExecuteTime(int id)
{
TasksDAL dal = new TasksDAL();
int res = dal.UpdateTimedTaskExecuteTime(id);
return(res);
}
public static List <TaskSch> GetTasksList(string status, int orders, int limit = 100)
{
TasksDAL dal = new TasksDAL();
List <TaskSch> list = (List <TaskSch>)dal.GetTasksForSend(status, orders, limit);
return(list);
}
public static List <TaskSch> GetTimedTaskList()
{
TasksDAL dal = new TasksDAL();
List <TaskSch> list = (List <TaskSch>)dal.GetTimedTasks();
return(list);
}
public static List <TaskSch> GetGlobalTaskList(string status, int limit = 100)
{
TasksDAL dal = new TasksDAL();
List <TaskSch> list = (List <TaskSch>)dal.GetGlobalTasks(status, limit);
return(list);
}
/// <summary>
/// 获取执行的任务数
/// </summary>
/// <returns></returns>
public static int CountByStatus(string status = "waiting")
{
TasksDAL dal = new TasksDAL();
int resnum = dal.CountByStatus(status);
return(resnum);
}
/// <summary>
/// 获取每个模拟器待发任务数
/// </summary>
/// <param name="status"></param>
/// <param name="mobileindex"></param>
/// <returns></returns>
public static int CountByStatus(string status, int mobileindex, int iswhole)
{
TasksDAL dal = new TasksDAL();
int resnum = dal.CountByStatus(status, mobileindex, iswhole);
return(resnum);
}
// Create a task
public ActionResult CreateTask()
{
if (!(User.Identity.IsAuthenticated && User.Identity.Name == "admin"))
{
return(RedirectToAction("Index", "Home"));
}
try
{
if (Request.Form["save"] != null)
{
DateTime start = DateTime.Now;
if (Request.Form["start"] != "")
{
start = DateTime.Parse(Request.Form["start"]);
}
DateTime end = DateTime.Now;
if (Request.Form["end"] != "")
{
end = DateTime.Parse(Request.Form["end"]);
}
string values = Request.Form["users"];
string[] userIds = values.Split(',');
TasksDAL.CreateTask(Request.Form["taskName"], Request.Form["description"], start,
end, int.Parse(Request.Form["estimation"]), Request.Form["status"], userIds);
}
return(RedirectToAction("Task", "Admin"));
}
catch (Exception ex)
{
return(View());
}
}
//GET: /Admin/Task
public ActionResult Task(string name)
{
if (!(User.Identity.IsAuthenticated && User.Identity.Name == "admin"))
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.Operation = name;
if (name == "Edit")
{
List <Tasks> tasks = TasksDAL.GetAllTasks();
List <TaskViewModel> tasksViewModel = new List <TaskViewModel>();
foreach (var task in tasks)
{
tasksViewModel.Add(
new TaskViewModel(task)
);
}
return(View(tasksViewModel));
}
else
{
List <Users> users = UsersDAL.GetAllUsers();
List <UserViewModel> usersViewModel = new List <UserViewModel>();
foreach (var user in users)
{
usersViewModel.Add(
new UserViewModel(user)
);
}
return(View(usersViewModel));
}
}
public static int CreateTask(TaskSch tasks)
{
int flag = 0;
TasksDAL dal = new TasksDAL();
flag = dal.InsertTask(tasks);
return(flag);
}
/// <summary>
/// 删除任务
/// </summary>
/// <returns></returns>
public static int DeleteTasks(int id)
{
int flag = 0;
TasksDAL dal = new TasksDAL();
flag = dal.DeleteTasks(id);
return(flag);
}
public static IEnumerable <TodoTask> GetTasks()
{
var tasks = TasksDAL.GetTasks();
foreach (var item in tasks)
{
if (item.Status == default(TodoTaskStatus))
{
item.Status = TodoTaskStatus.New;
}
}
return(tasks);
}
//FUNCTIONS FOR REPEATED BLOCKS OF CODE
private TaskItem GetTaskWhereIDIsFirstORDefault(int id)
{
TasksDAL taskDAL = _toDoListDBContext.Tasks
.Where(task => task.taskID == id)
.FirstOrDefault();
var task = new TaskItem();
task.DueDate = taskDAL.DueDate;
task.Description = taskDAL.Description;
task.TaskID = taskDAL.taskID;
task.UserID = taskDAL.UserID;
return(task);
}
//
// GET: /Cards/
public ActionResult Index()
{
if (User.Identity.IsAuthenticated)
{
List <Tasks> tasks = TasksDAL.GetTasksByUser(User.Identity.Name);
List <TaskViewModel> tasksViewModel = new List <TaskViewModel>();
foreach (var task in tasks)
{
tasksViewModel.Add(
new TaskViewModel(task)
);
}
return(View(tasksViewModel));
}
return(RedirectToAction("Index", "Home"));
}
public IActionResult PushTaskToSQL(AddTaskViewModel model)
{
var newTask = new TasksDAL();
newTask.Description = model.Description;
newTask.DueDate = model.DueDate;
newTask.IsDone = model.IsDone;
UsersDAL userDAL = _toDoListDBContext.Users
.Where(user => user.Email == _currentUser.CurrentUser.Email).FirstOrDefault();
newTask.UserID = userDAL.userID; //FOREIGN KEY SET UP
_toDoListDBContext.Tasks.Add(newTask);
_toDoListDBContext.SaveChanges();
return(ListItems());
}
//
// GET: /Tasks/
public ActionResult Index(string id)
{
if (id != null)
{
ShowTask(Guid.Parse(id));
}
List <Tasks> tasks = TasksDAL.GetTasks();
List <TaskViewModel> tasksViewModel = new List <TaskViewModel>();
List <int> numberOfWorkers = new List <int>();
foreach (var task in tasks)
{
tasksViewModel.Add(
new TaskViewModel(task)
);
numberOfWorkers.Add(TasksDAL.GetNumberOfUsersPerTask(task.TaskId));
}
ViewBag.NumberOfWorkers = numberOfWorkers;
return(View(tasksViewModel));
}
public static List <ResponseGetTaskByUserId> GetAllTasksByUserIdComplyWithDayOfWeek(int userId, int day_of_week, string datetime, bool onlyMine)
{
List <TasksDTO> arrTasks = TasksDAL.GetAllTasksByUserIdComplyWithDayOfWeek(userId, day_of_week, datetime, onlyMine);
List <ResponseGetTaskByUserId> arrFinal = new List <ResponseGetTaskByUserId>();
// add partner
for (int i = 0; i < arrTasks.Count; i++)
{
DataTable partners = UsersBLL.getListUserOfTask(arrTasks[i].ID);
ResponseGetTaskByUserId temp = new ResponseGetTaskByUserId();
temp.ID = arrTasks[i].ID;
temp.Title = arrTasks[i].Title;
temp.startDate = arrTasks[i].startDate;
temp.endDate = arrTasks[i].endDate;
temp.Status = arrTasks[i].Status;
temp.Private = arrTasks[i].Private;
temp.HasRemind = TasksDAL.isTaskHasRemind(arrTasks[i].ID);
temp.Partners = partners;
arrFinal.Add(temp);
}
return(arrFinal);
}
public static List <ResponseGetTaskByUserId> GetAllTasksPublicExcludeUserId(int userId)
{
List <TasksDTO> arrTasks = TasksDAL.GetAllTasksPublicExcludeUserId(userId);
List <ResponseGetTaskByUserId> arrFinal = new List <ResponseGetTaskByUserId>();
// add partner
for (int i = 0; i < arrTasks.Count; i++)
{
DataTable partners = UsersBLL.getListUserOfTask(arrTasks[i].ID);
ResponseGetTaskByUserId temp = new ResponseGetTaskByUserId();
temp.ID = arrTasks[i].ID;
temp.Title = arrTasks[i].Title;
temp.startDate = arrTasks[i].startDate;
temp.endDate = arrTasks[i].endDate;
temp.Status = arrTasks[i].Status;
temp.Private = arrTasks[i].Private;
temp.OwnerId = getOwnerByTaskId(arrTasks[i].ID);
temp.Partners = partners;
arrFinal.Add(temp);
}
return(arrFinal);
}
public static bool isTaskHasRemind(int taskId)
{
return(TasksDAL.isTaskHasRemind(taskId));
}
public static DataTable GetAllTasks()
{
return(TasksDAL.GetAllTasks());
}
public static int CreateTask(TasksDTO task, List <int> arrUser, int ownerId)
{
return(TasksDAL.CreateTask(task, arrUser, ownerId));
}
// Update the currentDate field to GETDATE()
public int updateIncompleteTasksToCurrentDate()
{
return(TasksDAL.updateIncompleteTasksToCurrentDate());
}
// Get list of all tasks for the current user
public List <TaskModel> getTasksForCurrentUser(User currentUser, string date)
{
return(TasksDAL.getCurrentUsersTasks(currentUser, date));
}
// Update task to incomplete status
public int updateTaskIncomplete(int taskID)
{
return(TasksDAL.updateTaskIncomplete(taskID));
}
// Update task to complete status
public int updateTaskCompleted(int taskID)
{
return(TasksDAL.updateTaskCompleted(taskID));
}
public static void CreateTask(TodoTask task)
{
task.CreatedDate = DateTime.Now;
task.Status = TodoTaskStatus.New;
TasksDAL.CreateTask(task);
}
public static int getOwnerByTaskId(int taskId)
{
return(TasksDAL.getOwnerByTaskId(taskId));
}
