public IEnumerable <Category> GetCategories() { using (var context = new DonationsDataDataContext(_ConnectionString)) { return(context.Categories.ToList()); } }
public User GetByUserName(string email) { using (var context = new DonationsDataDataContext(_ConnectionString)) { return(context.Users.FirstOrDefault(u => u.Email == email)); } }
public void AplicationAction(int ApplicationId, bool IsAccepted) { using (var context = new DonationsDataDataContext(_ConnectionString)) { context.Applications.FirstOrDefault(a => a.Id == ApplicationId).Approved = IsAccepted; context.SubmitChanges(); } }
public void Add(Application application) { application.Date = DateTime.Now; using (var context = new DonationsDataDataContext(_ConnectionString)) { context.Applications.InsertOnSubmit(application); context.SubmitChanges(); } }
public void Add(User user, string password) { user.Salt = PasswordHelper.GenerateSalt(); user.PasswordHash = PasswordHelper.HashPassword(password, user.Salt); using (var context = new DonationsDataDataContext(_ConnectionString)) { context.Users.InsertOnSubmit(user); context.SubmitChanges(); } }
public IEnumerable <Application> GetApplications() { using (var context = new DonationsDataDataContext(_ConnectionString)) { var loadOptions = new DataLoadOptions(); loadOptions.LoadWith <Application>(a => a.Category); loadOptions.LoadWith <Application>(a => a.User); context.LoadOptions = loadOptions; return(context.Applications.ToList()); } }
public bool IsMatch(string password, string email) { using (var context = new DonationsDataDataContext(_ConnectionString)) { User user = context.Users.FirstOrDefault(u => u.Email == email); if (user != null) { string salt = user.Salt; string passwordHash = user.PasswordHash; return(PasswordHelper.PasswordMatch(password, salt, passwordHash)); } return(false); } }