public void Add(Category entity) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Categories VALUES (@CategoryName)")) { cmd.Parameters.AddWithValue("CategoryName", entity.CategoryName); VTYS.SqlExecuteNonQuery(cmd); } }
public void Delete(Book entity) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Books where Id = @Id")) { cmd.Parameters.AddWithValue("Id", entity.Id); VTYS.SqlExecuteNonQuery(cmd); } }
public void Delete(Category entity) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Categories where CategoryId = @CategoryId")) { cmd.Parameters.AddWithValue("Id", entity.CategoryId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Category entity) { using (SqlCommand cmd = new SqlCommand("UPDATE Categories set CategoryId = @CategoryId, CategoryName = @CategoryName, where CategoryId = @CategoryId")) { cmd.Parameters.AddWithValue("CategoryId", entity.CategoryId); cmd.Parameters.AddWithValue("CategoryName", entity.CategoryName); VTYS.SqlExecuteNonQuery(cmd); } }
public void Add(Book entity) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Books (Title,Description, Price, CategoryId) VALUES (@Title,@Description, @Price, @CategoryId)")) { cmd.Parameters.AddWithValue("Title", entity.Title); cmd.Parameters.AddWithValue("Description", entity.Description); cmd.Parameters.AddWithValue("Price", entity.Price); cmd.Parameters.AddWithValue("CategoryId", entity.CategoryId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Book entity) { using (SqlCommand cmd = new SqlCommand("UPDATE Books set Title = @Title, Description = @Description, Price = @Price, CategoryId = @CategoryId where Id = @Id")) { cmd.Parameters.AddWithValue("Id", entity.Id); cmd.Parameters.AddWithValue("Title", entity.Title); cmd.Parameters.AddWithValue("Description", entity.Description); cmd.Parameters.AddWithValue("Price", entity.Price); cmd.Parameters.AddWithValue("CategoryId", entity.CategoryId); VTYS.SqlExecuteNonQuery(cmd); } }