public override async Task <MUser> GetById(int ID)
{
var entity = await _context.Set <User>()
.Where(i => i.UserID == ID)
.Include(i => i.UserRoles)
.SingleOrDefaultAsync();
return(_mapper.Map <MUser>(entity));
}
public override async Task <MTransaction> Insert(TransactionUpsertRequest request)
{
var entity = _mapper.Map <Transaction>(request);
_context.Set <Transaction>().Add(entity);
await _context.SaveChangesAsync();
return(_mapper.Map <MTransaction>(entity));
}
public async Task <MCourseReview> Insert(ReviewUpsertRequest request)
{
var entity = _mapper.Map <UserCourseReview>(request);
_context.Set <UserCourseReview>().Add(entity);
await _context.SaveChangesAsync();
return(_mapper.Map <MCourseReview>(entity));
}
public override async Task <MVideoLecture> Insert(VideoLectureUpsertRequest request)
{
if (await _context.VideoLectures.AnyAsync(i => i.LectureName == request.LectureName))
{
throw new UserException("Lecture with that name already exists!");
}
var entity = _mapper.Map <VideoLecture>(request);
_context.Set <VideoLecture>().Add(entity);
await _context.SaveChangesAsync();
return(_mapper.Map <MVideoLecture>(entity));
}
public override async Task <MCategory> Insert(CategoryUpsertRequest request)
{
if (await _context.Categories.AnyAsync(i => i.Name == request.Name))
{
throw new UserException("Category with that name already exists!");
}
var entity = _mapper.Map <Category>(request);
_context.Set <Category>().Add(entity);
await _context.SaveChangesAsync();
return(_mapper.Map <MCategory>(entity));
}
public override async Task <MSection> Insert(SectionUpsertRequest request)
{
if (await _context.Sections.AnyAsync(i => i.SectionNumber == request.SectionNumber))
{
throw new UserException("Section with that number already exists!");
}
var entity = _mapper.Map <Section>(request);
_context.Set <Section>().Add(entity);
await _context.SaveChangesAsync();
return(_mapper.Map <MSection>(entity));
}
public virtual async Task <TModel> Insert(TInsert request)
{
var entity = _mapper.Map <TDatabase>(request);
_context.Set <TDatabase>().Add(entity);
await _context.SaveChangesAsync();
return(_mapper.Map <TModel>(entity));
}
public virtual async Task <List <TModel> > Get(TSearch search)
{
var list = await _context.Set <TDatabase>().ToListAsync();
return(_mapper.Map <List <TModel> >(list));
}
