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