// Get Assignedto me and my tasks
public static dynamic Get(string userid, int pageno)
{
int skipcount = 10 * pageno;
ClientDashboardDTO ObjUserDashboardDTO = new ClientDashboardDTO();
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
List <Trans_TicketDTO> ActivityDTO = (from objtrans in objcontext.Trans_Ticket
join ticket in objcontext.Mst_Task on objtrans.TaskID equals ticket.ID
join project in objcontext.Mst_Project on ticket.ProjectID equals project.ID
join user2 in objcontext.AspNetUsers on ticket.CreatedBy equals user2.Id
where project.ClientID == userid
select new Trans_TicketDTO {
CreatedBy = user2.FirstName, 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
}).OrderByDescending(x => x.TaskID).Skip(skipcount).Take(10).Distinct().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;
// }
// //int? tid = objtransaction.TaskID;
// //objtrdto.DisplayName = objcontext.Mst_Task.Where(x => x.ID == tid).FirstOrDefault().TaskDisplayName;
// 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: ClientDashboard
public ActionResult Dashboard()
{
DashboardModel objdashboardModel = new DashboardModel();
ClientDashboardDTO objClientDashboradDTO = new ClientDashboardDTO();
CustomResponse response = APICalls.Get("ClientDashboardAPI/Get?userid=" + User.Identity.GetUserId() + "&pageno=0");
if (response.Status == CustomResponseStatus.Successful)
{
JavaScriptSerializer serializer1 = new JavaScriptSerializer();
serializer1.MaxJsonLength = 1000000000;
var projects = response.Response.ToString();
objClientDashboradDTO = serializer1.Deserialize <ClientDashboardDTO>(projects);
return(View(objClientDashboradDTO));
}
return(Dashboard());
}
