// public constructor for the class
public clsMenuItemCollection()
{
// object for data connection
clsDataConnection DB = new clsDataConnection();
// execute the stored procedure
DB.Execute("sproc_tblMenuItem_SelectAll");
// get the count of records
Int32 RecordCount = DB.Count;
// set up the index for the loop
Int32 Index = 0;
// while there are records to process
while (Index < RecordCount)
{
// create a new instance of the menu class
clsMenuItem AMenuItem = new clsMenuItem();
// get the menu item price
AMenuItem.MenuItemPrice = Convert.ToInt32(DB.DataTable.Rows[Index]["MenuItemPrice"]);
// get the menu item
AMenuItem.MenuItem = DB.DataTable.Rows[Index]["MenuItem"].ToString();
// get the menu item no
AMenuItem.MenuItemNo = Convert.ToInt32(DB.DataTable.Rows[Index]["MenuItemNo"]);
mAllMenuItems.Add(AMenuItem);
Index++;
}
}
void PopulateArray(clsDataConnection DB)
{
Int32 Index = 0;
Int32 RecordCount;
RecordCount = DB.Count;
mAllMenuItems = new List <clsMenuItem>();
while (Index < RecordCount)
{
clsMenuItem AMenuItem = new clsMenuItem();
AMenuItem.MenuItem = Convert.ToString(DB.DataTable.Rows[Index]["MenuItem"]);
AMenuItem.MenuItemNo = Convert.ToInt32(DB.DataTable.Rows[Index]["MenuItemNo"]);
AMenuItem.MenuItemPrice = Convert.ToInt32(DB.DataTable.Rows[Index]["MenuItemPrice"]);
mAllMenuItems.Add(AMenuItem);
Index++;
}
}