public ActionResult Detail(int id)
        {
            // Find the issue detail
            TicketHandler    handler = new TicketHandler(new TicketDataAccess());
            TicketTableModel model   = handler.FindIssues(id);

            return(View(model));
        }
        public TicketTableModel FindIssues(int id)
        {
            TicketTableModel model  = new TicketTableModel();
            TicketResult     result = _issueDataAccess.FindIssue(id);

            model.Id                 = result.Id;
            model.Subject            = result.Subject;
            model.Status             = result.Status;
            model.Priority           = result.Priority;
            model.FixVersion         = result.FixVersion;
            model.Assignee           = result.Assignee;
            model.Estimate           = result.Estimate;
            model.Description        = result.Description;
            model.CompletedTimeStamp = result.CompletedTimeStamp.ToShortDateString();
            model.Reporter           = result.Repoter;
            model.CreatedTimeStamp   = result.CreatedTimeStamp.ToShortDateString();
            return(model);
        }
        public IEnumerable <TicketTableModel> GetTicketTableModel(DateTime startTime, DateTime endTime, int pageNumber, int pageRows)
        {
            List <TicketTableModel>    result          = new List <TicketTableModel>();
            IEnumerable <TicketResult> issueListResult = _issueDataAccess.GetTicketList(startTime, endTime, pageNumber, pageRows);

            TicketTableModel.TotalRows = TicketResult.TotalCount;
            foreach (TicketResult item in issueListResult)
            {
                TicketTableModel model = new TicketTableModel();
                model.Id                 = item.Id;
                model.Subject            = item.Subject;
                model.Status             = item.Status;
                model.Priority           = item.Priority;
                model.FixVersion         = item.FixVersion;
                model.Assignee           = item.Assignee;
                model.Estimate           = item.Estimate;
                model.CompletedTimeStamp = (item.CompletedTimeStamp.Year == 1900) ? "open" : item.CompletedTimeStamp.ToShortDateString();
                model.Reporter           = item.Repoter;
                model.CreatedTimeStamp   = item.CreatedTimeStamp.ToShortDateString();
                result.Add(model);
            }
            return(result);
        }