public Tickets GetTicketByUser(int Ticket_id)
        {
            if (db == null) { db = new GIRC_DLL.Models.EntityModel(); }

            var ticket      = (from o in db.Tickets orderby o.DateTimeOpen descending where o.id == Ticket_id select o).SingleOrDefault();

            var ticketTexts = (from o in db.TicketTexts orderby o.TextDataAdding descending where o.Ticket == Ticket_id select o).ToList();

            return MapToListUserTicketsBLL(ticket, ticketTexts);
        }

  private Tickets MapToListUserTicketsBLL(GIRC_DLL.Models.Ticket item, IEnumerable<GIRC_DLL.Models.TicketText> tickText)
        {
            Tickets tickets = new Tickets();

            tickets.id = item.id;
            tickets.DateTimeOpen = item.DateTimeOpen.ToString("dd.MM.yyyy HH:mm");
            tickets.Title = item.Title;
            tickets.TicketOpen = item.TicketDecide;

            foreach (var tickText0 in tickText)
            {
                tickets.ticketTextsLst.Add(new TicketTexts { Text = tickText0.Text, TextDateTimeAdding = tickText0.TextDataAdding.ToString("dd.MM.yyyy HH:mm")  }); 
            }
            return tickets;
        } 

    public class Tickets
    {
        public int id { get; set; }

        [Required]
        [StringLength(10, ErrorMessage = "Заголовок новости должен быть как минимум 10 символов")]
        public string Title { get; set; }    
             
        public string DateTimeOpen { get; set; }        
        public string DateTimeClosed { get; set; }


        public List<TicketTexts> ticketTextsLst { get; set; }
     
    }