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