public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CallTicket           ct        = db.CallTickets.Find(id);
            OpenTicketsViewModel viewModel = new OpenTicketsViewModel();
            Customer             c         = new Customer();

            c = db.Customers.Find(ct.CustID);
            viewModel.CustFirstName = c.CustFirstName;
            viewModel.CustLastName  = c.CustLastName;
            viewModel.CustCompany   = c.CustCompany;
            viewModel.Subject       = ct.Subject;
            viewModel.CallTicketID  = ct.CallTicketID;
            viewModel.Body          = ct.Body;
            ViewBag.CustID          = ct.CustID;
            viewModel.CustPhone     = c.CustPhone;
            if (ct == null)
            {
                return(HttpNotFound());
            }
            return(View(viewModel));
        }
        public ActionResult Index()
        {
            List <OpenTicketsViewModel> viewModelList  = new List <OpenTicketsViewModel>();
            List <Customer>             customerList   = new List <Customer>();
            List <CallTicket>           callTicketList = new List <CallTicket>();

            customerList   = db.Customers.ToList();
            callTicketList = db.CallTickets.ToList();

            foreach (CallTicket ct in callTicketList)
            {
                OpenTicketsViewModel viewModel = new OpenTicketsViewModel();
                Customer             c         = new Customer();
                c = db.Customers.Find(ct.CustID);
                viewModel.CustFirstName = c.CustFirstName;
                viewModel.CustLastName  = c.CustLastName;
                viewModel.CustCompany   = c.CustCompany;
                viewModel.Subject       = ct.Subject;
                viewModel.CallTicketID  = ct.CallTicketID;
                viewModelList.Add(viewModel);
            }

            return(View(viewModelList));
        }