public void RemoveTicket(int ticketId)
{
kanbanticket ticketForRemove = _db.kanbantickets.Where(x => x.Id == ticketId).FirstOrDefault();
_db.kanbantickets.Remove(ticketForRemove);
_db.SaveChanges();
}
public void UpdateTicketName(int TicketId, string Name)
{
kanbanticket ticket = GetTicketById(TicketId);
ticket.Name = Name;
_db.SaveChanges();
}
public void UpdateTicketDescription(int TicketId, string Description)
{
kanbanticket ticket = GetTicketById(TicketId);
ticket.Description = Description;
_db.SaveChanges();
}
public ActionResult TicketDetails(int ticketId)
{
kanbanticket ticket = _kanbanService.GetTicketById(ticketId);
return(PartialView("_TicketDetails", ticket));
}
public kanbanticket AddTicket(FormCollection collection, string createdyBy)
{
float highestOrder = 0;
if (_db.kanbantickets.Count() > 0)
{
highestOrder = _db.kanbantickets.Max(x => x.OrderBy);
}
var ticket = new kanbanticket
{
Name = collection["ticketName"],
Description = collection["ticketDescription"],
OrderBy = highestOrder + 1,
CreatedById = createdyBy,
TicketTypeId = int.Parse(collection["ticketType"]),
KanbanPoolListId = int.Parse(collection["poolListId"]),
CreatedDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
DeadlineDate = DateTime.Parse(collection["deadline"])
};
_db.kanbantickets.Add(ticket);
_db.SaveChanges();
if (collection["assignees"] != null)
{
foreach (var userId in collection["assignees"].Split(',').ToList())
{
_db.kanbanticketassignedtoes.Add(new kanbanticketassignedto
{
AssignedToId = userId,
KanbanTicketId = ticket.Id,
AssignedDateTime = DateTime.Now
});
}
}
if (collection["watchers"] != null)
{
foreach (var userId in collection["watchers"].Split(',').ToList())
{
_db.kanbanticketwatchers.Add(new kanbanticketwatcher
{
AssignedDateTime = DateTime.Now,
KanbanTicketId = ticket.Id,
WatcherId = userId
});
}
}
_db.kanbanticketwatchers.Add(new kanbanticketwatcher
{
AssignedDateTime = DateTime.Now,
KanbanTicketId = ticket.Id,
WatcherId = createdyBy
});
foreach (var ticketTypeComponent in GetComponentsForTicketType(ticket.TicketTypeId.Value))
{
_db.kanbanticketcomponents.Add(new kanbanticketcomponent
{
ComponentId = ticketTypeComponent.ComponentId,
TicketId = ticket.Id,
Value = collection[ticketTypeComponent.Name.Replace(" ", "_")].ToString(),
Name = ticketTypeComponent.Name.Replace(" ", "_").ToString()
});
}
_db.SaveChanges();
return(_db.kanbantickets.Include(c => c.kanbantickettype).Include(x => x.kanbanticketcomponents).Where(x => x.Id == ticket.Id).FirstOrDefault());
}
