public User GetUserNullable(string email) { Model.ServiceDbContext db = new Model.ServiceDbContext(); User user = db.Users.FirstOrDefault(u => u.Email.Equals(email)); return(user); }
public Comment GetComment(Comment query) { Model.ServiceDbContext db = new Model.ServiceDbContext(); Comment comment = db.Comments.FirstOrDefault(p => p.Id.Equals(query.Id)); if (comment == null) { throw new PostNotFoundException(); } return(comment); }
public IList <User> GetAllUsers(int skip, int amount) { if (amount > 64) { amount = 64; //limit traffic } Model.ServiceDbContext db = new Model.ServiceDbContext(); IQueryable <User> query = db.Users; var pagedQuery = query.OrderBy(u => u.Id).Skip(skip).Take(amount).ToList(); return(pagedQuery); }
public Ad GetAd(string id) { Model.ServiceDbContext db = new Model.ServiceDbContext(); Ad post = db.Ads.Include("Author").Include("Location").Include("Price") .Include("ReservedBy").FirstOrDefault(a => a.Id.Equals(id)); if (post == null) { throw new PostNotFoundException(); } return(post); }
/// <summary> /// Can query users by Email /// </summary> /// <param name="query">A User containing at least Id or Email</param> /// <returns></returns> public User GetUser(string email) { Model.ServiceDbContext db = new Model.ServiceDbContext(); User user = db.Users.FirstOrDefault(u => u.Email.Equals(email)); if (user == null) { throw new UserNotFoundException(); } return(user); }
//Obsolete public IList <Comment> GetComments(int skip, int amount) { if (amount > 64) { amount = 64; } Model.ServiceDbContext db = new Model.ServiceDbContext(); IQueryable <Comment> query = db.Comments; var pagedQuery = query.OrderBy(p => p.DatePosted).Skip(skip).Take(amount).ToList(); return(pagedQuery); }
/// <summary> /// Makes sure we have placeholder locations in the database, if we find out that it's empty. /// </summary> private void SeedLocations() { Model.ServiceDbContext db = new Model.ServiceDbContext(); int count = db.Locations.Count <Location>(); if (count == 0) { MigrationSeed.SeedLocations(); foreach (var location in MigrationSeed.Locations) { RegisterLocation(location.Name, location.Type, location.Parent?.Name); } } }
/// <summary> /// Makes sure we have placeholder users in the database, if we find out that it's empty. /// </summary> private void SeedUsers() { Model.ServiceDbContext db = new Model.ServiceDbContext(); int count = db.Users.Count(); if (count == 0) { MigrationSeed.SeedUsers(); foreach (var user in MigrationSeed.Users) { RegisterUser(user.Name, user.Email, "http://test.com/image.png", "password"); } } }
private void AddUser(User user) { Model.ServiceDbContext db = new Model.ServiceDbContext(); db.Users.Add(user); db.SaveChanges(); }
public int CountUsers() { Model.ServiceDbContext db = new Model.ServiceDbContext(); return(db.Users.Count()); }