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); } }