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 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 override async Task <MUser> Insert(UserUpsertRequest request)
{
if (request.Password != request.PasswordConfirmation)
{
throw new Exception("Passwords do not match!");
}
var entity = _mapper.Map <User>(request);
entity.PasswordSalt = GenerateSalt();
entity.PasswordHash = GenerateHash(entity.PasswordSalt, request.Password);
await _context.Users.AddAsync(entity);
await _context.SaveChangesAsync();
foreach (var roleID in request.Roles)
{
var role = new UserRoles()
{
UserID = entity.UserID,
RoleID = roleID
};
await _context.UserRoles.AddAsync(role);
}
await _context.SaveChangesAsync();
return(_mapper.Map <MUser>(entity));
}
