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