/// <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)); }