public void Post([FromBody] Projectset item)
{
Project project = new Project();
project.ProjectName = item.ProjectName;
project.Start_Date = item.Start_Date;
project.End_Date = item.End_Date;
project.Priority = item.Priority;
project.Status = item.Status;
int projectid = pbl.AddProjects(project);
pbl.UpdateUserProjectId(item.User_ID, projectid);
}
public Projectset GetProjectById(int Id)
{
Projectset projectset = new Projectset();
var user = pmdb.Users.Where(x => x.projectId == Id).FirstOrDefault();
projectset = pmdb.Projects.Where(x => x.Project_ID == Id).Select(t => new Projectset()
{
Project_ID = t.Project_ID,
ProjectName = t.ProjectName,
Priority = t.Priority,
Start_Date = t.Start_Date,
End_Date = t.End_Date,
UserName = user.firstName
}).FirstOrDefault();
return(projectset);
}
public int UpdateProject(Projectset Project)
{
int result = -1;
var project = pmdb.Projects.Where(t => t.Project_ID == Project.Project_ID).FirstOrDefault();
if (project != null)
{
project.ProjectName = Project.ProjectName;
project.Priority = Project.Priority;
project.Start_Date = Project.Start_Date;
project.End_Date = Project.End_Date;
project.Status = Project.Status;
result = pmdb.SaveChanges();
}
UpdateUserProjectId(Project.User_ID, Project.Project_ID);
return(result);
}
public void Put([FromBody] Projectset item)
{
pbl.UpdateProject(item);
}
