public ActionResult DetailTicket(int id)
{
using (ticketingEntities8 dbModels = new ticketingEntities8())
{
return(View(dbModels.tickets.Where(x => x.ticket_id == id).FirstOrDefault()));
}
}
public ActionResult AddTicket(ticket ticket_model)
{
using (ticketingEntities8 dbModels = new ticketingEntities8())
{
dbModels.tickets.Add(ticket_model);
dbModels.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("AllTicket"));
}
public ActionResult register(TestWebMVC.Models.user userModel)
{
if (ModelState.IsValid)
{
using (ticketingEntities8 dbModels = new ticketingEntities8())
{
dbModels.users.Add(userModel);
dbModels.SaveChanges();
}
ModelState.Clear();
return(View("view_login"));
}
else
{
return(RedirectToAction("register"));
}
}
public ActionResult DeleteTicket(int id, ticket ticket_model)
{
try
{
using (ticketingEntities8 dbModels = new ticketingEntities8())
{
ticket ticketing = dbModels.tickets.Where(x => x.ticket_id == id).FirstOrDefault();
dbModels.tickets.Remove(ticketing);
dbModels.SaveChanges();
}
return(RedirectToAction("AllTicket"));
}
catch
{
return(View());
}
}
public ActionResult verify(TestWebMVC.Models.user userModel)
{
using (ticketingEntities8 db = new ticketingEntities8())
{
var userDetails = db.users.Where(x => x.UserName == userModel.UserName && x.Password == userModel.Password).FirstOrDefault();
if (userDetails == null)
{
return(View("view_login"));
}
else
{
Session["userID"] = userDetails.UserID;
Session["Name"] = userDetails.UserName;
Session["Role"] = userDetails.RoleName;
return(RedirectToAction("Index", "User"));
}
}
}
public ActionResult EditTicket(ticket ticketing)
{
try
{
using (ticketingEntities8 dbModels = new ticketingEntities8())
{
dbModels.Entry(ticketing).State = EntityState.Modified;
dbModels.SaveChanges();
}
return(RedirectToAction("AllTicket"));
}
catch
{
return(View());
}
//return RedirectToAction("AllTicket");
}
public ActionResult AllTicket(string option, string search)
{
using (ticketingEntities8 dbModels = new ticketingEntities8())
{
if (option == "owner")
{
//Index action method will return a view with a student records based on what a user specify the value in textbox
return(View(dbModels.tickets.Where(x => x.ticket_owner.StartsWith(search) || search == null).ToList()));
}
else if (option == "status")
{
return(View(dbModels.tickets.Where(x => x.ticket_status == search || search == null).ToList()));
}
else
{
return(View(dbModels.tickets.Where(x => x.ticket_category == search || search == null).ToList()));
}
return(View(dbModels.tickets.ToList()));
}
}
