public HttpResponseMessage getprojectsbyuser(ProjectByUser input)
{
StringBuilder sblogs = new StringBuilder();
string methodname = "getprojectsbyuser";
try
{
//StringBuilder sblogs = new StringBuilder();
sblogs.AppendLine("getprojectsbyuser start");
ProjectUserwrapper root = new ProjectUserwrapper();
root.root = input;
var json = JsonConvert.SerializeObject(root, Formatting.Indented, new JsonSerializerSettings()
{
DateFormatString = "yyyy-MM-ddThh:mm:ssZ"
});
sblogs.AppendLine("getprojectsbyuserid input : " + json);
sblogs.AppendLine("db call started : ");
string result = getprojectsbyuser(json);
sblogs.AppendLine("db call done : ");
objrm.Message = result;
sblogs.AppendLine("data send to UI : ");
Logging.AddtoLogFile(sblogs.ToString(), methodname);
return(Request.CreateResponse(HttpStatusCode.OK, objrm));
}
catch (Exception ex)
{
sblogs.AppendLine("exception : " + ex.Message);
Logging.AddtoLogFile(sblogs.ToString(), methodname + "_error");
return(Request.CreateResponse(HttpStatusCode.OK, ex.Message));
}
}
public List <ProjectByUser> LoadListProjectsForAllUsers()
{
List <ProjectByUser> projectByUsers = new List <ProjectByUser>();
List <UserProject> userProjects = GetListUserProjectsForAllUsers();
foreach (UserProject up in userProjects)
{
Project proj = GetProjectByProjectId(up.ProjectId);
ProjectByUser pbu = new ProjectByUser()
{
UserId = up.UserId,
ProjectId = proj.Id,
ProjectStartDate = proj.StartDate,
TimeToStart = Convert.ToInt32(proj.StartDate.Subtract(up.AssignedDate).TotalDays),
AssignedDate = up.AssignedDate,
ProjectEndDate = proj.EndDate,
Credits = proj.Credits,
Status = up.IsActive ? "Active" : "Inactive"
};
projectByUsers.Add(pbu);
}
return(projectByUsers);
}
public List <ProjectByUser> GetProjectsByUserId(int userId)
{
//var projecUsertList = CastUserProjectToBusiness((from up in context.UserProject where up.UserId == userId select up).ToList());
//var projecUsertIdList = (from up in projecUsertList where up.UserId == userId select up.ProjectId).ToList();
//var projectList = CastProjectToBusinessLayer((from p in context.Project where projecUsertIdList.Contains(p.ID) select p).ToList());
var projectByUser = (from proj in context.Project
join up in context.UserProject on proj.ID equals up.ProjectId
where up.UserId == userId
select new { Project = proj, UserProject = up }).ToList();
var projectDescriptionList = new List <ProjectByUser>();
foreach (var project in projectByUser)
{
ProjectByUser newProjectByUser = new ProjectByUser();
newProjectByUser.ProjectId = project.Project.ID;
newProjectByUser.StartDate = project.Project.StartDate;
newProjectByUser.AssignedDay = project.UserProject.AssignedDate;
newProjectByUser.EndDate = project.Project.EndDate;
newProjectByUser.TimeToStart = (project.Project.StartDate - project.UserProject.AssignedDate).TotalDays < 0 ? "Started" : (project.Project.StartDate - project.UserProject.AssignedDate).TotalDays.ToString();
newProjectByUser.Credits = project.Project.Credits;
newProjectByUser.Status = project.UserProject.IsActive ? "Active" : "Inactive";
projectDescriptionList.Add(newProjectByUser);
}
return(projectDescriptionList);
}
public HttpResponseMessage GetTrashedProjByUserId(ProjectByUser input)
{
ProjectUserwrapper root = new ProjectUserwrapper();
root.root = input;
var json = JsonConvert.SerializeObject(root, Formatting.Indented, new JsonSerializerSettings()
{
DateFormatString = "yyyy-MM-ddThh:mm:ssZ"
});
string result = TrashedProjDetailsByuserId(json);
objrm.Message = result;
return(Request.CreateResponse(HttpStatusCode.OK, objrm));
}
