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