public List <LateTicket> GetLateTickets() { try { using (ModelLate bdd = new ModelLate()) { return(bdd.LateTicket.ToList()); } } catch { return(new List <LateTicket>()); } }
public Users AuthentificateUser(string login, string password) { using (ModelLate bdd = new ModelLate()) { try { return(bdd.Users.Where(x => x.identifiant == login && x.password == password).ToList().FirstOrDefault()); } catch { return(null); } } }
public Users GetUser(Users user) { using (ModelLate bdd = new ModelLate()) { try { return(bdd.Users.Where(x => x.id == user.id).FirstOrDefault()); } catch { return(null); } } }
public void DeleteCommentary(Commentary commentary) { try { using (ModelLate bdd = new ModelLate()) { bdd.Commentary.Remove(commentary); bdd.SaveChanges(); } } catch { } }
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 void DisLikeLateTicket(UserVote usersLate) { try { using (ModelLate bdd = new ModelLate()) { usersLate.Vote = -1; UserVote late = bdd.UserVote.Add(usersLate); bdd.SaveChanges(); } } catch { } }
public List <Users> GetUsers() { using (ModelLate bdd = new ModelLate()) { try { var test = bdd.Users.ToList(); return(test); } catch { return(null); } } }
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 Users CreateUser(Users users) { using (ModelLate bdd = new ModelLate()) { try { bdd.Users.Add(users); bdd.SaveChanges(); return(users); } catch (Exception e) { return(null); } } }
public Commentary CreateCommentary(Commentary commentary) { try { using (ModelLate bdd = new ModelLate()) { Commentary comment = bdd.Commentary.Add(commentary); bdd.SaveChanges(); return(comment); } } catch { return(null); } }
public UserVote DeleteLinkUserToVote(UserVote vote) { try { using (ModelLate bdd = new ModelLate()) { UserVote link = bdd.UserVote.Remove(vote); bdd.SaveChanges(); return(link); } } 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); } }