private ProjectEntity RetProjectEntity(Project project)
{
ProjectEntity objProject = new ProjectEntity();
objProject.ProjectID = project.ProjectID;
using (var ctx = new ProjectManagerEntities1())
{
var projIDParam = new SqlParameter("@ProjectID", project.ProjectID);
var UserID = ctx.Database.SqlQuery <ProjectEntity>(
"exec GetUserID @ProjectID", projIDParam).ToList <ProjectEntity>();
if (UserID != null & UserID.Count > 0)
{
objProject.ManagerID = Convert.ToInt32(UserID[0].ManagerID);
objProject.ManagerName = db.Users.Where(x => x.UserID == objProject.ManagerID).First().FirstName;
}
}
objProject.ProjectTitle = project.ProjectTitle;
objProject.StartDate = project.StartDate;
objProject.Priority = project.Priority;
objProject.Completed = project.Completed;
objProject.EndDate = project.EndDate;
objProject.TotalTasks = db.Tasks.Where(x => x.ProjectID == project.ProjectID).Count();
objProject.CompletedTasks = db.Tasks.Where(x => x.ProjectID == project.ProjectID && x.Completed == true).Count();
return(objProject);
}
public bool UpdateProject(TaskEntity task)
{
using (var ctx = new ProjectManagerEntities1())
{
var taskIDParam = new SqlParameter("@TaskID", task.TaskID);
var projectIDParam = new SqlParameter("@ProjectID", task.ProjectID);
var Project = ctx.Database.SqlQuery <ProjectEntity>(
"exec UpdateProject @TaskID,@ProjectID", taskIDParam, projectIDParam).ToList <ProjectEntity>();
}
return(true);
}
public bool UpdateUser(TaskEntity task)
{
using (var ctx = new ProjectManagerEntities1())
{
var userIDParam = new SqlParameter("@UserID", task.UserID);
var taskIDParam = new SqlParameter("@TaskID", task.TaskID);
var Project = ctx.Database.SqlQuery <ProjectEntity>(
"exec UpdateUserIDforTask @UserID,@TaskID", userIDParam, taskIDParam).ToList <ProjectEntity>();
}
return(true);
}
public bool UpdateUser(ProjectEntity project)
{
using (var ctx = new ProjectManagerEntities1())
{
var userIDParam = new SqlParameter("@UserID", project.ManagerID);
var projIDParam = new SqlParameter("@ProjectID", project.ProjectID);
var Project = ctx.Database.SqlQuery <ProjectEntity>(
"exec UpdateUser @UserID,@ProjectID", userIDParam, projIDParam).ToList <ProjectEntity>();
}
return(true);
}
public UserBL(ProjectManagerAPI.Datalayer.ProjectManagerEntities1 context)
{
dbcontext = context;
}
public UserBL()
{
dbcontext = new ProjectManagerAPI.Datalayer.ProjectManagerEntities1();
}
