public ActionResult DeleteReplyAttachment(RequestAttachments requestAttachments) { try { var result = _attachments.DeleteReplyAttachmentByAttachmentIdAgent(requestAttachments.AttachmentsId); if (result > 0) { TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.DeleteTicketReplyAttachment(), ProcessDate = DateTime.Now, TicketId = requestAttachments.TicketId, ActivitiesId = Convert.ToInt16(StatusMain.Activities.DeleteReplyAttachment) }; _ticketHistory.TicketHistory(ticketHistory); return(Json(true, JsonRequestBehavior.AllowGet)); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } } catch (Exception) { throw; } }
public JsonResult ChangeCategory(ChangeCategoryRequestModel changeStatusRequestModel) { try { var result = _tickets.ChangeTicketCategory(changeStatusRequestModel); if (result) { TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.CategoryMessage(changeStatusRequestModel.CategoryId), ProcessDate = DateTime.Now, TicketId = changeStatusRequestModel.TicketId, CategoryId = changeStatusRequestModel.CategoryId, ActivitiesId = Convert.ToInt16(StatusMain.Activities.CategoryChanged) }; _ticketHistory.TicketHistory(ticketHistory); return(Json(true, JsonRequestBehavior.AllowGet)); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } } catch (Exception) { throw; } }
public ActionResult Delete(RequestTicketReplyDeleteViewModel model) { try { if (model.TicketId != null && model.TicketReplyId != null) { var result = _ticketsReply.DeleteTicketReply(model.TicketReplyId, model.TicketId, Convert.ToInt32(_sessionHandler.UserId)); if (result > 0) { TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); var ticketHistory = new TicketHistory(); ticketHistory.UserId = Convert.ToInt32(_sessionHandler.UserId); ticketHistory.Message = ticketHistoryHelper.DeleteTicketReplyMessage(); ticketHistory.ProcessDate = DateTime.Now; ticketHistory.TicketId = model.TicketId; ticketHistory.TicketReplyId = model.TicketReplyId; ticketHistory.ActivitiesId = Convert.ToInt16(StatusMain.Activities.DeleteTicketReply); _ticketHistory.TicketHistory(ticketHistory); } return(Json(true, JsonRequestBehavior.AllowGet)); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } } catch (Exception) { throw; } }
public JsonResult DeleteTicket(string ticketid) { try { if (!string.IsNullOrEmpty(ticketid)) { var result = _iTickets.DeleteTicket(Convert.ToInt64(_sessionHandler.UserId), Convert.ToInt64(ticketid), Convert.ToInt16(StatusMain.Status.Deleted)); if (result > 0) { TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.TicketDelete(), ProcessDate = DateTime.Now, TicketId = Convert.ToInt64(ticketid), ActivitiesId = Convert.ToInt16(StatusMain.Activities.DeleteTicket) }; _ticketHistory.TicketHistory(ticketHistory); } return(Json(new { Result = "OK" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { Result = "ERROR", Message = string.Empty })); } } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = ex.Message })); } }
public void TicketHistory(TicketReplyModel ticketReplyModel, string replied) { try { string message = string.Empty; TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); var ticketHistory = new TicketHistory(); if (!string.IsNullOrEmpty(replied)) { message = ticketHistoryHelper.ReplyMessage(Convert.ToInt16(StatusMain.Status.Replied)); ticketHistory.StatusId = Convert.ToInt16(StatusMain.Status.Replied); } TempData["TicketReplyMessage"] = CommonMessages.TicketSuccessReplyMessages; ticketHistory.UserId = Convert.ToInt32(_sessionHandler.UserId); ticketHistory.Message = message; ticketHistory.ProcessDate = DateTime.Now; ticketHistory.TicketId = ticketReplyModel.TicketId; ticketHistory.ActivitiesId = Convert.ToInt16(StatusMain.Activities.Replied); _ticketHistory.TicketHistory(ticketHistory); } catch (Exception) { throw; } }
public JsonResult RestoreTickets(string[] ticketlist) { try { if (ticketlist.Length != 0) { foreach (var ticketid in ticketlist) { var result = _iTickets.RestoreTicket(Convert.ToInt64(_sessionHandler.UserId), Convert.ToInt64(ticketid)); TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.TicketRestore(), ProcessDate = DateTime.Now, TicketId = Convert.ToInt64(ticketid), ActivitiesId = Convert.ToInt16(StatusMain.Activities.Restored) }; _ticketHistory.TicketHistory(ticketHistory); } return(Json(new { status = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "Fail" })); } } catch (Exception) { return(Json(new { status = "Fail" })); } }
// GET: TicketHistories/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TicketHistory ticketHistory = TicketHistoryHelper.GetTicketHistory(id); if (ticketHistory == null) { return(HttpNotFound()); } return(View(ticketHistory)); }
// GET: TicketHistories/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TicketHistory ticketHistory = TicketHistoryHelper.GetTicketHistory(id); if (ticketHistory == null) { return(HttpNotFound()); } ViewBag.TicketId = new SelectList(TicketHelper.GetTickets(), "Id", "Title", ticketHistory.TicketId); ViewBag.UserId = new SelectList(UserHelper.GetAllUsers(), "Id", "Email", ticketHistory.UserId); return(View(ticketHistory)); }
public ActionResult Edit([Bind(Include = "Id,TicketId,Property,OldValue,NewValue,Changed,UserId")] TicketHistory ticketHistory) { if (ModelState.IsValid) { TicketHistoryHelper.Edit(ticketHistory.Id, ticketHistory.TicketId, ticketHistory.Property, ticketHistory.OldValue, ticketHistory.NewValue, ticketHistory.Changed, ticketHistory.UserId); return(RedirectToAction("Index")); } ViewBag.TicketId = new SelectList(TicketHelper.GetTickets(), "Id", "Title", ticketHistory.TicketId); ViewBag.UserId = new SelectList(UserHelper.GetAllUsers(), "Id", "Email", ticketHistory.UserId); return(View(ticketHistory)); }
public ActionResult Create(TicketsViewModel ticketsViewModel) { try { if (ModelState.IsValid) { if (ticketsViewModel.HiddenUserId == null) { ticketsViewModel.ListofCategory = _category.GetAllActiveSelectListItemCategory(); ticketsViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem(); ticketsViewModel.Message = string.Empty; ModelState.Remove("Message"); TempData["ErrorMessageTicket"] = "Name is AutoComplete field Don't Enter Name Choose."; return(View(ticketsViewModel)); } var file = Request.Files; var generate = new GenerateTicketNo(); var applicationNo = generate.ApplicationNo(_category.GetCategoryCodeByCategoryId(ticketsViewModel.CategoryId)); var tickets = AutoMapper.Mapper.Map <Tickets>(ticketsViewModel); tickets.TicketId = 0; tickets.CreatedDate = DateTime.Now; tickets.TrackingId = applicationNo; tickets.StatusAssigned = false; tickets.InternalUserId = Convert.ToInt64(_sessionHandler.UserId); var message = AppendSignature(ticketsViewModel.Message); var ticketDetails = new TicketDetails() { Subject = ticketsViewModel.Subject, Message = message, TicketDetailsId = 0 }; var attachments = new Attachments(); var attachmentdetails = new AttachmentDetails(); // ReSharper disable once CollectionNeverQueried.Local var listofattachments = new List <Attachments>(); // ReSharper disable once CollectionNeverQueried.Local var listofattachmentdetails = new List <AttachmentDetails>(); for (int i = 0; i <= file.Count - 1; i++) { if (file[i] != null && file[i].ContentLength > 0) { string extension = Path.GetExtension(file[i].FileName); attachments.UserId = Convert.ToInt64(_sessionHandler.UserId); attachments.AttachmentName = file[i].FileName; attachments.AttachmentType = extension; attachments.CreatedDate = DateTime.Now; var inputStream = file[i].InputStream; if (inputStream != null) { using (var binaryReader = new BinaryReader(inputStream)) { byte[] fileSize = binaryReader.ReadBytes(count: file[i].ContentLength); attachmentdetails.AttachmentBytes = fileSize; } } listofattachments.Add(attachments); listofattachmentdetails.Add(attachmentdetails); } } var ticketId = _tickets.AddTickets(ticketsViewModel.HiddenUserId, tickets, ticketDetails, listofattachments, listofattachmentdetails); if (ticketId != -1) { TempData["MessageTicket"] = applicationNo + ' ' + CommonMessages.TicketSuccessMessages; TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); var ticketHistory = new TicketHistory(); ticketHistory.UserId = Convert.ToInt32(_sessionHandler.UserId); ticketHistory.Message = ticketHistoryHelper.CreateMessage(tickets.PriorityId, tickets.CategoryId); ticketHistory.CategoryId = tickets.CategoryId; ticketHistory.PriorityId = tickets.PriorityId; ticketHistory.StatusId = Convert.ToInt16(StatusMain.Status.Open); ticketHistory.ProcessDate = DateTime.Now; ticketHistory.TicketId = ticketId; ticketHistory.ActivitiesId = Convert.ToInt16(StatusMain.Activities.Created); _ticketHistory.TicketHistory(ticketHistory); } else { TempData["ErrorMessageTicket"] = CommonMessages.TicketErrorMessages; } return(RedirectToAction("Create", "TicketHOD")); } else { ticketsViewModel.ListofCategory = _category.GetAllActiveSelectListItemCategory(); ticketsViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem(); return(View(ticketsViewModel)); } } catch (Exception) { throw; } }
public ActionResult EditReply(TicketReplyViewModel ticketReplyViewModel) { try { if (ModelState.IsValid) { int result; var decodemessage = DecodeHtml(ticketReplyViewModel.Message); ticketReplyViewModel.Message = decodemessage; var file = Request.Files; ReplyAttachment replyAttachment = new ReplyAttachment(); ReplyAttachmentDetails replyAttachmentDetails = new ReplyAttachmentDetails(); // ReSharper disable once CollectionNeverQueried.Local var listofattachments = new List <ReplyAttachment>(); // ReSharper disable once CollectionNeverQueried.Local var listofattachmentdetails = new List <ReplyAttachmentDetails>(); if (file.Count > 0) { if (Request.Files["fileupload_1"].ContentLength != 0 || Request.Files["fileupload_2"].ContentLength != 0 || Request.Files["fileupload_3"].ContentLength != 0) { for (int i = 0; i <= file.Count - 1; i++) { if (file[i] != null && file[i].ContentLength > 0) { string extension = Path.GetExtension(file[i].FileName); replyAttachment.SystemUser = Convert.ToInt64(_sessionHandler.UserId); replyAttachment.AttachmentName = file[i].FileName; replyAttachment.AttachmentType = extension; replyAttachment.CreatedDate = DateTime.Now; var inputStream = file[i].InputStream; if (inputStream != null) { using (var binaryReader = new BinaryReader(inputStream)) { byte[] fileSize = binaryReader.ReadBytes(count: file[i].ContentLength); replyAttachmentDetails.AttachmentBytes = fileSize; } } listofattachments.Add(replyAttachment); listofattachmentdetails.Add(replyAttachmentDetails); } } result = _tickets.UpdateTicketReply(ticketReplyViewModel, listofattachments, listofattachmentdetails, null, Convert.ToInt32(_sessionHandler.UserId)); } else { result = _tickets.UpdateTicketReply(ticketReplyViewModel, null, null, null, Convert.ToInt32(_sessionHandler.UserId)); } } else { result = _tickets.UpdateTicketReply(ticketReplyViewModel, null, null, null, Convert.ToInt32(_sessionHandler.UserId)); } TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.EditReplyTicket(), ProcessDate = DateTime.Now, TicketId = ticketReplyViewModel.TicketId, ActivitiesId = Convert.ToInt16(StatusMain.Activities.EditedTicketReply) }; _ticketHistory.TicketHistory(ticketHistory); if (result > 0) { TempData["TicketReplyMessage"] = CommonMessages.TicketUpdatedSuccessReplyMessages; } return(RedirectToAction("Details", "TicketDetailsHOD", new { trackingId = ticketReplyViewModel.TrackingId })); } else { var ticketsViewModel = _tickets.EditTicketsByTicketReplyId(ticketReplyViewModel.TrackingId, ticketReplyViewModel.TicketReplyId); return(View(ticketsViewModel)); } } catch (Exception) { throw; } }
public ActionResult EditTicket(TicketsUserViewModel ticketsViewModel) { try { if (ModelState.IsValid) { if (Request != null && (_attachments.AttachmentsExistbyTicketId(ticketsViewModel.TicketId) && Request.Files["fileupload_1"].ContentLength != 0 && Request.Files["fileupload_2"].ContentLength != 0 && Request.Files["fileupload_3"].ContentLength != 0)) { ModelState.AddModelError("", "Delete Pervious uploaded Attachments for Uploading New Attachments"); ticketsViewModel.HasAttachment = _attachments.CheckAttachmentsExistbyTicketId(ticketsViewModel.TrackingId); ticketsViewModel.ListofCategory = _category.GetAllActiveSelectListItemCategory(); ticketsViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem(); ticketsViewModel.ListofAttachments = _attachments.GetListAttachmentsByAttachmentId(ticketsViewModel.TicketId); return(View(ticketsViewModel)); } else { var attachments = new Attachments(); var attachmentdetails = new AttachmentDetails(); // ReSharper disable once CollectionNeverQueried.Local var listofattachments = new List <Attachments>(); // ReSharper disable once CollectionNeverQueried.Local var listofattachmentdetails = new List <AttachmentDetails>(); if (Request != null && Request.Files.AllKeys.Any()) { var file = Request.Files; if (Request.Files["fileupload_1"].ContentLength != 0 || Request.Files["fileupload_2"].ContentLength != 0 || Request.Files["fileupload_3"].ContentLength != 0) { for (int i = 0; i <= file.Count - 1; i++) { if (file[i] != null && file[i].ContentLength > 0) { string fileName = Path.GetFileName(file[i].FileName); string extension = Path.GetExtension(file[i].FileName); attachments.UserId = Convert.ToInt64(_sessionHandler.UserId); attachments.AttachmentName = fileName; attachments.AttachmentType = extension; attachments.CreatedDate = DateTime.Now; var inputStream = file[i]?.InputStream; if (inputStream != null) { using (var binaryReader = new BinaryReader(inputStream)) { byte[] fileSize = binaryReader.ReadBytes(count: file[i].ContentLength); attachmentdetails.AttachmentBytes = fileSize; } } listofattachments.Add(attachments); listofattachmentdetails.Add(attachmentdetails); } } var message = AppendSignature(ticketsViewModel.Message); ticketsViewModel.Message = message; _tickets.UpdateTickets(ticketsViewModel, listofattachments, listofattachmentdetails); TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.EditTicket(), ProcessDate = DateTime.Now, TicketId = ticketsViewModel.TicketId, ActivitiesId = Convert.ToInt16(StatusMain.Activities.EditedTicket) }; _ticketHistory.TicketHistory(ticketHistory); TempData["TicketReplyMessage"] = CommonMessages.TicketUpdatedSuccessReplyMessages; } else { ticketsViewModel.Message = AppendSignature(ticketsViewModel.Message); _tickets.UpdateTickets(ticketsViewModel, null, null); TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.EditTicket(), ProcessDate = DateTime.Now, TicketId = ticketsViewModel.TicketId }; _ticketHistory.TicketHistory(ticketHistory); TempData["TicketReplyMessage"] = CommonMessages.TicketUpdatedSuccessReplyMessages; } } } } return(RedirectToAction("Details", "TicketDetailsHOD", new { trackingId = ticketsViewModel.TrackingId })); } catch (Exception) { throw; } }
// GET: TicketHistories public ActionResult Index(int ticketId) { return(View(TicketHistoryHelper.GetTicketHistorys(ticketId))); }
public ActionResult DeleteConfirmed(int id) { TicketHistoryHelper.Delete(id); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Title,Description,Created,Updated,ProjectId,TicketTypeId,TicketPriorityId,TicketStatusId,OwnerUserId,AssignToUserId")] Ticket ticket) { if (ModelState.IsValid) { var user = db.Users.Find(User.Identity.GetUserId()); TicketHistoryHelper tickethelper = new TicketHistoryHelper(); ticket.Updated = DateTimeOffset.UtcNow; db.Entry(ticket).State = EntityState.Modified; TicketHistory tickethistory = new TicketHistory(); NotificationHelper notifyHelper = new NotificationHelper(); var oldTicket = db.Tickets.AsNoTracking().First(t => t.Id == ticket.Id); if (oldTicket.AssignToUserId != null) { if (oldTicket.AssignToUserId != ticket.AssignToUserId) { tickethelper.TktAssignUserHistory(ticket, user.Id); notifyHelper.Notify(ticket.AssignToUserId, "BugTracker App Notification", "Your ticket needs attention. " + ticket.Title, true); } } if (oldTicket.Title != ticket.Title) { tickethelper.TktTitleHistory(ticket, user.Id); notifyHelper.Notify(ticket.AssignToUserId, "BugTracker App Notification", "Your ticket needs attention. " + ticket.Title, true); } if (oldTicket.Description != ticket.Description) { tickethelper.TktDescriptionHistory(ticket, user.Id); notifyHelper.Notify(ticket.AssignToUserId, "BugTracker App Notification", "Your ticket needs attention. " + ticket.Title, true); } if (oldTicket.TicketTypeId != ticket.TicketTypeId) { tickethelper.TktTypeIdHistory(ticket, user.Id); notifyHelper.Notify(ticket.AssignToUserId, "BugTracker App Notification", "Your ticket needs attention. " + ticket.Title, true); } if (oldTicket.TicketStatusId != ticket.TicketStatusId) { tickethelper.TktStatusIdHistory(ticket, user.Id); notifyHelper.Notify(ticket.AssignToUserId, "BugTracker App Notification", "Your ticket needs attention. " + ticket.Title, true); } if (oldTicket.TicketPriorityId != ticket.TicketPriorityId) { tickethelper.TktPriorityIdHistory(ticket, user.Id); notifyHelper.Notify(ticket.AssignToUserId, "BugTracker App Notification", "Your ticket needs attention. " + ticket.Title, true); } db.SaveChanges(); ViewBag.AssignToUserId = new SelectList(db.Users, "Id", "FirstName", ticket.AssignToUserId); ViewBag.OwnerUserId = new SelectList(db.Users, "Id", "FirstName", ticket.OwnerUserId); ViewBag.ProjectId = new SelectList(db.Projects, "Id", "Title", ticket.ProjectId); ViewBag.TicketPriorityId = new SelectList(db.TicketPriorities, "Id", "Name", ticket.TicketPriorityId); ViewBag.TicketStatusId = new SelectList(db.TicketStatus, "Id", "Name", ticket.TicketStatusId); ViewBag.TicketTypeId = new SelectList(db.TicketTypes, "Id", "Name", ticket.TicketTypeId); return(RedirectToAction("Details", "Tickets", new { id = ticket.Id })); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Title,Created,Updated,ProjectId,TicketTypeId,TicketPriorityId,TicketStatusId,OwnerUserId,AssignedToUserId")] Ticket ticket) { if (ModelState.IsValid) { var ticketHelper = new TicketHistoryHelper(); var oldTicket = ticketHelper.GetTicketById(ticket.Id); // Assigned to user ticket history if (ticket.AssignedToUserId != oldTicket.AssignedToUserId) { var ticketHistory = new TicketHistory(); var NewAssignedUser = db.Users.FirstOrDefault(u => u.Id == ticket.AssignedToUserId).FirstName; ticketHistory.Changed = DateTime.Now; ticketHistory.NewValue = NewAssignedUser; ticketHistory.Property = "Assigned to"; ticketHistory.TicketId = ticket.Id; ticketHistory.UserId = User.Identity.GetUserId(); db.TicketHistories.Add(ticketHistory); db.SaveChanges(); } var ticketNotification = new TicketNotification(); //var user = db.Roles.FirstOrDefault(r => r.Name == "Developer"); if (ticket.TicketStatusId == db.Ticketstatuses.FirstOrDefault(x => x.Name == "Assigned").Id) { ticketNotification.UserId = ticket.AssignedToUserId; ticketNotification.TicketId = ticket.Id; db.TicketNotifications.Add(ticketNotification); db.SaveChanges(); } // ticket type in ticket history if (ticket.TicketTypeId != oldTicket.TicketTypeId) { var ticketHistory = new TicketHistory(); ticketHistory.Changed = DateTime.Now; ticketHistory.NewValue = db.TicketTypes.Find(ticket.TicketTypeId).Name; ticketHistory.Property = "Ticket Category"; ticketHistory.TicketId = ticket.Id; ticketHistory.UserId = User.Identity.GetUserId(); db.TicketHistories.Add(ticketHistory); db.SaveChanges(); } // ticket priority in ticket history if (ticket.TicketPriorityId != oldTicket.TicketPriorityId) { var ticketHistory = new TicketHistory(); ticketHistory.Changed = DateTime.Now; ticketHistory.NewValue = db.Ticketpriorities.Find(ticket.TicketPriorityId).Name; ticketHistory.Property = "Ticket Priority"; ticketHistory.TicketId = ticket.Id; ticketHistory.UserId = User.Identity.GetUserId(); db.TicketHistories.Add(ticketHistory); db.SaveChanges(); } // ticket status in ticket history if (ticket.TicketStatusId != oldTicket.TicketStatusId) { var ticketHistory = new TicketHistory(); ticketHistory.Changed = DateTime.Now; ticketHistory.NewValue = db.Ticketstatuses.Find(ticket.TicketStatusId).Name; ticketHistory.Property = "Ticket Status"; ticketHistory.TicketId = ticket.Id; ticketHistory.UserId = User.Identity.GetUserId(); db.TicketHistories.Add(ticketHistory); db.SaveChanges(); } ticket.Updated = DateTime.Now; db.Tickets.Attach(ticket); db.Entry(ticket).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AssignedToUserId = new SelectList(db.Users, "Id", "FirstName", ticket.AssignedToUserId); ViewBag.OwnerUserId = new SelectList(db.Users, "Id", "FirstName", ticket.OwnerUserId); ViewBag.ProjectId = new SelectList(db.Projects, "Id", "Name", ticket.ProjectId); ViewBag.TicketPriorityId = new SelectList(db.Ticketpriorities, "Id", "Name", ticket.TicketPriorityId); ViewBag.TicketStatusId = new SelectList(db.Ticketstatuses, "Id", "Name", ticket.TicketStatusId); ViewBag.TicketTypeId = new SelectList(db.TicketTypes, "Id", "Name", ticket.TicketTypeId); return(View(ticket)); }