public BookCatagory GetById(long categotyId)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
BookCatagory instance = null;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "BookCatagoryGetById";
dbCommand = db.GetStoredProcCommand(sqlCommand, categotyId);
// Get results.
using (IDataReader objReader = db.ExecuteReader(dbCommand))
{
while (objReader.Read())
{
instance = instance.ReadReader(objReader);
}
}
return(instance);
}
public List <BookCatagory> GetAll()
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "BookCatagoryGetAll";
dbCommand = db.GetStoredProcCommand(sqlCommand);
List <BookCatagory> objPrdList = new List <BookCatagory>();
using (IDataReader objReader = db.ExecuteReader(dbCommand))
{
while (objReader.Read())
{
BookCatagory obj = new BookCatagory();
objPrdList.Add(obj.ReadReader(objReader));
}
}
return(objPrdList);
}
