public ActionResult DeleteConfirmed(int id)
{
TicketPriorities ticketPriorities = db.TicketPriorities.Find(id);
db.TicketPriorities.Remove(ticketPriorities);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,PriorityName,Description")] TicketPriorities ticketPriorities)
{
if (ModelState.IsValid)
{
db.Entry(ticketPriorities).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketPriorities));
}
/// <summary>
/// Creates a new ticket AND creates a new user as the tickets requester, IF the user does not already exist (based on the requester email).
/// If the requester exists, no user is created and the ticket is created with the existing user as requester
/// </summary>
/// <param name="description"></param>
/// <param name="priority"></param>
/// <param name="requesterName"></param>
/// <param name="requesterEmail"></param>
/// <returns></returns>
public int CreateTicketWithRequester(string description, TicketPriorities priority, string requesterName, string requesterEmail)
{
return
(CreateTicketWithRequester(new Ticket
{
Description = description,
PriorityId = (int)priority,
RequesterName = requesterName,
RequesterEmail = requesterEmail
}));
}
public ActionResult Create([Bind(Include = "Id,PriorityName,Description")] TicketPriorities ticketPriorities)
{
if (ModelState.IsValid)
{
db.TicketPriorities.Add(ticketPriorities);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketPriorities));
}
public int CreateTicket(string description, int requesterId, TicketPriorities priority, string setTags, List<TicketFieldEntry> ticketFields = null)
{
return
CreateTicket(new Ticket
{
Description = description,
RequesterId = requesterId,
PriorityId = (int)priority,
SetTags = setTags,
TicketFieldEntries = ticketFields
});
}
public int CreateTicket(string description, int requesterId, TicketPriorities priority, string setTags, List <TicketFieldEntry> ticketFields = null)
{
return
(CreateTicket(new Ticket
{
Description = description,
RequesterId = requesterId,
PriorityId = (int)priority,
SetTags = setTags,
TicketFieldEntries = ticketFields
}));
}
// GET: TicketPriority/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TicketPriorities ticketPriorities = db.TicketPriorities.Find(id);
if (ticketPriorities == null)
{
return(HttpNotFound());
}
return(View(ticketPriorities));
}
/// <summary>
/// Creates a new ticket AND creates a new user as the tickets requester, IF the user does not already exist (based on the requester email).
/// If the requester exists, no user is created and the ticket is created with the existing user as requester
/// </summary>
/// <param name="description"></param>
/// <param name="priority"></param>
/// <param name="requesterName"></param>
/// <param name="requesterEmail"></param>
/// <returns></returns>
public int CreateTicketWithRequester(string description, TicketPriorities priority, string requesterName, string requesterEmail)
{
return
CreateTicketWithRequester(new Ticket
{
Description = description,
PriorityId = (int)priority,
RequesterName = requesterName,
RequesterEmail = requesterEmail
});
}
private void CreateTestTicket(ApplicationDbContext context)
{
if (!context.Tickets.Any())
{
TicketPriorities priority = context.TicketPriorities.First(p => p.PriorityString == nameof(TicketPrioritiesEnum.Medium));
TicketStatuses status = context.TicketStatuses.First(p => p.StatusString == nameof(TicketStatusesEnum.Open));
TicketTypes type = context.TicketTypes.First(p => p.TypeString == nameof(TicketTypesEnum.Feature));
//! Ran into weird bugs when using ".First()", ".Last()", and ".ElementAt()"
ApplicationUser author = context.Users.First(user => user.Email.ToLower() == "*****@*****.**");
ApplicationUser assignedUser = context.Users.First(user => user.Email.ToLower() == "*****@*****.**");
Project project = author.Projects.FirstOrDefault() ?? context.Projects.First();
TicketAttachment attachment = new TicketAttachment()
{
Description = "testing attachment description",
FilePath = "this is a file path",
FileUrl = "this is a file url",
UserId = author.Id,
};
TicketComment comment = new TicketComment()
{
Comment = "this is a test comment",
UserId = assignedUser.Id,
};
Ticket testTicket = new Ticket()
{
AssignedUser = assignedUser,
AssignedUserId = assignedUser.Id,
Author = author,
AuthorId = author.Id,
Title = "Test Ticket",
Description = "This is a test ticket",
PriorityId = priority.Id,
Priority = priority,
StatusId = status.Id,
Status = status,
TypeId = type.Id,
Type = type,
ProjectId = project.Id,
Project = project,
Attachments = new List <TicketAttachment>()
{
attachment
},
Comments = new List <TicketComment>()
{
comment
},
};
context.Tickets.AddOrUpdate(t => t.Title, testTicket);
}
}
