public LateTicketDTO UpdateLateTicket(LateTicketDTO lateTicket)
{
try
{
LateTicket ticket = _mapper.Map <LateTicket>(lateTicket);
return(_mapper.Map <LateTicketDTO>(_lateDA.UpdateLateTicket(ticket)));
}
catch
{
return(null);
}
}
public List <CommentaryDTO> GetCommentariesTicketLate(LateTicketDTO lateTicket)
{
try
{
LateTicket comment = _mapper.Map <LateTicket>(lateTicket);
return(_mapper.Map <List <CommentaryDTO> >(_lateDA.GetCommentariesTicketLate(comment)));
}
catch
{
return(new List <CommentaryDTO>());
}
}
public List <Commentary> GetCommentariesTicketLate(LateTicket lateTicket)
{
try
{
using (ModelLate bdd = new ModelLate())
{
return(bdd.Database.SqlQuery <Commentary>(String.Format("SELECT * FROM Commentary WHERE idlate = {0}", lateTicket.id)).ToList());
}
}
catch (Exception e)
{
return(new List <Commentary>());
}
}
public int GetCountDisLikeLate(LateTicket ticket)
{
try
{
using (ModelLate bdd = new ModelLate())
{
return(bdd.UserVote.Where(x => x.idlate == ticket.id && x.Vote == -1).Count());
}
}
catch
{
return(-1);
}
}
public LateTicket DeleteLateTicket(LateTicket lateTicket)
{
try
{
using (ModelLate bdd = new ModelLate())
{
LateTicket ticket = bdd.LateTicket.Remove(lateTicket);
bdd.SaveChanges();
return(ticket);
}
}
catch
{
return(null);
}
}
public LateTicket UpdateLateTicket(LateTicket lateTicket)
{
try
{
using (ModelLate bdd = new ModelLate())
{
LateTicket ticket = bdd.LateTicket.Where(x => x.id == lateTicket.id).FirstOrDefault();
ticket.image = lateTicket.image;
ticket.Subject = lateTicket.Subject;
bdd.SaveChanges();
return(ticket);
}
}
catch
{
return(null);
}
}
public int GetCountDisLikeLate(LateTicketDTO ticket)
{
LateTicket late = _mapper.Map <LateTicket>(ticket);
return(_lateDA.GetCountDisLikeLate(late));
}
public int GetCountLikesLate(LateTicketDTO ticket)
{
LateTicket userVote = _mapper.Map <LateTicket>(ticket);
return(_lateDA.GetCountLikesLate(userVote));
}
