public void Add(Category entity) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Categories(CategoryName) VALUES (@CategoryName)")) { cmd.Parameters.AddWithValue("CategoryName", entity.CategoryName); VTYS.SqlExecuteNonQuery(cmd); } }
public void Delete(Category entity) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Categories WHERE CategoryId = @CategoryId")) { cmd.Parameters.AddWithValue("CategoryId", entity.CategoryId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Delete(Book book) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Books where Id = @Id")) { cmd.Parameters.AddWithValue("Id", book.Id); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Category entity) { using (SqlCommand cmd = new SqlCommand("UPDATE Categories SET CategoryName = @CategoryName WHERE CategoryId = @CategoryId")) { cmd.Parameters.AddWithValue("CategoryName", entity.CategoryName); cmd.Parameters.AddWithValue("CategoryId", entity.CategoryId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Add(Book book) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Books (Title,Description, Year, CategoryId) VALUES (@Title,@Description, @Year, @CategoryId)")) { cmd.Parameters.AddWithValue("Title", book.Title); cmd.Parameters.AddWithValue("Description", book.Description); cmd.Parameters.AddWithValue("Year", book.Year); cmd.Parameters.AddWithValue("CategoryId", book.CategoryId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Book book) { using (SqlCommand cmd = new SqlCommand("UPDATE Books set Title = @Title, Description = @Description, Year = @Year, CategoryId = @CategoryId where Id = @Id")) { cmd.Parameters.AddWithValue("Id", book.Id); cmd.Parameters.AddWithValue("Title", book.Title); cmd.Parameters.AddWithValue("Description", book.Description); cmd.Parameters.AddWithValue("Year", book.Year); cmd.Parameters.AddWithValue("CategoryId", book.CategoryId); VTYS.SqlExecuteNonQuery(cmd); } }
public Category GetById(int id) { Category category = new Category(); SqlCommand cmd = new SqlCommand("SELECT * FROM Categories WHERE CategoryId= @CategoryId"); cmd.Parameters.AddWithValue("CategoryId", id); var reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { category.CategoryId = Convert.ToInt32(reader[0]); category.CategoryName = reader[1].ToString(); } return(category); }
public List <Category> GetAll() { var categoryList = new List <Category>(); SqlCommand cmd = new SqlCommand("SELECT * FROM Categories"); var reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Category category = new Category { CategoryId = Convert.ToInt32(reader[0]), CategoryName = reader[1].ToString() }; categoryList.Add(category); } return(categoryList); }
public List <Book> GetAll() { var bookList = new List <Book>(); SqlCommand cmd = new SqlCommand("Select * from Books"); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Book book = new Book { Id = Convert.ToInt32(reader[0]), Title = reader[1].ToString(), Description = reader[2].ToString(), Year = int.Parse(reader[3].ToString()), CategoryId = Convert.ToInt32(reader[4]) }; bookList.Add(book); } return(bookList); }
public Book GetById(int id) { SqlCommand cmd = new SqlCommand("Select * from Books where Id = @Id"); cmd.Parameters.AddWithValue("Id", id); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Book book = new Book { Id = Convert.ToInt32(reader[0]), Title = reader[1].ToString(), Description = reader[2].ToString(), Year = int.Parse(reader[3].ToString()), CategoryId = Convert.ToInt32(reader[4]) }; return(book); } return(null); }