public bool DeleteById(int id)
{
try
{
using (var context = new TaskManagerDbContext())
{
var taskModel = context.Tasks.Find(id);
if (taskModel == null)
{
return(false);
}
var user = context.Users.FirstOrDefault(x => x.TaskId == taskModel.TaskId);
if (user != null)
{
user.TaskId = null;
user.Tasks = null;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
context.Tasks.Remove(taskModel);
context.Entry(taskModel).State = EntityState.Deleted;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public bool Insert(ProjectModel userModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
var project = new Project()
{
Projects = userModel.Projects,
Priority = userModel.Priority,
// ManagerId = userModel.ManagerId,
StartDate = userModel.StartDate,
EndDate = userModel.EndDate,
//Users = userModel.
};
context.Projects.Add(project);
context.SaveChanges();
var user = context.Users.Find(userModel.ManagerId);
user.ProjectId = project.ProjectId;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex.InnerException;
}
}
public bool Update(UsersModel userTaskModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
var taskModel = (from c in context.Users
where c.UsersId == userTaskModel.UserId
select c).FirstOrDefault();
if (taskModel == null)
{
return(false);
}
taskModel.FirstName = userTaskModel.FirstName;
taskModel.LastName = userTaskModel.LastName;
taskModel.EmployeeId = userTaskModel.EmployeeId;
context.Users.Add(taskModel);
context.Entry(taskModel).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public bool Update(TaskModel userTaskModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
var taskModel = (from c in context.Tasks
where c.TaskId == userTaskModel.TaskId
select c).FirstOrDefault();
if (taskModel == null)
{
return(false);
}
taskModel.TasksDetail = userTaskModel.Task;
taskModel.Priority = userTaskModel.Priority;
taskModel.StartDate = userTaskModel.StartDate;
taskModel.StartDate = userTaskModel.EndDate;
taskModel.Status = userTaskModel.Status;
context.Tasks.Add(taskModel);
context.Entry(taskModel).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public bool Insert(TaskModel userTaskModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
var userTask = new Task()
{
ParentTask = userTaskModel.ParentTask,
TasksDetail = userTaskModel.Task,
StartDate = userTaskModel.StartDate,
EndDate = userTaskModel.EndDate,
Priority = userTaskModel.Priority,
Status = userTaskModel.Status
};
context.Tasks.Add(userTask);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex.InnerException;
}
}
public bool Update(ProjectModel userTaskModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
var projectModel = (from c in context.Projects
where c.ProjectId == userTaskModel.ProjectId
select c).FirstOrDefault();
if (projectModel == null)
{
return(false);
}
projectModel.Projects = userTaskModel.Projects;
projectModel.Priority = userTaskModel.Priority;
projectModel.ManagerId = userTaskModel.ManagerId;
projectModel.StartDate = userTaskModel.StartDate;
projectModel.EndDate = userTaskModel.EndDate;
context.Projects.Add(projectModel);
context.Entry(projectModel).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public bool Insert(TaskModel userTaskModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
if (userTaskModel.IsParent)
{
var parentTask = new Parent()
{
ParentTaskDetail = userTaskModel.Task
};
context.ParentTasks.Add(parentTask);
context.SaveChanges();
return(true);
}
else
{
var userTask = new Task()
{
ParentId = userTaskModel.ParentTaskId,
TasksDetail = userTaskModel.Task,
StartDate = userTaskModel.StartDate,
EndDate = userTaskModel.EndDate,
Priority = userTaskModel.Priority,
ProjectId = userTaskModel.ProjectId,
Status = userTaskModel.Status,
// UsersId = userTaskModel.UserId
};
context.Tasks.Add(userTask);
context.SaveChanges();
var user = context.Users.Find(userTaskModel.UserId);
user.TaskId = userTask.TaskId;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception ex)
{
throw ex.InnerException;
}
}
public bool Insert(UsersModel userModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
var user = new Users()
{
FirstName = userModel.FirstName,
LastName = userModel.LastName,
EmployeeId = userModel.EmployeeId
};
context.Users.Add(user);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex.InnerException;
}
}
public bool Insert(UserTaskModel userTaskModel)
{
try
{
var UT = new UserTask()
{
ParentTask_ID = userTaskModel.ParentTask_ID,
TaskDetail = userTaskModel.TaskDetail,
StartDate = userTaskModel.StartDate,
EndDate = userTaskModel.EndDate,
Priority = userTaskModel.Priority,
Status = userTaskModel.Status
};
context.UserTasks.Add(UT);
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex.InnerException;
}
}
public bool DeleteById(int id)
{
try
{
using (var context = new TaskManagerDbContext())
{
var taskModel = (from c in context.Users
where c.UsersId == id
select c).FirstOrDefault();
if (taskModel == null)
{
return(false);
}
context.Users.Remove(taskModel);
context.Entry(taskModel).State = EntityState.Deleted;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public bool Insert(ProjectModel userModel)
{
try
{
using (var context = new TaskManagerDbContext())
{
var project = new Project()
{
Projects = userModel.Projects,
Priority = userModel.Priority,
ManagerId = userModel.ManagerId,
StartDate = userModel.StartDate,
EndDate = userModel.EndDate,
};
context.Projects.Add(project);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex.InnerException;
}
}
public bool Update(int taskId)
{
try
{
using (var context = new TaskManagerDbContext())
{
var task = context.Tasks.Find(taskId);
if (task == null)
{
return(false);
}
task.Status = "Completed";
context.Tasks.Add(task);
context.Entry(task).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}