public void AddUrl(Url url)
{
using (var context = new UrlShortenerDataContext(_connectionString))
{
context.Urls.InsertOnSubmit(url);
context.SubmitChanges();
}
}
public void AddUser(User user, string password)
{
user.PasswordSalt = PasswordHelper.GenerateSalt();
user.PasswordHash = PasswordHelper.HashPassword(password, user.PasswordSalt);
using (var context = new UrlShortenerDataContext(_connectionString))
{
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
}
}
public void IncremementViews(int id)
{
using (var context = new UrlShortenerDataContext(_connectionString))
context.ExecuteCommand("Update Urls Set views = Views + 1 WHERE Id = {0}", id);
}
public Url Check(string Url, string email)
{
using (var context = new UrlShortenerDataContext(_connectionString))
return(context.Urls.FirstOrDefault(u => u.OriginalUrl == Url && u.User.Email == email));
}
public IEnumerable <Url> GetUrls(int id)
{
using (var context = new UrlShortenerDataContext(_connectionString))
return(context.Urls.Where(u => u.UserId == id).ToList()); ;
}
public Url GetOriginal(string shortened)
{
using (var context = new UrlShortenerDataContext(_connectionString))
return(context.Urls.FirstOrDefault(u => u.ShortenedUrl == shortened));
}
public User GetByEmail(string email)
{
using (var context = new UrlShortenerDataContext(_connectionString))
return(context.Users.FirstOrDefault(e => e.Email == email));
}