public async Task <int> Add(Core.Entities.Book entity) { var status_aux = "'Disponivel'"; if (entity.Status == Core.Enums.BookStatus.Indisponivel) { status_aux = "'Indisponivel'"; } string script = @"INSERT INTO Books (Category, Name, Author, Pages, Status) Values (@Category, @Name, @Author, @Pages, " + status_aux + @");"; using (var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"))) { connection.Open(); var response = await connection.ExecuteAsync(script, entity); connection.Close(); return(response); } }
public async Task <int> Update(Core.Entities.Book entity) { var id = entity.Id; var status_aux = "'Disponivel'"; if (entity.Status == Core.Enums.BookStatus.Indisponivel) { status_aux = "'Indisponivel'"; } string script = @"UPDATE Books SET Category = @Category, Name = @Name, Author = @Author, Pages = @Pages, Status = " + status_aux + " WHERE Id = " + id + ";"; using (var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"))) { connection.Open(); var result = await connection.ExecuteAsync(script, entity); connection.Close(); return(result); } }