public Student MapColumnData(string colName, object data, Student student)
{
if (data != null)
{
switch (colName)
{
case "name": //string
student.Name = (string)data;
break;
case "age": // int
student.Age = (int)data;
break;
case "gender": //string
student.Gender = (string)data;
break;
case "dob": //datetime
student.DOB = (DateTime)data;
break;
case "outstandingfee": //double
student.OutStandingFee = (double)data;
break;
default:
break;
}
}
return student;
}
/// <summary>
/// Creates a list of Student objects that will be loaded into database
/// </summary>
private void BuildStudentList()
{
Student s1 = new Student();
s1.Name = "joe";
s1.Gender = "m";
s1.Age = 21;
s1.DOB = DateTime.Now.AddYears(-21);
s1.OutStandingFee = 1223.56;
Student s2 = new Student();
s2.Name = "tim";
s2.Gender = "m";
s2.Age = 22;
s2.DOB = DateTime.Now.AddYears(-22);
s2.OutStandingFee = 3070.22;
Student s3 = new Student();
s3.Name = "mia";
s3.Gender = "f";
s3.Age = 20;
s3.DOB = DateTime.Now.AddYears(-22);
s3.OutStandingFee = 2999.10;
Student s4 = new Student();
s4.Name = "tara";
s4.Gender = "f";
s4.Age = 19;
s4.DOB = DateTime.Now.AddYears(-19);
s4.OutStandingFee = 1500.00;
Student s5 = new Student();
s5.Name = "sam";
s5.Gender = "m";
s5.Age = 23;
s5.DOB = DateTime.Now.AddYears(-23);
s5.OutStandingFee = 1750.26;
Student s6 = new Student();
s6.Name = "jim";
s6.Gender = "m";
s6.Age = 24;
s6.DOB = DateTime.Now.AddYears(-23);
s6.OutStandingFee = 1223.32;
Student s7 = new Student();
s7.Name = "bob";
s7.Gender = "m";
s7.Age = 24;
s7.DOB = DateTime.Now.AddYears(-23);
s7.OutStandingFee = 346.23;
_studentNames.Add(s1);
_studentNames.Add(s2);
_studentNames.Add(s3);
_studentNames.Add(s4);
_studentNames.Add(s5);
_studentNames.Add(s6);
_studentNames.Add(s7);
}
private void MapReturnedData(c.Flip flipData)
{
ReturnedStudentData.Clear();
int rows = _queries.GetNumberOfRows(flipData);
string[] colNames = _queries.GetColumnNames(flipData);
for (int a = 0; a < rows; a++)
{
Student student = new Student();
for (int col = 0; col < colNames.Length; col++)
{
string colname = colNames[col];
object data = c.at(flipData.y[col], a);
student.MapColumnData(colname, data, student);
}
ReturnedStudentData.Add(student);
}
}
/// <summary>
/// Creates a list of ages that are displayed in a grid to be selected to query against
/// </summary>
private void BuildAgeList()
{
_studentAges.Clear();
Student s1 = new Student();
s1.Age = 18;
Student s2 = new Student();
s2.Age = 19;
Student s3 = new Student();
s3.Age = 20;
Student s4 = new Student();
s4.Age = 21;
Student s5 = new Student();
s5.Age = 22;
Student s6 = new Student();
s6.Age = 23;
Student s7 = new Student();
s7.Age = 24;
_studentAges.Add(s1);
_studentAges.Add(s2);
_studentAges.Add(s3);
_studentAges.Add(s4);
_studentAges.Add(s5);
_studentAges.Add(s6);
_studentAges.Add(s7);
}
