コード例 #1
0
 public IEnumerable <Category> GetCategories()
 {
     using (var context = new DonationsDataDataContext(_ConnectionString))
     {
         return(context.Categories.ToList());
     }
 }
コード例 #2
0
 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();
     }
 }
コード例 #5
0
 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());
     }
 }
コード例 #7
0
 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);
     }
 }