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