public string CreateNewElem([FromBody] TicketsDTO element)
{
if (!ModelState.IsValid)
{
return("Not valid data");
}
try
{
ticketService.Create(element);
return("Created the new element");
}
catch (Exception e)
{
return(e.Message);
}
}
public string UpdateElem(int id, [FromBody] TicketsDTO element)
{
if (!ModelState.IsValid)
{
return("Not valid data");
}
try
{
ticketService.Update(id, element);
return("Updated new elemnt");
}
catch (Exception e)
{
return(e.Message);
}
}
public IHttpActionResult getMyTickets([FromBody] TicketsDTO dTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var lst = (from t in Context.Tickets
where ((dTO.IsMy ? (t.CreatedBy) : (t.AssignedTo)) == dTO.UserID)
orderby(t.TicketId) ascending
select(new Tickets()
{
Title = t.Title,
CreatedBy = t.CreatedBy,
AssignedTo = t.AssignedTo,
Category = t.Category,
CreatedDate = t.CreatedDate.ToString(),
Details = t.Details,
IsHtml = t.IsHtml,
Owner = t.Owner,
Priority = t.Priority,
ProjectId = t.ProjectId,
TicketId = t.TicketId,
TagList = t.TagList,
TicketType = t.TicketType,
TicketStatus = t.TicketStatus
})).Skip(dTO.ItemsPerPage * (dTO.PageNo - 1))
.Take(dTO.ItemsPerPage).ToList();
//var lst = Context.Tickets.Where(t => t.CreatedBy == dTO.UserID || t.AssignedTo == dTO.UserID)
// .OrderBy(t => t.CreatedDate)
// .Skip(dTO.ItemsPerPage * dTO.PageNo)
// .Take(dTO.ItemsPerPage).ToList();
return(Ok(lst));
}
