public TTask[] getUserTasks(User user) { if (String.IsNullOrEmpty(user.Tasks)) { return new TTask[] { } } ; if (!user.Tasks.Contains(",")) { return(new TTask[] { getTaskByID(Int32.Parse(user.Tasks)) }); } string[] nums = user.Tasks.Split(','); List <TTask> result = new List <TTask>(); for (int i = 0; i < nums.Length; i++) { int taskIndex = Int32.Parse(nums[i]); TTask task = db.TTasks.FirstOrDefault(t => t.ID == taskIndex); if (task != null) { result.Add(task); } } return(result.ToArray()); }
protected void Page_Load(object sender, EventArgs e) { if (DB == null) { DB = DBHandler.Instance; } if (Session["selectedTask"] != null) { int taskindex = (int)Session["selectedTask"]; selectedTask = DB.db.TTasks.FirstOrDefault(t => t.ID == taskindex); TaskCreatedByLabel.Text = "Created by " + DB.getUserByID((int)selectedTask.CreatorID).Username; TaskLastEditedByLabel.Text = "Last edited by " + DB.getUserByID((int)selectedTask.LastEditorID).Username + " on " + selectedTask.LastEditedDate; StartDateEndDateLabel.Text = "Should be done in: " + selectedTask.StartDate + " - " + selectedTask.EndDate; TextOfTaskLabel.Text = selectedTask.TextOfTask; if (Session["SharingTaskError"] != null) { SharingTasksError.Text = (string)Session["SharingTaskError"]; } else { SharingTasksError.Text = String.Empty; } } }
void deleteTask(int taskID) { TTask task = DB.db.TTasks.FirstOrDefault(b => b.ID == taskID); if (task != null) { DB.DeleteTask(task.ID); Response.Redirect(Request.RawUrl); } }
protected void SubmitChanges_Click(object sender, EventArgs e) { TTask taskToEdit = new TTask(); if (Session["TaskToEdit"] != null) { taskToEdit = DB.getTaskByID((int)Session["TaskToEdit"]); } else { taskToEdit.ID = DB.getFreeIDForTask(); } taskToEdit.NameOfTask = NameOfTheTaskTB.Text; taskToEdit.TextOfTask = TextOFTheTaskTB.Text; DateTime newStartDate = new DateTime( Int32.Parse(StartTaskYear.Items[StartTaskYear.SelectedIndex].Text), Int32.Parse(StartTaskMonth.Items[StartTaskMonth.SelectedIndex].Text), Int32.Parse(StartTaskDay.Items[StartTaskDay.SelectedIndex].Text)); taskToEdit.StartDate = newStartDate; DateTime newEndDate = new DateTime( Int32.Parse(EndTaskYear.Items[EndTaskYear.SelectedIndex].Text), Int32.Parse(EndTaskMonth.Items[EndTaskMonth.SelectedIndex].Text), Int32.Parse(EndTaskDay.Items[EndTaskDay.SelectedIndex].Text)); taskToEdit.EndDate = newEndDate; taskToEdit.LastEditorID = ((User)Session["LoggerUser"]).ID; taskToEdit.LastEditedDate = DateTime.Now; taskToEdit.AddNewUser((int)taskToEdit.LastEditorID); if (Session["TaskToEdit"] == null) { taskToEdit.CreatorID = taskToEdit.LastEditorID; DB.db.TTasks.Add(taskToEdit); } DB.db.SaveChanges(); if (Session["TaskToEdit"] == null) { DB.getUserByID((int)taskToEdit.LastEditorID).AddNewTask(taskToEdit.ID, (int)taskToEdit.CreatorID); } Session["TaskToEdit"] = null; Response.Redirect("Default.aspx"); }
public void DeleteTask(int taskID) { TTask task = getTaskByID(taskID); User[] usersOfTask = getTasksUser(task); foreach (User us in usersOfTask) { us.DeleteTask(task.ID); } db.TTasks.Remove(task); db.SaveChanges(); }
int getTaskPosFromUser(User user, TTask taskToLook) { TTask[] tasks = getUserTasks(user); for (int i = 0; i < tasks.Length; i++) { if (tasks[i].ID == taskToLook.ID) { return(i); } } return(-1); }
int GetTaskStatusComboBoxIndex(TTask task) { if (task.TaskStatus == "new") { return(0); } else if (task.TaskStatus == "finished") { return(2); } else { return(1); } }
int GetTaskPriorityComboBoxIndex(TTask task) { if (task.TaskPriority == "low") { return(0); } else if (task.TaskPriority == "high") { return(2); } else { return(1); } }
void FillControlsWithDataFormSelectedTask(TTask selectedTask) { TaskNameEditTextBox.Text = selectedTask.TaskName; SelectedTaskContent.Text = selectedTask.TaskContent; PriorityEditComboBox.SelectedIndex = GetTaskPriorityComboBoxIndex(selectedTask); StatusEditComboBox.SelectedIndex = GetTaskStatusComboBoxIndex(selectedTask); if (selectedTask.TaskDate != String.Empty) { TaskDatePicker.SelectedDate = Convert.ToDateTime(selectedTask.TaskDate); } NumberOfCharactersInContentTextBox.Text = "Number of characters: " + SelectedTaskContent.Text.Length.ToString(); SaveChangesButton.IsEnabled = true; NewOrEditTaskInfoTExtBox.Text = "Selected task content:"; SelectedTaskId = selectedTask.Id; }
public int getFreeIDForTask() { int ID = 0; while (true) { TTask task = getTaskByID(ID); if (task == null) { return(ID); } ID++; } }
protected void Page_Load(object sender, EventArgs e) { if (DB == null) { DB = DBHandler.Instance; } EditOrAddLabel.Text = (Session["TaskToEdit"] == null) ? "Add new task" : "Edit task"; SubmitChanges.Text = (Session["TaskToEdit"] == null) ? "Create task" : "Save changes"; for (int i = 1; i <= 31; i++) { StartTaskDay.Items.Add(i.ToString()); EndTaskDay.Items.Add(i.ToString()); } for (int i = 1; i <= 12; i++) { StartTaskMonth.Items.Add(i.ToString()); EndTaskMonth.Items.Add(i.ToString()); } for (int i = DateTime.Now.Year; i <= DateTime.Now.Year + 20; i++) { StartTaskYear.Items.Add(i.ToString()); EndTaskYear.Items.Add(i.ToString()); } if (!IsPostBack) { if (Session["TaskToEdit"] != null) { TTask taskToEdit = DB.getTaskByID((int)Session["TaskToEdit"]); NameOfTheTaskTB.Text = taskToEdit.NameOfTask; TextOFTheTaskTB.Text = taskToEdit.TextOfTask; StartTaskDay.SelectedIndex = EndTaskDay.SelectedIndex = taskToEdit.StartDate.Value.Day; StartTaskMonth.SelectedIndex = EndTaskMonth.SelectedIndex = taskToEdit.StartDate.Value.Month; EndTaskYear.SelectedIndex = StartTaskYear.SelectedIndex = 0; } } }
public User[] getTasksUser(TTask task) { if (task.Users == null) { return new User[] { } } ; string[] nums = task.Users.Split(','); User[] result = new User[nums.Length]; for (int i = 0; i < nums.Length; i++) { int taskIndex = Int32.Parse(nums[i]); result[i] = db.Users.FirstOrDefault(t => t.ID == taskIndex); } return(result); }
private void SaveChangesButton_Click(object sender, RoutedEventArgs e) //event leads to save or update task in database depends on SelectedTaskId { TTask editedTask = new TTask(); editedTask.TaskName = TaskNameEditTextBox.Text; editedTask.TaskContent = SelectedTaskContent.Text; editedTask.TaskStatus = getTaskStatusById(StatusEditComboBox.SelectedIndex); editedTask.TaskPriority = getTaskPriorityById(PriorityEditComboBox.SelectedIndex); editedTask.TaskDate = TaskDatePicker.ToString(); if (SelectedTaskId == 0) { SaveNewTaskInDatabase(editedTask); } else { EditTaskInDatabase(editedTask); } LoadData(); }
public string[] getTaskInfoForTable(TTask task, User user) { string[] taskInfo = new string[9]; taskInfo[0] = task.ID.ToString(); taskInfo[1] = getUserByID((int)task.CreatorID).Username; taskInfo[2] = task.NameOfTask.ToString(); taskInfo[3] = task.TextOfTask.ToString(); taskInfo[4] = task.StartDate.ToString(); taskInfo[5] = task.EndDate.ToString(); taskInfo[6] = getUserByID((int)task.LastEditorID).Username; taskInfo[7] = task.LastEditedDate.ToString(); int taskPos = getTaskPosFromUser(user, task); User us = getUserWhoSharedTask(taskPos, user); taskInfo[8] = us.Username.ToString(); return(taskInfo); }
void EditTaskInDatabase(TTask editedTask) { editedTask.Id = SelectedTaskId; DataService.EditTask(editedTask); }
void SaveNewTaskInDatabase(TTask newTask) { DataService.AddTask(newTask); }
void sentToEditNAddPage(TTask taskToEdit) { Session["TaskToEdit"] = taskToEdit.ID; sentToEditNAddPage(); }