public async Task <person> GetPersonByName(string name)
{
using (var personDbContext = new MezünKartDbContext())
{
return(await personDbContext.persons.FirstOrDefaultAsync(x => x.name.ToLower() == name.ToLower()));
}
}
public async Task <person> GetPersonById(int id)
{
using (var personDbContext = new MezünKartDbContext())
{
return(await personDbContext.persons.FindAsync(id));
}
}
public async Task <List <person> > GetAllPerson()
{
using (var personDbContext = new MezünKartDbContext())
{
return(await personDbContext.persons.ToListAsync());
}
}
public async Task <person> updatePerson(person Person)
{
using (var personDbContext = new MezünKartDbContext())
{
personDbContext.persons.Update(Person);
await personDbContext.SaveChangesAsync();
return(Person);
}
}
public async Task DeletePerson(int id)
{
using (var personDbContext = new MezünKartDbContext())
{
var deleteperson = await GetPersonById(id);
personDbContext.persons.Remove(deleteperson);
await personDbContext.SaveChangesAsync();
}
}
public async Task <user> login(user User)
{
using (var userdb = new MezünKartDbContext())
{
user a = new user();
a = await userdb.users.FirstOrDefaultAsync(y => y.email.ToLower() == User.email.ToLower());
if (a.email == User.email && a.password == User.password)
{
return(a);
}
else
{
throw new Exception("Email yada Şifre hatalı");
}
}
}
