public IEnumerable <Url> GetUrlsByEmail(string email) { using (var context = new UrlShortenerDataContext(_connectionString)) { return(context.Urls.Where(u => u.User.EmailAddress == email).ToList()); } }
public Url Get(string hash) { using (var context = new UrlShortenerDataContext(_connectionString)) { return(context.Urls.FirstOrDefault(u => u.ShortenedHash.ToLower() == hash.ToLower())); } }
public void IncrementViews(int urlId) { using (var context = new UrlShortenerDataContext(_connectionString)) { context.ExecuteCommand("UPDATE Urls SET Views = Views + 1 WHERE Id = {0}", urlId); } }
public URL Get(string shortUrl) { using (var context = new UrlShortenerDataContext(_connectionstring)) { return(context.URLs.FirstOrDefault(u => u.UrlShort.ToLower() == shortUrl.ToLower())); } }
public URL GetUrl(string userEmail, string url) { using (var context = new UrlShortenerDataContext(_connectionstring)) { return(context.URLs.FirstOrDefault(u => u.User.EmailAddress == userEmail && u.UrlOrig == url)); } }
public User GetByEmail(string email) { using (var context = new UrlShortenerDataContext(_connectionstring)) { return(context.Users.FirstOrDefault(u => u.EmailAddress == email)); } }
public void Add(Url url) { using (var context = new UrlShortenerDataContext(_connectionString)) { context.Urls.InsertOnSubmit(url); context.SubmitChanges(); } }
public void AddUser(User user, string password) { string salt = PasswordHelper.GenerateSalt(); string passwordHash = PasswordHelper.HashPassword(password, salt); user.PasswordSalt = salt; user.PasswordHash = passwordHash; using (var context = new UrlShortenerDataContext(_connectionstring)) { context.Users.InsertOnSubmit(user); context.SubmitChanges(); } }