public Rating FindByIdEur(int ratingId) { using (var context = new EvenimenteEntities()) { return(context.Ratings.FirstOrDefault(rating => rating.Id == ratingId)); } }
public void Add(Category category) { using (var context = new EvenimenteEntities()) { context.Categories.Add(category); context.SaveChanges(); } }
public void Add(Event eveniment) { using (var context = new EvenimenteEntities()) { context.Events.Add(eveniment); context.SaveChanges(); } }
public void Add(Comment comment) { using (var context = new EvenimenteEntities()) { context.Comments.Add(comment); context.SaveChanges(); } }
public void Add(Picture picture) { using (var context = new EvenimenteEntities()) { context.Pictures.Add(picture); context.SaveChanges(); } }
public void Add(Ticket ticket) { using (var context = new EvenimenteEntities()) { context.Tickets.Add(ticket); context.SaveChanges(); } }
public void Add(Rating rating) { using (var context = new EvenimenteEntities()) { context.Ratings.Add(rating); context.SaveChanges(); } }
public void Add(Role role) { using (var contextEntities = new EvenimenteEntities()) { contextEntities.Roles.Add(role); contextEntities.SaveChanges(); } }
public List <Ticket> GetAll() { using (var context = new EvenimenteEntities()) { var tickets = context.Tickets; if (!tickets.Equals(null)) { return(tickets.ToList()); } } return(null); }
public Picture FindByEventId(int eventId) { using (var context = new EvenimenteEntities()) { var findPicture = context.Pictures.FirstOrDefault(picture => picture.EventId == eventId); if (findPicture != null) { return(findPicture); } throw new Exception("ERROR picture not found"); } }
public Category FindById(int categoryId) { using (var context = new EvenimenteEntities()) { var findCategory = context.Categories.FirstOrDefault(category => category.Id == categoryId); if (findCategory == null) { throw new Exception("Category with this id could not be found"); } return(findCategory); } }
public Comment FindById(int commentId) { using (var context = new EvenimenteEntities()) { var findComment = context.Comments.FirstOrDefault(comment => comment.Id == commentId); if (findComment != null) { return(findComment); } } throw new Exception("ERROR comment not found"); }
public Role FindByName(string name) { using (var contextEntities = new EvenimenteEntities()) { var findRole = contextEntities.Roles.FirstOrDefault(role => role.Name == name); if (findRole != null) { return(findRole); } throw new Exception("ERROR roles not found"); } }
public List <Rating> FindByIdE(int eventId) { using (var context = new EvenimenteEntities()) { var ratings = context.Ratings.Where(rating => rating.EventId == eventId).ToList(); if (!ratings.Equals(null)) { return(ratings); } } throw new Exception("ERROR rating not found");; }
public List <Event> GetAllMinAge(int minAge) { using (var context = new EvenimenteEntities()) { var eventsList = (from eveniment in context.Events let dt = Convert.ToDateTime(eveniment.MinDateBirth) where VerifyAge(dt, minAge) select eveniment).ToList(); if (eventsList.Count < 1) { throw new Exception("No events found"); } return(eventsList); } }
public Event FindById(int eventId) { using (var context = new EvenimenteEntities()) { var findEveniment = context.Events.FirstOrDefault(@event => @event.Id == eventId); if (findEveniment != null) { return(findEveniment); } throw new Exception("ERROR event not found"); } }
public List <Event> GetAll() { using (var context = new EvenimenteEntities()) { var events = context.Events; if (events.ToList().Count > 0) { return(events.ToList()); } throw new Exception("ERROR events not found"); } }
public Ticket FindById(int ticketId) { using (var context = new EvenimenteEntities()) { var findTicket = context.Tickets.FirstOrDefault(ticket => ticket.Id == ticketId); if (findTicket != null) { return(findTicket); } } return(null); }
public List <Comment> FindByEventId(int eventId) { using (var context = new EvenimenteEntities()) { var comments = context.Comments.Where(comment => comment.EventId == eventId).ToList(); if (comments.Count > 0) { return(comments); } } throw new Exception("ERROR comments not found"); }
public List <Comment> GetAll() { using (var context = new EvenimenteEntities()) { var comments = context.Comments; if (!comments.Equals(null)) { return(comments.ToList()); } } throw new Exception("ERROR comments not found"); }
public Role FindById(int roleId) { using (var contextEntities = new EvenimenteEntities()) { var findRole = contextEntities.Roles.FirstOrDefault(role => role.Id == roleId); if (findRole != null) { return(findRole); } } throw new Exception("ERROR role not found"); }
public List <Rating> GetAll() { using (var context = new EvenimenteEntities()) { var ratings = context.Ratings; if (ratings.ToList().Count > 0) { return(ratings.ToList()); } } throw new Exception("ERROR ratings not found"); }
public List <Picture> GetAll() { using (var context = new EvenimenteEntities()) { var pictures = context.Pictures; if (pictures.ToList().Count > 1) { return(pictures.ToList()); } throw new Exception("ERROR pictures not found"); } }
public List <Category> GetAll() { using (var context = new EvenimenteEntities()) { var categories = context.Categories; if (categories.ToList().Count == 0) { throw new Exception("No category could be found"); } return(categories.ToList()); } }
public User FindByUsername(string username) { using (var contextEntities = new EvenimenteEntities()) { var users = contextEntities.Users.FirstOrDefault(userObj => userObj.Username == username); if (users == null) { throw new Exception("User with this username could not be found"); } return(users); } }
public User FindById(int userId) { using (var contextEntities = new EvenimenteEntities()) { var users = contextEntities.Users.FirstOrDefault(user => user.Id == userId); if (users == null) { throw new Exception("User with this id could not be found"); } return(users); } }
public List <User> GetAll() { using (var context = new EvenimenteEntities()) { var users = context.Users; if (users.ToList().Count > 0) { return(users.ToList()); } } throw new Exception("No user could be found"); }
public void Delete(string username) { using (var contextEntities = new EvenimenteEntities()) { var users = contextEntities.Users.FirstOrDefault(user => user.Username == username); if (users == null) { throw new Exception("User with this username could not be found"); } contextEntities.Users.Remove(users); contextEntities.SaveChanges(); } }
public void Delete(int eventId) { using (var context = new EvenimenteEntities()) { var toDeletEveniment = context.Events.FirstOrDefault(@event => @event.Id == eventId); if (toDeletEveniment == null) { return; } context.Events.Remove(toDeletEveniment); context.SaveChanges(); } }
public void Delete(int ticketId) { using (var context = new EvenimenteEntities()) { var toDeleteTicket = context.Tickets.FirstOrDefault(ticket => ticket.Id == ticketId); if (toDeleteTicket == null) { return; } context.Tickets.Remove(toDeleteTicket); context.SaveChanges(); } }