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