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