public void DeleteTask(int taskID) { using (var db = new OrganizerDBEntities()) { db.spDeleteTaskByID(taskID); } }
public void InsertUserTask(int userID, int taskID) { using (var db = new OrganizerDBEntities()) { db.spInsertUserTask(Convert.ToString(userID), taskID); } }
public void AddNewTeam(string newTeamName) { using (var db = new OrganizerDBEntities()) { db.spCreateTeam(newTeamName); } }
public void UpdateUsername(string newUsername, int userID) { using (var db = new OrganizerDBEntities()) { db.spUpdateUserNameByID(userID, newUsername); } }
public void UpdatePhoneNumber(string newPhoneNumber, int userID) { using (var db = new OrganizerDBEntities()) { db.spUpdateUserPhone(userID, newPhoneNumber); } }
public void DeleteUser(int userID) { using (var db = new OrganizerDBEntities()) { db.spDeleteUser(userID); } }
public void UpdateUserEmail(string newEmail, int userID) { using (var db = new OrganizerDBEntities()) { db.spUpdateUserEmail(userID, newEmail); } }
public IEnumerable <string> GetAllTeams() { using (var db = new OrganizerDBEntities()) { return(db.spGetAllTeams()); } }
public void UpdateTeam(string updateTeamName, int teamID) { using (var db = new OrganizerDBEntities()) { db.spUpdateTeamByID(updateTeamName, teamID); } }
public void DeleteTeam(int teamID) { using (var db = new OrganizerDBEntities()) { db.spDeleteTeamByID(teamID); } }
public void DeleteTeamTask(int taskID, int teamID) { using (var db = new OrganizerDBEntities()) { db.spDeleteTeamTask(teamID, taskID); } }
public void DeleteUserTeam(int userID, int teamID) { using (var db = new OrganizerDBEntities()) { db.spDeleteUserTeam(Convert.ToString(userID), teamID); } }
public void AddNewTask(TaskDTO newTask) { using (var db = new OrganizerDBEntities()) { db.spCreateTask(newTask.TaskTitle, newTask.TaskSubject, newTask.TaskStartDate, newTask.TaskEndDate, newTask.CreatorID, Convert.ToByte(newTask.TaskPriority), false, false, newTask.TaskCreationDate); } }
public void AddNewUser(UserDTO newUser) { //Add rest of the information using (var db = new OrganizerDBEntities()) { db.spCreateUser(newUser.UserName, newUser.Email); } }
public void UpdateTask(TaskDTO updateTask, int taskID) { using (var db = new OrganizerDBEntities()) { db.spUpdateTaskByID(taskID, updateTask.TaskTitle, updateTask.TaskSubject, updateTask.TaskStartDate, updateTask.TaskEndDate, updateTask.CreatorID, Convert.ToByte(updateTask.TaskPriority), updateTask.IsDeleted, updateTask.IsFinished, updateTask.TaskCreationDate); } }
public TeamDTO GetTeamByID(int teamID) { using (var db = new OrganizerDBEntities()) { string teamName = Convert.ToString(db.team_table.Find(teamID)); TeamDTO objTeamDTO = new TeamDTO(); objTeamDTO = AutoMapper.Mapper.Map <TeamDTO>(teamName); return(objTeamDTO); } }
public List <Task> GetTasks(DateTime?date) { using (var organizerContext = new OrganizerDBEntities()) { var query = from task in organizerContext.Tasks where task.Start == date select task; return(query.ToList()); } }
public UserDTO GetUserByID(int userID) { using (var db = new OrganizerDBEntities()) { var returnedUser = db.AspNetUsers.Find(userID); //Check if user is deleted and throw a message UserDTO objDTOUser = new UserDTO(); objDTOUser = AutoMapper.Mapper.Map <UserDTO>(returnedUser); return(objDTOUser); } }
public int GetId(DateTime?date, string taskTitle) { using (var organizerContext = new OrganizerDBEntities()) { var query = from task in organizerContext.Tasks where task.Start == date && task.Title == taskTitle select task.Id; return(Int32.Parse(query.First().ToString())); } }
public Task GetTaskById(int id) { using (var organizerContext = new OrganizerDBEntities()) { var query = from task in organizerContext.Tasks where task.Id == id select task; return(query.First()); } }
public TaskDTO GetTaskByID(int taskID) { using (var db = new OrganizerDBEntities()) { var returnedTask = db.task_table.Find(taskID); TaskDTO objDTOTask = new TaskDTO(); objDTOTask = AutoMapper.Mapper.Map <TaskDTO>(returnedTask); int a = 0; return(objDTOTask); } }
public void DeleteTask(int id) { using (var organizerContext = new OrganizerDBEntities()) { // fetching a task we will delete var query = from task in organizerContext.Tasks where task.Id == id select task; Task taskToDelete = query.First(); organizerContext.Tasks.Remove(taskToDelete); organizerContext.SaveChanges(); } }
public bool EditTask(int id, EditTaskForm form) { using (var organizerContext = new OrganizerDBEntities()) { // fetching a task we will edit var query = from task in organizerContext.Tasks where task.Id == id select task; Task taskToEdit = query.First(); // assigning new values for the task taskToEdit.IsFinished = form.cbFinish.IsChecked; taskToEdit.Title = form.txtTitle.Text; taskToEdit.Description = form.txtDescription.Text; taskToEdit.Location = form.txtLocation.Text; taskToEdit.Start = (DateTime)form.dpStart.SelectedDate; taskToEdit.Finish = (DateTime)form.dpEnd.DisplayDate; // chech if task with the same title exists for this date var queryCheck = from tsk in organizerContext.Tasks where tsk.Title == taskToEdit.Title && tsk.Start == taskToEdit.Start && tsk.Id != taskToEdit.Id select tsk; if (queryCheck.Count() > 0) { // Configure the message box to be displayed string messageBoxText = "Task with the same title is already created for this day!\n" + "Do you want to create a task with a different title?"; string caption = "Task already exists"; MessageBoxButton button = MessageBoxButton.YesNo; MessageBoxImage icon = MessageBoxImage.Warning; // Display message box MessageBoxResult result = MessageBox.Show(messageBoxText, caption, button, icon); if (result == MessageBoxResult.Yes) { return(false); } else { return(true); } } else { // saving changes organizerContext.SaveChanges(); return(true); } } }
public bool AddTask(Task task) { using (var organizerContext = new OrganizerDBEntities()) { // chech if task with the same title exists for this date var query = from tsk in organizerContext.Tasks where tsk.Title == task.Title && tsk.Start == task.Start select tsk; if (query.Count() > 0) { // Configure the message box to be displayed string messageBoxText = "Task with the same title is already created for this day!\n" + "Do you want to create a task with a different title?"; string caption = "Task already exists"; MessageBoxButton button = MessageBoxButton.YesNo; MessageBoxImage icon = MessageBoxImage.Warning; // Display message box MessageBoxResult result = MessageBox.Show(messageBoxText, caption, button, icon); if (result == MessageBoxResult.Yes) { return(false); } else { return(true); } } else { organizerContext.Tasks.Add(task); organizerContext.SaveChanges(); MessageBox.Show("Task has been added!"); return(true); } } }