void PopulateArray(clsDataConnection DB)
{
Int32 Index = 0;
Int32 RecordCount;
RecordCount = DB.Count;
mStaffList = new List <clsStaff>();
while (Index < RecordCount)
{
clsStaff aStaff = new clsStaff();
aStaff.staffId = Convert.ToInt32(DB.DataTable.Rows[Index]["staffId"]);
aStaff.firstName = Convert.ToString(DB.DataTable.Rows[Index]["firstName"]);
aStaff.surname = Convert.ToString(DB.DataTable.Rows[Index]["surname"]);
aStaff.managerOrStaff = Convert.ToBoolean(DB.DataTable.Rows[Index]["managerOrStaff"]);
aStaff.dateOfBirth = Convert.ToDateTime(DB.DataTable.Rows[Index]["dateOfBirth"]);
aStaff.password = Convert.ToString(DB.DataTable.Rows[Index]["password"]);
mStaffList.Add(aStaff);
Index++;
}
}
void PopulateArray(clsDataConnection DB)
{
Int32 Index = 0;
Int32 RecordCount = 0;
RecordCount = DB.Count;
mStockList = new List <clsStaff>();
while (Index < RecordCount)
{
clsStaff AStock = new clsStaff();
AStock.StaffId = Convert.ToInt32(DB.DataTable.Rows[Index]["ProductId"]);
AStock.StaffFirstName = Convert.ToInt32(DB.DataTable.Rows[Index]["InStock"]);
AStock.StockVariants = Convert.ToInt32(DB.DataTable.Rows[Index]["StockVariants"]);
AStock.ProductName = Convert.ToString(DB.DataTable.Rows[Index]["ProductName"]);
AStock.Price = Convert.ToDecimal(DB.DataTable.Rows[Index]["Price"]);
AStock.LastRestockDate = Convert.ToDateTime(DB.DataTable.Rows[Index]["LastRestockDate"]);
AStock.ProductDescription = Convert.ToString(DB.DataTable.Rows[Index]["ProductDescription"]);
mStockList.Add(AStock);
Index++;
}
}
void PopulateArray(clsDataConnection DB)
{
Int32 StaffID = 11312;
Int32 RecordCount;
RecordCount = DB.Count;
mStaffList = new List <clsStaff>();
while (Index < RecordCount)
{
clsStaff AnStaff = new clsStaff();
AnStaff.Admin = Convert.ToBoolean(DB.DataTable.Rows[Index]["Admin"]);
AnStaff.StaffID = Convert.ToInt32(DB.DataTable.Rows[Index]["StaffID"]);
AnStaff.StaffPosition = Convert.ToString(DB.DataTable.Rows[Index]["StaffPosition"]);
AnStaff.Salary = Convert.ToInt32(DB.DataTable.Rows[Index]["Salary"]);
AnStaff.FirstName = Convert.ToString(DB.DataTable.Rows[Index]["FirstName"]);
AnStaff.DateOfBirth = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateOfBirth"]);
mStaffList.Add(AnStaff);
Index++;
}
}
void PopulateArray(clsDataConnection DB)
{
//populate the array list based on the data table in the parameter DB
Int32 Index = 0;
Int32 RecordCount;
RecordCount = DB.Count;
mStaffList = new List <clsStaff>();
while (Index < RecordCount)
{
// create a blank Staff
clsStaff AStaff = new clsStaff();
AStaff.StaffId = Convert.ToInt32(DB.DataTable.Rows[Index]["StaffId"]);
AStaff.FullName = Convert.ToString(DB.DataTable.Rows[Index]["FullName"]);
AStaff.PhoneNumber = Convert.ToString(DB.DataTable.Rows[Index]["PhoneNumber"]);
AStaff.DateOfBirth = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateOfBirth"]);
AStaff.HourlyWage = Convert.ToDouble(DB.DataTable.Rows[Index]["HourlyWage"]);
AStaff.IsWorking = Convert.ToBoolean(DB.DataTable.Rows[Index]["IsWorking"]);
mStaffList.Add(AStaff);
Index++;
}
}
void PopulateArray(clsDataConnection DB)
{
Int32 Index = 0;
Int32 RecordCount;;
RecordCount = DB.Count;
mStaffList = new List <clsStaff>();
while (Index < RecordCount)
{
clsStaff AStaff = new clsStaff();
AStaff.Availability = Convert.ToBoolean(DB.DataTable.Rows[Index]["Availability"]);
AStaff.DateofBirth = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateOfBirth"]);
AStaff.Name = Convert.ToString(DB.DataTable.Rows[Index]["Name"]);
AStaff.Surname = Convert.ToString(DB.DataTable.Rows[Index]["Surname"]);
AStaff.PhoneNumber = Convert.ToString(DB.DataTable.Rows[Index]["PhoneNumber"]);
AStaff.StaffID = Convert.ToInt32(DB.DataTable.Rows[Index]["StaffID"]);
mStaffList.Add(AStaff);
Index++;
}
}
void populateArray(clsDataConnection DB)
{
// Populates the array list based on the data table in the parameter DB.
// Var to store the record count.
Int32 RecordCount = DB.Count;
// Clear the array list.
mStaffList = new List <clsStaff>();
// Iterate through the records.
for (Int32 i = 0; i < RecordCount; i++)
{
// Create a blank address.
clsStaff Staff = new clsStaff();
// Set the fields from the current records.
Staff.StaffID = Convert.ToInt32(DB.DataTable.Rows[i]["StaffID"]);
Staff.StaffName = Convert.ToString(DB.DataTable.Rows[i]["StaffName"]);
Staff.Wage = Convert.ToInt32(DB.DataTable.Rows[i]["Wage"]);
Staff.DateOfBirth = Convert.ToDateTime(DB.DataTable.Rows[i]["DOB"]);
Staff.Email = Convert.ToString(DB.DataTable.Rows[i]["Email"]);
Staff.GrantAccess = Convert.ToBoolean(DB.DataTable.Rows[i]["GrantAccess"]);
// Add the record to the list.
mStaffList.Add(Staff);
}
}