public async Task ExecuteAsync(Dependent dependent)
{
using (var dbContext = new DependentDb(_connectionString))
{
//var model = await dbContext.Dependent.AddAsync(dependent);
dbContext.Entry(dependent).State = EntityState.Modified;
await dbContext.SaveChangesAsync();
}
}
public async Task ExecuteAsync(Dependent dependent)
{
using (var dbContext = new DependentDb(_connectionString))
{
var model = await dbContext.Dependent.AddAsync(dependent);
await dbContext.SaveChangesAsync();
}
}
public async Task <Dependent> ExecuteQueryAsync(Guid id)
{
using (var dbContext = new DependentDb(_connectionString))
{
var model = await dbContext.Dependent
.Where(w => w.Id == id)
.FirstOrDefaultAsync();
return(model);
}
}
public async Task <List <Dependent> > ExecuteQueryAsync(Guid employeeId)
{
using (var dbContext = new DependentDb(_connectionString))
{
var model = await dbContext.Dependent
.Where(w => w.EmployeeId == employeeId)
.ToListAsync();
return(model);
}
}
