public static Person AutorizeConfirm(string login, string password)
{
Person person;
using (var ctx = new MusicContext("MusicContext"))
{
person = ctx.Persons.FirstOrDefault(p => p.Login == login);
}
return((person != null && person?.Password == password) ? person : null);
}
public static Person PersonLoginExists(string login)
{
Person person;
using (var ctx = new MusicContext("MusicContext"))
{
person = ctx.Persons.FirstOrDefault(p => p.Login == login);
}
return(person);
}
public static Person PersonEmailExists(string email)
{
Person person;
using (var ctx = new MusicContext("MusicContext"))
{
person = ctx.Persons.FirstOrDefault(p => p.Email == email);
}
return(person);
}
protected override void Seed(MusicContext context)
{
var roles = new List <Role>()
{
new Role()
{
Id = 1, Name = "Admin"
},
new Role()
{
Id = 2, Name = "User"
}
};
roles.ForEach(role => context.Roles.Add(role));
context.SaveChanges();
}
public static void UpdatePassword(Person user)
{
using (var ctx = new MusicContext("MusicContext"))
{
ctx.Persons.Attach(user);
var entry = ctx.Entry(user);
entry.Property(x => x.Password).IsModified = true;
try
{
ctx.SaveChanges();
}
catch (Exception e)
{
throw new Exception();
}
}
}
public static void CreatePerson
(string firstName, string secondName, string login, string email, string password, DateTime dateOfBirth)
{
Person person = new Person()
{
FirstName = firstName,
SecondName = secondName,
Email = email,
Password = password,
Login = login,
DateOfBirth = dateOfBirth
};
using (var ctx = new MusicContext("MusicContext"))
{
ctx.Persons.Add(person);
ctx.SaveChanges();
}
}
