public List <Category> GetAll() { var categoryList = new List <Category>(); SqlCommand cmd = new SqlCommand("Select * from Categories"); SqlDataReader 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 Category Get(int id) { SqlCommand cmd = new SqlCommand("Select * from Categories where Id = @CategoryId"); cmd.Parameters.AddWithValue("CategoryId", id); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Category category = new Category() { CategoryId = Convert.ToInt32(reader[0]), CategoryName = reader[1].ToString(), }; return(category); } return(null); }
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(), Price = Convert.ToDecimal(reader[3]), CategoryId = Convert.ToInt32(reader[4]) }; bookList.Add(book); } return(bookList); }
public Book Get(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(), Price = Convert.ToDecimal(reader[3]), CategoryId = Convert.ToInt32(reader[4]) }; return(book); } return(null); }