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)); }