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 List <UsersModel> GetDetails(string searchString)
{
List <UsersModel> usersList;
try
{
using (var context = new TaskManagerDbContext())
{
usersList = (from u in context.Users
where u.FirstName.Contains(searchString) || u.LastName.Contains(searchString)
select new UsersModel()
{
UserId = u.UsersId,
FirstName = u.FirstName,
LastName = u.LastName,
EmployeeId = u.EmployeeId
}).OrderByDescending(a => a.UserId).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(usersList);
}
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 List <TaskModel> GetDetails()
{
List <TaskModel> taskModelList;
try
{
using (var context = new TaskManagerDbContext())
{
taskModelList = (from u in context.Tasks
select new TaskModel()
{
TaskId = u.TaskId,
Task = u.TasksDetail,
ParentTask = u.ParentTask,
EndDate = u.EndDate,
StartDate = u.StartDate,
Priority = u.Priority,
}).OrderByDescending(a => a.TaskId).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(taskModelList);
}
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 List <ProjectModel> GetDetails(string searchProject)
{
List <ProjectModel> projectModel;
try
{
using (var context = new TaskManagerDbContext())
{
projectModel = (from u in context.Projects
where u.Projects.Contains(searchProject)
select new ProjectModel()
{
ProjectId = u.ProjectId,
Projects = u.Projects,
Priority = u.Priority,
StartDate = u.StartDate,
EndDate = u.EndDate,
TotalTask = u.Tasks.ToList().Count(),
Completed = u.Tasks.Where(x => x.Status == "Completed").ToList().Count()
// ManagerId = u.UsersId
}).OrderByDescending(a => a.ProjectId).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(projectModel);
}
public ProjectModel GetDetailsById(int id)
{
ProjectModel projectModel;
try
{
using (var context = new TaskManagerDbContext())
{
var project = context.Projects.Find(id);
var user = project.Users.FirstOrDefault();
projectModel = new ProjectModel()
{
EndDate = project.EndDate,
Priority = project.Priority,
ProjectId = project.ProjectId,
Projects = project.Projects,
StartDate = project.StartDate,
EmployeeName = user != null ? user.FirstName + " " + user.LastName : "",
ManagerId = user != null ? user.UsersId : 0
};
}
}
catch (Exception ex)
{
throw ex;
}
return(projectModel);
}
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 List <ProjectModel> GetDetails()
{
List <ProjectModel> projectModel;
try
{
using (var context = new TaskManagerDbContext())
{
projectModel = (from u in context.Projects
select new ProjectModel()
{
ProjectId = u.ProjectId,
Projects = u.Projects,
Priority = u.Priority,
StartDate = u.StartDate,
EndDate = u.EndDate,
ManagerId = u.ManagerId
}).OrderByDescending(a => a.ProjectId).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(projectModel);
}
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 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 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 List <ParentModel> GetDetails(bool isParent)
{
List <ParentModel> parentTaskList;
try
{
using (var context = new TaskManagerDbContext())
{
parentTaskList = (from u in context.ParentTasks
select new ParentModel()
{
ParentId = u.ParentId,
ParentTaskDetail = u.ParentTaskDetail
}).OrderByDescending(a => a.ParentId).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(parentTaskList);
}
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);
}
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 TaskManagerRepository()
{
context = new TaskManagerDbContext();
}
