public URL Get(string shortenedurl)
{
using (var context = new UserUrlDataContext(_connectionString))
{
return(context.URLs.FirstOrDefault(u => u.ShortenedURL == shortenedurl));
}
}
public void IncrementViews(int urlId)
{
using (var context = new UserUrlDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE Urls SET Views = Views + 1 WHERE Id = {0}", urlId);
}
}
public IEnumerable <URL> GetUrlByEmail(string email)
{
using (var context = new UserUrlDataContext(_connectionString))
{
return(context.URLs.Where(u => u.User.Email == email).ToList());
}
}
public URL GetUrl(string email, string url)
{
using (var context = new UserUrlDataContext(_connectionString))
{
return(context.URLs.FirstOrDefault(u => u.User.Email == email && u.RealURL == url));
}
}
public User GetByEmail(string email)
{
using (var context = new UserUrlDataContext(_connectionString))
{
return(context.Users.FirstOrDefault(u => u.Email == email));
}
}
public void AddUrl(URL url)
{
using (var context = new UserUrlDataContext(_connectionString))
{
context.URLs.InsertOnSubmit(url);
context.SubmitChanges();
}
}
public void RegisterUser(User user, string password)
{
string passwordSalt = PasswordHelper.GenerateSalt();
string passwordHash = PasswordHelper.HashPassword(password, passwordSalt);
user.PasswordSalt = passwordSalt;
user.PasswordHash = passwordHash;
using (var context = new UserUrlDataContext(_connectionString))
{
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
}
}
