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