void PopulateArray(clsDataConnection DB)
{
//populates array list based on the data table in the parameter DB
//var for the index
Int32 Index = 0;
//var to store the record count
Int32 RecordCount;
//get the count of records
RecordCount = DB.Count;
//clear the private array lsit
mBookingsList = new List <clsBookings>();
//while there are records to process
while (Index < RecordCount)
{
//Create a blank booking
clsBookings ABooking = new clsBookings();
ABooking.BookRef = Convert.ToInt32(DB.DataTable.Rows[Index]["BookRef"]);
ABooking.Ammount = Convert.ToDecimal(DB.DataTable.Rows[Index]["Ammount"]);
ABooking.DateBooked = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateBooked"]);
ABooking.PaymentType = Convert.ToString(DB.DataTable.Rows[Index]["PaymentType"]);
//add the records into a private data member
mBookingsList.Add(ABooking);
//point to the next record
Index++;
}
}
public void FilterSurname(string Surname)
{
//filters records based on the primary key
//connect to database
clsDataConnection DB = new clsDataConnection();
//send the bookref to the database
DB.AddParameter("@Surname", Surname);
//execute the stored procedure
DB.Execute("sproc_FiltertblBookingsjoinstblCust");
//populate the array list with the data table
//var for the index
Int32 Index = 0;
//var to store the record count
Int32 RecordCount;
//get the count of records
RecordCount = DB.Count;
//clear the private array lsit
mBookingsList = new List <clsBookings>();
//while there are records to process
while (Index < RecordCount)
{
//Create a blank booking
clsBookings ABooking = new clsBookings();
ABooking.BookRef = Convert.ToInt32(DB.DataTable.Rows[Index]["Book_Ref"]);
ABooking.Ammount = Convert.ToDecimal(DB.DataTable.Rows[Index]["Book_Ammount"]);
ABooking.DateBooked = Convert.ToDateTime(DB.DataTable.Rows[Index]["Book_Date"]);
ABooking.PaymentType = Convert.ToString(DB.DataTable.Rows[Index]["Book_Payment"]);
ABooking.Forename = Convert.ToString(DB.DataTable.Rows[Index]["Forename"]);
ABooking.Surname = Convert.ToString(DB.DataTable.Rows[Index]["surName"]);
//add the records into a private data member
mBookingsList.Add(ABooking);
//point to the next record
Index++;
}
}