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)); }