public void Update(AuthorEM entity)
{
using (var con = Connection)
{
con.Update(entity);
}
}
public void AddAuthor(AuthorEM author)
{
using (SqlConnection db = new SqlConnection(connectionString))
{
db.Execute("USP_InsertAuthor", new { author.FirstName, author.LastName }, commandType: CommandType.StoredProcedure);
}
}
public void Update(AuthorVM viewModel)
{
using (var authorRepository = Context.Factory.GetService <IAuthorRepository>(Context.RootContext))
{
AuthorEM entityModel = Context.Mapper.MapTo <AuthorEM, AuthorVM>(viewModel);
authorRepository.Update(entityModel);
}
}
public bool UpdateAuthor(AuthorEM author)
{
using (SqlConnection db = new SqlConnection(connectionString))
{
int rowsAffected = db.Execute("USP_UpdateAuthor", new { author.AuthorID, author.FirstName, author.LastName }, commandType: CommandType.StoredProcedure);
return(rowsAffected != 0);
}
}
public long Create(AuthorEM entity)
{
using (var con = Connection)
{
var result = con.Insert(entity);
var converted = (long)Convert.ChangeType(result, typeof(long));
return(converted);
}
}
public void Update(AuthorEM author)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
DynamicParameters sqlParams = new DynamicParameters();
sqlParams.Add("@AuthorId", author.AuthorId, DbType.Int32);
sqlParams.Add("@FirstName", author.FirstName, DbType.String);
sqlParams.Add("@LastName", author.LastName, DbType.String);
db.Query(SP_UPDATE_AUTHOR, sqlParams, null, true, null, CommandType.StoredProcedure);
}
}
public AuthorEM Create(AuthorEM author)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
DynamicParameters sqlParams = new DynamicParameters();
sqlParams.Add("@FirstName", author.FirstName, DbType.String);
sqlParams.Add("@LastName", author.LastName, DbType.String);
author.AuthorId = db.Query <int>(SP_INSERT_AUTHOR, sqlParams, null, true, null, CommandType.StoredProcedure).FirstOrDefault();
}
return(author);
}
public AuthorVM GetById(int id)
{
using (var authorRepository = Context.Factory.GetService <IAuthorRepository>(Context.RootContext))
using (var bookRepository = Context.Factory.GetService <IBookRepository>(Context.RootContext))
{
AuthorEM entityModel = authorRepository.Get(id);
IEnumerable <BookEM> booksEm = bookRepository.GetByAuthor(id);
AuthorVM authorVm = Context.Mapper.MapTo <AuthorVM, AuthorEM>(entityModel);
authorVm.TopBooks = Context.Mapper.MapTo <IEnumerable <BookVM>, IEnumerable <BookEM> >(booksEm);
return(authorVm);
}
}
