public int UpdateProjectDetails(MODEL.Project project)
{
using (dbContext)
{
var editProjDetails = (from editProject in dbContext.Projects
where editProject.Project_ID.ToString().Contains(project.ProjectId.ToString())
select editProject).First();
// Modify existing records
if (editProjDetails != null)
{
editProjDetails.Project_Name = project.ProjectName;
editProjDetails.Start_Date = project.ProjectStartDate;
editProjDetails.End_Date = project.ProjectEndDate;
editProjDetails.Priority = project.Priority;
}
var editDetails = (from editUser in dbContext.Users
where editUser.User_ID.ToString().Contains(project.User.UserId.ToString())
select editUser).First();
// Modify existing records
if (editDetails != null)
{
editDetails.Project_ID = project.ProjectId;
}
return(dbContext.SaveChanges());
}
}
public int DeleteProjectDetails(MODEL.Project project)
{
using (dbContext)
{
var editDetails = (from proj in dbContext.Projects
where proj.Project_ID == project.ProjectId
select proj).First();
// Delete existing record
if (editDetails != null)
{
dbContext.Projects.Remove(editDetails);
}
return(dbContext.SaveChanges());
}
}
public int InsertProjectDetails(MODEL.Project project)
{
using (dbContext)
{
DAC.Project proj = new DAC.Project()
{
Project_Name = project.ProjectName,
Start_Date = project.ProjectStartDate,
End_Date = project.ProjectEndDate,
Priority = project.Priority
};
dbContext.Projects.Add(proj);
dbContext.SaveChanges();
var editDetails = (from editUser in dbContext.Users
where editUser.User_ID.ToString().Contains(project.User.UserId.ToString())
select editUser).First();
// Modify existing records
if (editDetails != null)
{
editDetails.Project_ID = proj.Project_ID;
}
return(dbContext.SaveChanges());
}
}
