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