// Get Assignedto me and my tasks public static dynamic Get(string userid, int pageno) { int skipcount = 10 * pageno; UserDashboardDTO ObjUserDashboardDTO = new UserDashboardDTO(); CustomResponse objres = new CustomResponse(); try { using (var objcontext = new Db_Zon_Test_techsupportEntities()) { ObjUserDashboardDTO.AssignedToMe = (from task in objcontext.Mst_Task join user in objcontext.AspNetUsers on task.AssignedTo equals user.Id join user1 in objcontext.AspNetUsers on task.RefereedTo equals user1.Id where task.AssignedTo == userid select new TaskDTO { Title = task.Title, ID = task.ID, Task_Status = task.Task_Status, Description = task.Description, TaskDisplayName = task.TaskDisplayName, AssignedToName = user.FirstName, RefereedToName = user1.FirstName, PriorityName = task.Mst_TaskPriority.PriorityName, TaskTypeName = task.Mst_TaskType.Type, AssigndedDate = task.AssigndedDate }).ToList(); List <Trans_TicketDTO> ActivityDTO = (from objtrans in objcontext.Trans_Ticket join ticket in objcontext.Mst_Task on objtrans.TaskID equals ticket.ID join userprojects in objcontext.Mst_ProjectUsers on ticket.ProjectID equals userprojects.ProjectID join user2 in objcontext.AspNetUsers on ticket.CreatedBy equals user2.Id where userprojects.UserID == userid select new Trans_TicketDTO { CreatedBy = user2.Email, CreatedDate = objtrans.CreatedDate, TaskID = objtrans.TaskID, DisplayName = ticket.TaskDisplayName, O_Title = objtrans.O_Title, N_Title = objtrans.N_Title, AttachmentName = objtrans.AttachmentName, AttachmentPath = objtrans.AttachmentPath, Comments = objtrans.Comments, O_Description = objtrans.O_Description, O_Task_Status = objtrans.O_Task_Status, N_Description = objtrans.N_Description, N_Task_Statuus = objtrans.N_Task_Statuus }).ToList().OrderByDescending(x => x.TaskID).Skip(skipcount).Take(10).ToList(); // Get Actual Data in place of ids //List<Trans_TicketDTO> NewActivityDTO = new List<Trans_TicketDTO>(); //foreach (Trans_TicketDTO objtransaction in ActivityDTO) //{ // Trans_TicketDTO objtrdto=new Trans_TicketDTO{TaskID=objtransaction.TaskID,DisplayName=objtransaction.DisplayName,AttachmentName=objtransaction.AttachmentName,AttachmentPath=objtransaction.AttachmentPath,Comments=objtransaction.Comments,N_Title=objtransaction.N_Title,O_Title=objtransaction.O_Title,N_Description=objtransaction.N_Description,O_Description=objtransaction.O_Description,CreatedDate=objtransaction.CreatedDate,O_Task_Status=objtransaction.O_Task_Status,N_Task_Statuus=objtransaction.N_Task_Statuus}; // if (objtransaction.CreatedBy !=null) // { // string id = objtransaction.CreatedBy.ToString(); // objtrdto.CreatedBy = objcontext.AspNetUsers.Where(x => x.Id == id).FirstOrDefault().UserName; // } // NewActivityDTO.Add(objtrdto); //} ObjUserDashboardDTO.ActivityDTO = ActivityDTO; objres.Message = "Success"; objres.Response = ObjUserDashboardDTO; objres.Status = CustomResponseStatus.Successful; return(objres); } } catch (Exception ex) { objres.Message = ex.Message; objres.Response = null; objres.Status = CustomResponseStatus.UnSuccessful; return(objres); } }
// GET: Dashboard public ActionResult Dashboard() { DashboardModel objdashboardModel = new DashboardModel(); CustomResponse response = APICalls.Get("UserDashboardAPI/Get?userid=" + User.Identity.GetUserId() + "&pageno=0"); if (response.Status == CustomResponseStatus.Successful) { JavaScriptSerializer serializer1 = new JavaScriptSerializer(); serializer1.MaxJsonLength = 1000000000; var projects = response.Response.ToString(); UserDashboardDTO dbinfo = serializer1.Deserialize <UserDashboardDTO>(projects); return(View(dbinfo)); } return(View()); }
public JsonResult GetActivitiesByPageNo(int pagenumber) { CustomResponse response = APICalls.Get("UserDashboardAPI/Get?userid=" + User.Identity.GetUserId() + "&pageno=" + pagenumber); if (response.Status == CustomResponseStatus.Successful) { JavaScriptSerializer serializer1 = new JavaScriptSerializer(); serializer1.MaxJsonLength = 1000000000; var projects = response.Response.ToString(); UserDashboardDTO dbinfo = serializer1.Deserialize <UserDashboardDTO>(projects); return(Json(dbinfo.ActivityDTO, JsonRequestBehavior.AllowGet)); } else { return(null); } }