public User GetByEmail(string email) { using (var context = new URLShortenerDataContext(_connectionString)) { return(context.Users.FirstOrDefault(u => u.Email == email)); } }
public IEnumerable <URL> GetByUser(int userId) { using (var context = new URLShortenerDataContext(_connectionString)) { return(context.URLs.Where(u => u.UserId == userId).ToList()); } }
public URL GetByShortURL(string shortURL) { using (var context = new URLShortenerDataContext(_connectionString)) { return(context.URLs.FirstOrDefault(u => u.ShortURL == shortURL)); } }
public void UpdateViewsCount(int id) { using (var context = new URLShortenerDataContext(_connectionString)) { context.ExecuteCommand("UPDATE URLs SET Views = Views + 1 WHERE Id = {0}", id); } }
public void AddURL(URL u) { using (var context = new URLShortenerDataContext(_connectionString)) { context.URLs.InsertOnSubmit(u); context.SubmitChanges(); } }
public void AddUser(User user, string password) { string passwordSalt = PasswordHelper.GenerateSalt(); string passwordHash = PasswordHelper.HashPassword(password, passwordSalt); user.PasswordSalt = passwordSalt; user.PasswordHash = passwordHash; using (var context = new URLShortenerDataContext(_connectionString)) { context.Users.InsertOnSubmit(user); context.SubmitChanges(); } }