public bool UpdateUser(User user)
{
try
{
using (FSDEntities db = new FSDEntities())
{
var userData = (from p in db.Users
where p.User_Id == user.User_Id
select p).FirstOrDefault();
if (userData != null)
{
userData.First_Name = user.First_Name;
userData.Last_Name = user.Last_Name;
userData.Employee_id = user.Employee_id;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddTask(Task task)
{
using (FSDEntities db = new FSDEntities())
{
if (task.Start_Date != Convert.ToDateTime("01-01-0001 00:00:00"))
{
Task taskManager = new Task();
taskManager.Task_Name = task.Task_Name;
taskManager.Parent_Id = task.Parent_Id;
taskManager.Priority = task.Priority;
taskManager.Start_Date = task.Start_Date;
taskManager.End_Date = task.End_Date;
taskManager.Staus = true;
taskManager.Project_Id = task.Project_Id;
db.Tasks.Add(taskManager);
db.SaveChanges();
}
else
{
Parent_Task parent = new Parent_Task();
parent.Parent_Task1 = task.Task_Name;
db.Parent_Task.Add(parent);
db.SaveChanges();
}
}
return(true);
}
public bool UpdateTask(Task task)
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var taskManager = (from p in db.Tasks
where p.Task_Id == task.Task_Id
select p).FirstOrDefault();
if (taskManager != null)
{
taskManager.Task_Name = task.Task_Name;
taskManager.Parent_Id = task.Parent_Id;
taskManager.Priority = task.Priority;
taskManager.Start_Date = task.Start_Date;
taskManager.End_Date = task.End_Date;
taskManager.Staus = true;
taskManager.Project_Id = task.Project_Id;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool UpdateProject(Project project)
{
try
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var projectData = (from p in db.Projects
where p.Project_Id == project.Project_Id
select p).FirstOrDefault();
if (projectData != null)
{
projectData.Project_Name = project.Project_Name;
projectData.Start_Date = project.Start_Date;
projectData.End_Date = project.End_Date;
projectData.Manager_Id = project.Manager_Id;
projectData.Priority = project.Priority;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddUser(User user)
{
using (FSDEntities db = new FSDEntities())
{
User taskManager = new User();
taskManager.Employee_id = user.Employee_id;
taskManager.First_Name = user.First_Name;
taskManager.Last_Name = user.Last_Name;
db.Users.Add(taskManager);
db.SaveChanges();
}
return(true);
}
public List <User> GetAllUsers()
{
try
{
using (FSDEntities db = new FSDEntities())
{
var userData = (from p in db.Users
select p).ToList();
return(userData);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddProject(Project project)
{
using (FSDEntities db = new FSDEntities())
{
Project projectData = new Project();
projectData.Project_Name = project.Project_Name;
projectData.Start_Date = project.Start_Date;
projectData.End_Date = project.End_Date;
projectData.Manager_Id = project.Manager_Id;
projectData.Priority = project.Priority;
db.Projects.Add(projectData);
db.SaveChanges();
}
return(true);
}
public User GetUsersById(int userId)
{
try
{
using (FSDEntities db = new FSDEntities())
{
var userData = (from p in db.Users
where p.User_Id == userId
select p).FirstOrDefault();
return(userData);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Task GetTaskById(int id)
{
try
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var taskData = (from p in db.Tasks
where p.Task_Id == id
select p).FirstOrDefault();
return(taskData);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <Parent_Task> GetAllParentTask()
{
try
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var taskData = (from p in db.Parent_Task
select p).ToList();
return(taskData);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Project GetProjectById(int projectId)
{
try
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var projectData = (from p in db.Projects
where p.Project_Id == projectId
select p).FirstOrDefault();
return(projectData);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <Task> GetAllTask()
{
try
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var taskData = (from p in db.Tasks
join parent in db.Parent_Task
on p.Parent_Id equals parent.Parent_Id into ps
from parent in ps.DefaultIfEmpty()
select new {
Task_Id = p.Task_Id,
Task_Name = p.Task_Name,
Start_Date = p.Start_Date,
End_Date = p.End_Date,
Priority = p.Priority,
Parent_Name = p.Parent_Id == null ? "No Parent Task Present" : parent.Parent_Task1,
Status = p.Staus,
Project_Name = db.Projects.Where(a => a.Project_Id == p.Project_Id).Select(a => a.Project_Name).FirstOrDefault(),
Project_Id = p.Project_Id
}).ToList().Select(x => new Task()
{
Task_Id = x.Task_Id,
Task_Name = x.Task_Name,
Start_Date = x.Start_Date,
End_Date = x.End_Date,
Priority = x.Priority,
Parent_Name = x.Parent_Name,
Staus = x.Status,
Project_Id = x.Project_Id,
Project_Name = x.Project_Name
});
return(taskData.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <Project> GetAllProjects()
{
try
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var projectData = (from p in db.Projects
//join task in db.Tasks
//on p.Project_Id equals task.Project_Id into ps
//from task in ps.DefaultIfEmpty()
select new
{
Project_Id = p.Project_Id,
Project_Name = p.Project_Name,
Start_Date = p.Start_Date,
End_Date = p.End_Date,
Manager_Id = p.Manager_Id,
Priority = p.Priority,
No_Of_Task = db.Tasks.Where(x => x.Project_Id == p.Project_Id).Count(),
Completed_Task = db.Tasks.Where(x => x.End_Date <= System.DateTime.Now && x.Project_Id == p.Project_Id).Count()
}).ToList().Select(x => new Project()
{
Project_Id = x.Project_Id,
Project_Name = x.Project_Name,
Start_Date = x.Start_Date,
End_Date = x.End_Date,
Manager_Id = x.Manager_Id,
Priority = x.Priority,
No_Of_Task = x.No_Of_Task,
Completed_Task = x.Completed_Task
}).Distinct();
return(projectData.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteUser(int userId)
{
try
{
using (FSDEntities db = new FSDEntities())
{
var userData = (from p in db.Users
where p.User_Id == userId
select p).FirstOrDefault();
db.Users.Remove(userData);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool EndTask(int id)
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var taskData = (from p in db.Tasks
where p.Task_Id == id
select p).FirstOrDefault();
if (taskData != null)
{
taskData.Staus = false;
taskData.End_Date = System.DateTime.Now;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool DeleteProject(int projectId)
{
try
{
using (FSDEntities db = new FSDEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var userData = (from p in db.Projects
where p.Project_Id == projectId
select p).FirstOrDefault();
db.Projects.Remove(userData);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}