public ActionResult EditTicket(IssueInfo info)
{
using (IssueDbContext db = new IssueDbContext())
{
var result = db.RegisterTickets.SingleOrDefault(u => u.UserId == info.UserId);
if (result != null)
{
result.AssignTo = info.AssignTo;
result.Status = info.Status;
if (info.Status.ToUpper() == "CLOSED")
{
result.ClosedDate = DateTime.Now.ToString();
result.ClosedBy = info.ClosedBy;
}
else
{
result.ClosedDate = "Pending";
result.ClosedBy = "Pending";
}
db.SaveChanges();
}
}
return(RedirectToAction("ViewIssue"));
}
public ActionResult CreateTicket(IssueInfo issueInfo, HttpPostedFileBase img)
{
issueInfo.TicketId = Guid.NewGuid().ToString().Substring(0, 8);
var UserData = Session["users"] as UsersInfo;
issueInfo.Email = UserData.Email;
issueInfo.image = img != null ? img.FileName : "";
if (img != null)
{
using (IssueDbContext db = new IssueDbContext())
{
string path = Path.Combine(Server.MapPath("~/Content/photos"), Path.GetFileName(img.FileName));
img.SaveAs(path);
var result = db.RegisterTickets.Add(issueInfo);
if (result != null)
{
db.SaveChanges();
}
return(View());
}
ViewBag.Message = "TicketId:" + " " + issueInfo.TicketId;
}
return(View());
}
public ActionResult EditTicket(IssueInfo info)
{
using (IssueDbContext db = new IssueDbContext())
{
var result = db.RegisterTickets.SingleOrDefault(u => u.UserId == info.UserId);
if (result != null)
{
result.Status = info.Status;
db.SaveChanges();
}
}
return(RedirectToAction("ViewIssue"));
}
public ActionResult ViewIssue()
{
using (IssueDbContext db = new IssueDbContext())
{
var result = db.RegisterTickets.ToList();
if (result != null)
{
result.Reverse();
return(View(result));
}
}
return(View());
}
public ActionResult ViewIssue()
{
var AdminUser = Session["admin"] as AdminInfo;
if (AdminUser != null)
{
using (IssueDbContext db = new IssueDbContext())
{
var result = db.RegisterTickets.ToList();
if (result != null)
{
result.Reverse();
return(View(result));
}
}
}
return(RedirectToAction("Index", "AdminProfile"));
}
public ActionResult Update(int?id)
{
if (id == null || id == 0)
{
return(RedirectToAction("Inbox", "AdminProfile"));
}
using (IssueDbContext db = new IssueDbContext())
{
var result = db.RegisterTickets.SingleOrDefault(u => u.UserId == id);
if (result == null)
{
return(RedirectToAction("Inbox"));
}
Session["user2"] = result;
}
return(RedirectToAction("EditTicket"));
}
public IssueController(IssueDbContext context)
{
this.context = context;
}
