// Returns list of tasks loaded from json
public static List <Models.TaskModel> GetTasks()
{
List <Models.TaskModel> tasks = new List <Models.TaskModel>();
JObject tasksJSON;
StorageFile tasksFile = null;
string content = string.Empty;
try
{
var task = Task.Run(async() => { tasksFile = await Windows.Storage.ApplicationData.Current.RoamingFolder.GetFileAsync("tasks.json"); });
task.Wait();
task = Task.Run(async() => { content = await Windows.Storage.FileIO.ReadTextAsync(tasksFile); });
task.Wait();
tasksJSON = JObject.Parse(content);
}
catch (Exception ex)
{
return(tasks);
}
for (int i = 0; i < ((JArray)tasksJSON["Tasks"]).Count(); i++)
{
Models.TaskModel task = new Models.TaskModel();
task.Id = (int)(tasksJSON["Tasks"][i]["Id"]);
task.Description = (string)(tasksJSON["Tasks"][i]["Description"]);
task.Subject = (string)(tasksJSON["Tasks"][i]["Subject"]);
task.Notification = DateTime.ParseExact((string)(tasksJSON["Tasks"][i]["Notification"]), "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
task.Deadline = DateTime.ParseExact((string)(tasksJSON["Tasks"][i]["Deadline"]), "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
task.Assigned = DateTime.ParseExact((string)(tasksJSON["Tasks"][i]["Assigned"]), "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
tasks.Add(task);
}
return(tasks);
}
private async Task Create()
{
var newTask = new Models.TaskModel()
{
Name = this.Name,
DateTime = this.Date.Date.Add(this.Time),
};
var result = await apiService.Create(newTask);
var data = await result.HttpResponse.Content.ReadAsStringAsync();
if (result.HttpResponse.IsSuccessStatusCode)
{
dialogService.ShowMessage("The task has been created.");
await App.Locator.MainPage.RefreshTasks();
navigationService.GoBack();
}
else
{
dialogService.ShowMessage("An error has ocurred");
}
}
public ActionResult CreateTask(Models.TaskModel task_components, Models.ConfigurationModel configuration)
{
configuration.Tasks = Session["config"] as List <Models.TaskModel>;
//int id = task_components.ID + 1;
int type_id = task_components.SelectedTaskTypeID;
string type_desc = task_components.TaskTypes.ToArray()[type_id].Text;
string task = task_components.TaskItem;
int duration = task_components.Duration;
int feedback_id = task_components.SelectedFeedbackTypeID;
string feedback_type_desc = task_components.TaskTypes.ToArray()[feedback_id].Text;
task_components.SelectedTaskTypeDesc = type_desc;
task_components.SelectedFeedbackTypeDesc = feedback_type_desc;
if (configuration.Tasks != null)
{
//int id = configuration.Tasks[configuration.Tasks.Count-1].ID + 1;
//task_components.ID = id;
configuration.Tasks.Add(task_components);
}
else
{
//int id = task_components.ID + 1;
//task_components.ID = id;
configuration.Tasks = new List <Models.TaskModel>();
configuration.Tasks.Add(task_components);
}
Session["config"] = configuration.Tasks;
return(View("Configuration", configuration));
}
public HomeViewModel(INavigation navigation)
{
TaskModel = new Models.TaskModel
{
Task4 = "",
Task3 = "",
Task2 = "",
Task1 = "",
};
List = new ObservableCollection <TaskModel>()
{
};
this.Navigation = navigation;
this.viewlist = new Command(async() =>
{
List.Add(TaskModel);
await GotoPage2();
});
}
//public void DisableTask(string Id)
//{
// _businessLogic.DisableTask(Id);
//}
//public void EnableTask(string Id)
//{
// _businessLogic.EnableTask(Id);
//}
public void Start(bool emptyAllTasksOnStartup = false)
{
if (emptyAllTasksOnStartup)
{
_businessLogic.Empty();
}
foreach (var item in _allTasks)
{
_businessLogic.AddTask(item);
}
//add health checker
var healthCheck = new Models.TaskModel
{
Id = "TaskHealthChecker",
Name = "TaskHealthChecker",
Enabled = true,
Seconds = 2,
Type = null,
StartTaskAt = DateTime.Now,
NextRunTime = DateTime.Now,
LastEnd = DateTime.Now,
LastStart = DateTime.Now
};
_businessLogic.AddTask(healthCheck);
_taskManager.Init();
_taskManager.Start();
}
public Entries()
{
Model = new Models.TaskModel()
{
mmolString = ""
};
}
public Models.TaskModel GetTask(int TaskId)
{
Models.TaskModel Task = new Models.TaskModel();
var dbCon = DBConnection;
if (dbCon.IsConnect())
{
string query = string.Format("SELECT taskid, title, description, status, startdate, datecompleted, datecreated FROM tasks where Taskid={0} and deleted=0", TaskId);
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
Task.TaskId = int.Parse(reader["taskid"].ToString());
Task.Title = reader["title"].ToString();
Task.Description = reader["description"].ToString();
Task.Status = reader["status"].ToString();
Task.StartDate = DateTime.Parse(reader["startdate"].ToString());
Task.DateCompleted = DateTime.Parse(reader["datecompleted"].ToString());
Task.DateCreated = DateTime.Parse(reader["datecreated"].ToString());
}
dbCon.Close();
}
return(Task);
}
public Models.TaskModel GetTask(Models.TaskModel Task)
{
var dbCon = DBConnection; //get database connection
if (dbCon.IsConnect()) //check if connected
{
// set mysql query
string query = string.Format("SELECT taskid, title, description, status, startdate, datecompleted, datecreated FROM tasks where Taskid={0} and deleted=0", Task.TaskId);
var cmd = new MySqlCommand(query, dbCon.Connection); //set mysql command
var reader = cmd.ExecuteReader(); //execute mysql command
while (reader.Read()) //loop through reader and set model properties with database values
{
Task.TaskId = int.Parse(reader["taskid"].ToString());
Task.Title = reader["title"].ToString();
Task.Description = reader["description"].ToString();
Task.Status = reader["status"].ToString();
Task.StartDate = DateTime.Parse(reader["startdate"].ToString());
Task.DateCompleted = DateTime.Parse(reader["datecompleted"].ToString());
Task.DateCreated = DateTime.Parse(reader["datecreated"].ToString());
}
dbCon.Close(); //close connection
}
return(Task); // Return Task
}
public void AddTask(Models.TaskModel newTask)
{
newTask.Id = getNextFreeId();
TasksList.Add(newTask);
TasksList = TasksList.OrderBy(t => t.Deadline).ToList();
Data.TasksDAL.StoreTasks(TasksList);
NotificationsManager.AddTaskNotification(newTask);
}
public ActionResult Details(int id, Models.ConfigurationModel configuration, Models.TaskModel task_components)
{
configuration.Tasks = Session["config"] as List <Models.TaskModel>;
Session["edit_task_id"] = id;
task_components = configuration.Tasks[id];
task_components.ID = id;
return(View("Details", task_components));
}
public static int DeleteTask(int id)
{
DataLibrary.Models.TaskModel data = new Models.TaskModel
{
Id = id
};
string sql = @"delete from dbo.Tasks where Id=@Id";
return(SqlDataAccess.DeleteData(sql, data));
}
public ActionResult DeleteTask(Models.TaskModel task_components, Models.ConfigurationModel configuration)
{
configuration.Tasks = Session["config"] as List <Models.TaskModel>;
int edit_id = int.Parse(Session["edit_task_id"].ToString());
configuration.Tasks.RemoveAt(edit_id);
Session["config"] = configuration.Tasks;
return(View("Configuration", configuration));
}
public void DeleteTask(Models.TaskModel task)
{
for (int i = 0; i < TasksList.Count; i++)
{
if (TasksList[i].Id == task.Id)
{
TasksList.RemoveAt(i);
break;
}
}
Data.TasksDAL.StoreTasks(TasksList);
NotificationsManager.RemoveTaskNotification(task);
}
/*public IActionResult Index()
* {
* List<TaskModel> tasks = new List<TaskModel>();
* for (int i = 1; i < 11; i++)
* {
* tasks.Add(_db.Tasks.FirstOrDefault(p => p.TaskId == i));
* }
* return View(tasks);
* }*/
public IActionResult Create([Bind("TaskId", "TaskName", "TaskDescription", "StartDate", "DueDate", "Progress", "Flags", "Comments", "ProjectId", "UserId")] Models.TaskModel addTask)
{
if (!(UserController.sessionState))
{
return(RedirectToAction("Login", "User"));
}
if (ModelState.IsValid)
{
_db.Tasks.Add(addTask);
_db.SaveChanges();
return(Redirect("Index"));
}
return(View("Create"));
}
private TaskModel ConvertModel(DataAccessLibrary.Models.TaskModel taskModel)
{
var newModel = new Models.TaskModel()
{
ID = (int)taskModel.ID,
Title = taskModel.Title,
Priority = taskModel.Priority,
Description = taskModel.Description,
DueDate = taskModel.DueDate,
IsDone = taskModel.IsDone
};
return(newModel);
}
public ActionResult Edit(int id, Models.ConfigurationModel configuration, Models.TaskModel task_components)
{
configuration.Tasks = Session["config"] as List <Models.TaskModel>;
Session["edit_task_id"] = id;
task_components = configuration.Tasks[id];
//configuration.Tasks.RemoveAt(id);
int type_id = task_components.SelectedTaskTypeID;
string type_desc = task_components.TaskTypes.ToArray()[type_id].Text;
string task = task_components.TaskItem;
int duration = task_components.Duration;
int feedback_id = task_components.SelectedFeedbackTypeID;
string feedback_type_desc = task_components.TaskTypes.ToArray()[feedback_id].Text;
return(View("Edit", task_components));
}
public static int CreateTask(string taskName, Priority taskPriority, Status taskStatus, DateTime taskDeadline, string taskDetails, int userId)
{
DataLibrary.Models.TaskModel data = new Models.TaskModel
{
TaskName = taskName,
TaskPriority = taskPriority,
TaskStatus = taskStatus,
TaskDeadline = taskDeadline,
TaskDetails = taskDetails,
UserId = userId
};
string sql = @"insert into dbo.Tasks (TaskName, TaskPriority, TaskStatus, TaskDeadline, TaskDetails, UserId) values (@TaskName, @TaskPriority, @TaskStatus, @TaskDeadline, @TaskDetails, @UserId)";
return(SqlDataAccess.SaveData(sql, data));
}
public static int EditTask(int id, string taskName, Priority taskPriority, Status taskStatus, DateTime taskDeadline, string taskDetails)
{
DataLibrary.Models.TaskModel data = new Models.TaskModel
{
Id = id,
TaskName = taskName,
TaskPriority = taskPriority,
TaskStatus = taskStatus,
TaskDeadline = taskDeadline,
TaskDetails = taskDetails
};
string sql = @"update dbo.Tasks set TaskName=@TaskName, TaskPriority=@TaskPriority, TaskStatus=@TaskStatus, TaskDeadline=@TaskDeadline, TaskDetails=@TaskDetails where Id=@Id";
return(SqlDataAccess.EditData(sql, data));
}
public ActionResult AddTask(Models.TaskModel model)
{
var task = new Domain.Task
{
Id = model.Id,
TaskDate = model.TaskDate,
StartTime = model.StartTime.TimeOfDay,
EndTime = model.EndTime.TimeOfDay,
DelayTime = model.DelayTime.TimeOfDay,
CategoryId = model.CategoryId
};
_dbContext.Tasks.Add(task);
_dbContext.SaveChanges();
return(Ok());
}
public Models.TaskModel CreateTask(Models.TaskModel Task)
{
var dbCon = DBConnection; //get database
if (dbCon.IsConnect()) //check if connected
{
//set query to execute
string query = string.Format("INSERT INTO tasks (title, description, status, startdate, datecompleted, datecreated,completed,deleted) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}',0,0);", Task.Title, Task.Description, Task.Status, Task.StartDate, Task.DateCompleted, Task.DateCreated);
var cmd = new MySqlCommand(query, dbCon.Connection); //set mysql command to execute
var reader = cmd.ExecuteNonQuery(); //execute command
dbCon.Close(); //clsoe database
}
return(Task); //return task model
}
public Models.TaskModel UpdateTask(Models.TaskModel Task)
{
var dbCon = DBConnection; //get database
if (dbCon.IsConnect()) //check if connected
{
//set query to update the task
string query = string.Format("UPDATE tasks set title='{0}', description='{1}', status='{2}', startdate='{3}', datecompleted='{4}', datecreated='{5}' WHERE Taskid={6} and deleted=0;", Task.Title, Task.Description, Task.Status, Task.StartDate, Task.DateCompleted, Task.DateCreated, Task.TaskId);
var cmd = new MySqlCommand(query, dbCon.Connection); //create mysql command
var reader = cmd.ExecuteNonQuery(); //execute query
dbCon.Close(); //database close
}
return(Task); //return view
}
public void UpdateTaskComplete(Models.TaskModel Task)
{
var dbCon = DBConnection;
if (dbCon.IsConnect())
{
string query = string.Format("UPDATE tasks set datecompleted='{0}', completed={1} WHERE Taskid={2};", Task.DateCompleted, Task.Completed, Task.TaskId);
if (dbCon.Connection.State.ToString() == "Closed")
{
dbCon.Connection.Open();
}
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteNonQuery();
dbCon.Close();
}
}
public ActionResult EditTask(Models.TaskModel task_components, Models.ConfigurationModel configuration)
{
configuration.Tasks = Session["config"] as List <Models.TaskModel>;
int edit_id = int.Parse(Session["edit_task_id"].ToString());
int type_id = task_components.SelectedTaskTypeID;
string type_desc = task_components.TaskTypes.ToArray()[type_id].Text;
int feedback_id = task_components.SelectedFeedbackTypeID;
string feedback_type_desc = task_components.TaskTypes.ToArray()[feedback_id].Text;
task_components.SelectedTaskTypeDesc = type_desc;
task_components.SelectedFeedbackTypeDesc = feedback_type_desc;
if (configuration.Tasks != null)
{
configuration.Tasks[edit_id] = task_components;
}
Session["config"] = configuration.Tasks;
return(View("Configuration", configuration));
}
public ActiveTaskViewModel(Models.TaskModel mtask, Models.CollectionModel mcollection)
{
this._mcollection = mcollection;
this._mtask = mtask;
this.Names = new string[this._mcollection.ProcessedImages.Count];
this.Paths = new string[this._mcollection.ProcessedImages.Count];
for(int i = 0; i < this._mcollection.ProcessedImages.Count; i++)
{
Names[i] = this._mcollection.ProcessedImages[i].Name;
Paths[i] = this._mcollection.ProcessedImages[i].Path;
}
this._validations = new ObservableCollection<ValidationViewModel>();
foreach (ValidationModel va in mtask.Algorithm.Validations)
{
this._validations.Add(new ValidationViewModel(va));
}
}
private void onAcceptBtnClick(object sender, RoutedEventArgs e)
{
// get DateTime for begining of week
DateTime mondayDateTime = DateTime.Now;
while (mondayDateTime.DayOfWeek != DayOfWeek.Monday)
{
mondayDateTime = mondayDateTime.AddDays(-1);
}
ScheduleModel schedule = Data.ScheduleDAL.GetSchedule();
string subject = schedule.Schedule[day][lesson];
// get date when task was assigned;
DateTime assigned = mondayDateTime.AddDays(day);
// get date of next lesson
int weekDay = day;
int lessonOffset = 0;
int deadlineAtLesson = Convert.ToInt32(numOfLessonsTextBlock.Text);
DateTime deadline = assigned;
while (deadlineAtLesson > 0)
{
int dayCount = 1;
weekDay++;
if (weekDay == 5)
{
weekDay = 0;
dayCount += 2;
}
while (schedule.Schedule[weekDay][lessonOffset] != subject)
{
lessonOffset++;
if (lessonOffset == schedule.MaxHours)
{
lessonOffset = 0;
weekDay++;
dayCount++;
if (weekDay == 5)
{
weekDay = 0;
dayCount += 2;
}
}
}
deadlineAtLesson--;
deadline = deadline.AddDays(dayCount);
}
DateTime notification = deadline.Date.AddDays(-1).AddHours(17);
Models.TaskModel task = new Models.TaskModel();
task.Description = descritpionTextBox.Text;
task.Subject = subject;
task.Assigned = assigned.Date;
task.Notification = notification;
task.Deadline = deadline;
tasks.AddTask(task);
this.Frame.Navigate(typeof(Pages.SchedulePage));
}
/// <summary>
/// 任务详情
/// </summary>
/// <param name="id"></param>
public ActionResult Detail(string id)
{
if (string.IsNullOrEmpty(id))
{
return Redirect("/Task/MyTask");
}
TaskModel taskModel = new Models.TaskModel();
//任务详情
var task = TaskBusiness.GetTaskDetail(id);
taskModel.Task = task;
//任务对应的订单详情
var order = OrdersBusiness.BaseBusiness.GetOrderBaseInfoByID(task.OrderID, CurrentUser.AgentID, CurrentUser.ClientID);
if (order.Details == null){
order.Details = new List<IntFactoryEntity.OrderDetail>();
}
taskModel.Order = order;
//判断查看权限
if(!IsSeeRoot(task,order)){
Response.Write("<script>alert('您无查看任务权限');location.href='/Task/MyTask';</script>");
Response.End();
}
//任务剩余时间警告
var isWarn = false;
if (task.FinishStatus == 1)
{
if (task.EndTime > DateTime.Now)
{
var totalHour = (task.EndTime - task.AcceptTime).TotalHours;
var residueHour = (task.EndTime - DateTime.Now).TotalHours;
var residue = residueHour / totalHour;
if (residue < 0.333)
{
isWarn = true;
}
}
}
taskModel.IsWarn = isWarn;
//当前用户是否为任务负责人
taskModel.IsTaskOwner = task.OwnerID.Equals(CurrentUser.UserID, StringComparison.OrdinalIgnoreCase) ? true : false;
//当前用户是否有编辑权限
var isEditTask = false;
TaskMember member = task.TaskMembers.Find(a => a.MemberID.ToLower() == CurrentUser.UserID.ToLower());
if (member != null)
{
if (member.PermissionType == 2)
{
isEditTask = true;
}
}
taskModel.IsEditTask = isEditTask;
//订单的品类属性
taskModel.ProductAttr = new IntFactoryEntity.ProductAttr();
//制版任务
if (task.Mark == 12 || task.Mark==22)
{
taskModel.ProductAttr = new ProductsBusiness().GetTaskPlateAttrByCategoryID(order.CategoryID);
}
//任务完成周期
if (task.FinishStatus == 2)
{
taskModel.FinishDay = (int)Math.Ceiling((task.CompleteTime - task.AcceptTime).TotalDays);
}
//操作权限
taskModel.IsRoot = (task.Status != 8 && (task.FinishStatus == 1 || task.LockStatus==2) && (taskModel.IsEditTask || taskModel.IsTaskOwner) );
ViewBag.TaskModel = taskModel;
return View();
}
public ActionResult Detail(string id)
{
if (string.IsNullOrEmpty(id))
{
return(Redirect("/Task/MyTask"));
}
TaskModel taskModel = new Models.TaskModel();
//任务详情
var task = TaskBusiness.GetTaskDetail(id);
if (task == null)
{
Response.Write("<script>alert('任务不存在');location.href='/Task/MyTask';</script>");
Response.End();
}
taskModel.Task = task;
//任务对应的订单详情
var order = task.Order;
ProcessCategoryEntity item = SystemBusiness.BaseBusiness.GetProcessCategoryByID(order.BigCategoryID);
List <CategoryItemsEntity> categoryItems = new List <CategoryItemsEntity>();
List <CategoryItemsEntity> categoryItems2 = new List <CategoryItemsEntity>();
if (item.CategoryItems != null)
{
categoryItems = item.CategoryItems.FindAll(m => m.Type == 4).ToList();
categoryItems2 = item.CategoryItems.FindAll(m => m.Type == 3);
}
ViewBag.plateMarkItems = categoryItems;
ViewBag.Modules = categoryItems2;
if (task.Mark == 11)
{
order.Details = OrdersBusiness.BaseBusiness.GetOrderDetailsByOrderID(task.OrderID);
if (order.Details == null)
{
order.Details = new List <IntFactoryEntity.OrderDetail>();
}
if (order.OrderType == 1)
{
order.OrderAttrs = OrdersBusiness.BaseBusiness.GetOrderArrrsByOrderID(task.OrderID);
}
}
taskModel.Order = order;
//判断查看权限
if (!IsSeeRoot(task, order))
{
Response.Write("<script>alert('您无查看任务权限');location.href='/Task/MyTask';</script>");
Response.End();
}
//任务剩余时间警告
var isWarn = false;
if (task.FinishStatus == 1)
{
if (task.EndTime > DateTime.Now)
{
var totalHour = (task.EndTime - task.AcceptTime).TotalHours;
var residueHour = (task.EndTime - DateTime.Now).TotalHours;
var residue = residueHour / totalHour;
if (residue < 0.333)
{
isWarn = true;
}
}
}
taskModel.IsWarn = isWarn;
//当前用户是否为任务负责人
taskModel.IsTaskOwner = task.OwnerID.Equals(CurrentUser.UserID, StringComparison.OrdinalIgnoreCase) ? true : false;
//当前用户是否有编辑权限
var isEditTask = false;
TaskMember member = task.TaskMembers.Find(a => a.MemberID.ToLower() == CurrentUser.UserID.ToLower());
if (member != null)
{
if (member.PermissionType == 2)
{
isEditTask = true;
}
}
taskModel.IsEditTask = isEditTask;
//订单的品类属性
taskModel.ProductAttr = new IntFactoryEntity.ProductAttr();
//制版任务
if (task.Mark == 12 || task.Mark == 22)
{
taskModel.ProductAttr = new ProductsBusiness().GetTaskPlateAttrByCategoryID(order.CategoryID);
}
//任务完成周期
if (task.FinishStatus == 2)
{
taskModel.FinishDay = (int)Math.Ceiling((task.CompleteTime - task.AcceptTime).TotalDays);
}
//操作权限
taskModel.IsRoot = (task.Status != 8 && (task.FinishStatus == 1 || task.LockStatus == 2) && (taskModel.IsEditTask || taskModel.IsTaskOwner));
ViewBag.TaskModel = taskModel;
return(View());
}
private void OpenSesion()
{
OpenFileDialog openDialog = new OpenFileDialog
{
Filter = @"Xml files (*.xml)|*.xml",
ValidateNames = true,
Multiselect = false,
InitialDirectory = @currentDirectory + @"\Repository"
};
if (openDialog.ShowDialog().Value)
{
if (this._msesion.Path != "")
{
// Preguntar o directamente salvar resultados actuales de la sesion actual
}
this._msesion.Path = openDialog.FileName;
// Open Sesion with the tasks
this._msesion.StartXmlDocument();
XmlNodeList taskNodeList = this._msesion.GetXmlTasks();
foreach (XmlNode taskNode in taskNodeList)
{
Models.TaskModel mtask = new Models.TaskModel(taskNode, this._malgorithms.Algorithms);
this._msesion.AddTask(mtask);
this._tasks.Add(new TaskViewModel(mtask, mtask.NumberImages));
}
}
}
