public int GetUserIdForAd(int adId) { using (var context = new SimpleAdsContext(_connectionString)) { return(context.Ads.FirstOrDefault(a => a.Id == adId).UserId); } }
public User GetByEmail(string email) { using (var context = new SimpleAdsContext(_connectionString)) { return(context.Users.FirstOrDefault(u => u.Email == email)); } }
public bool IsEmailAvailable(string email) { using (var context = new SimpleAdsContext(_connectionString)) { bool isUsed = context.Users.Any(u => u.Email == email); return(!isUsed); } }
public void Delete(int id) { using (var context = new SimpleAdsContext(_connectionString)) { context.Database.ExecuteSqlCommand("DELETE FROM Ads WHERE Id = @id", new SqlParameter("@id", id)); } }
public IEnumerable <SimpleAd> GetAds() { using (var context = new SimpleAdsContext(_connectionString)) { return(context.Ads.Include(a => a.User) .OrderByDescending(a => a.Date).ToList()); } }
public IEnumerable <SimpleAd> GetAdsForUser(int userId) { using (var context = new SimpleAdsContext(_connectionString)) { return(context.Ads .Include(a => a.User) .Where(a => a.UserId == userId).ToList()); } }
public void AddSimpleAd(SimpleAd ad) { ad.Date = DateTime.Now; using (var context = new SimpleAdsContext(_connectionString)) { context.Ads.Add(ad); context.SaveChanges(); } }
public void AddUser(User user, string password) { string hash = BCrypt.Net.BCrypt.HashPassword(password); user.PasswordHash = hash; using (var context = new SimpleAdsContext(_connectionString)) { context.Users.Add(user); context.SaveChanges(); } }