public static void CreateDropDownListViewBag(this ControllerBase controller)
{
using (var db = new AIServiceDataContext())
{
controller.ViewBag.Categories = db.Categories.Select(c => new SelectListItem
{
Value = c.category_id.ToString(),
Text = c.category_description
}).ToList();
controller.ViewBag.Statuses = db.Status.Select(s => new SelectListItem
{
Value = s.status_id.ToString(),
Text = s.status_description
}).ToList();
controller.ViewBag.Users = db.Users.Select(u => new SelectListItem
{
Value = u.user_id.ToString(),
Text = u.user_firstname + " " + u.user_lastname
}).ToList();
controller.ViewBag.Technicians = db.Users.Where(t => t.user_istechnician == true).Select(u => new SelectListItem
{
Value = u.user_id.ToString(),
Text = u.user_firstname + " " + u.user_lastname
}).ToList();
controller.ViewBag.Assets = db.Assets.Select(s => new SelectListItem
{
Value = s.asset_id.ToString(),
Text = s.asset_name
}).ToList();
}
}
//
// GET: /Tickets/Details/1
public ActionResult Details(int id)
{
Ticket ticket = ticketRepository.GetTicket(id);
using (var db = new AIServiceDataContext())
{
db.Categories.Select(c => new SelectListItem
{
Value = c.category_id.ToString(),
Text = c.category_description
}).ToList();
}
if (ticket == null)
{
return(View("NotFound"));
}
else
{
return(View(ticket));
}
}
