void showVehicleData()
{
DataSet d = Database.getInstance().select("", new string[] { " Vehicle as T1 " }, new String[] { " T1.VehicleVIN, T1.Manufacturer, T1.Model, T1.VehicleDetails, T1.DailyRate, T1.ChassisNumber, T1.SuitableForHire, T1.DateOfFirstRegistration, T1.ImagePath " }, "WHERE T1.VehicleVIN ", "=", VehicleVIN, new string[] { " ORDER BY T1.DateOfFirstRegistration DESC;" });
String
strVehicleVIN = "",
strManufacturer = "",
strModel = "",
strDateOfFirstRegistration = "",
strVehicleDetails = " ",
strDailyRate = "",
strSuitableForHire = "",
strImagePath = "";
foreach (DataTable table in d.Tables)
{
foreach (DataRow row in table.Rows)
{
foreach (DataColumn column in table.Columns)
{
if (column.ColumnName == "VehicleVIN")
{
strVehicleVIN = row[column].ToString();
txtVehicleVIN.Text = strVehicleVIN;
}
if (column.ColumnName == "Manufacturer")
{
txtManufacturer.Text = row[column].ToString();
}
if (column.ColumnName == "Model")
{
txtModel.Text = row[column].ToString();
}
if (column.ColumnName == "DateOfFirstRegistration")
{
dpDateOfFirstRegistration.SelectedDate = DataValidator.stringToDate(row[column].ToString());
}
if (column.ColumnName == "VehicleDetails")
{
txtVehicleDetails.Text = row[column].ToString();
}
if (column.ColumnName == "DailyRate")
{
txtDailyRate.Text = string.Format("{0:C}", Convert.ToDecimal(row[column].ToString()));
}
if (column.ColumnName == "ChassisNumber")
{
txtChassisNumber.Text = row[column].ToString();
}
if (column.ColumnName == "SuitableForHire")
{
cmbSuitableForHire.SelectedIndex = DataValidator.getComboBoxIndexOf(cmbSuitableForHire, row[column].ToString());
}
if (column.ColumnName == "ImagePath")
{
strImagePath = row[column].ToString();
imgVehicleImage.Source = new BitmapImage(new Uri(strImagePath, UriKind.Relative));
}
}
}
}
}
void showCustomerData()
{
DataSet d = Database.getInstance().select("", new string[] { " Customer as T1, DrivingLicense as T2, CustomerContact as T3, CreditCard as T4 " }, new String[] { " T1.CustomerID, T1.Title, T1.FirstName, T1.MiddleName, T1.LastName, T1.DateOfBirth, T1.ImagePath, T3.HouseNumber, T3.StreetName, T3.Suburb, T3.City, T3.State, T3.Postcode, T3.MobilePhone, T3.Email, T2.DrivingLicenseNumber, T2.Country, T2.IssueDate, T2.ExpiryDate, T2.Convictions, T4.CredCardType, T4.CredCardNumber, T4.NameOnCredCard, T4.CredCardExpiry, T4.CredCardSecurityCode " }, "WHERE T1.CustomerID = T2.CustomerID and T3.CustomerID = T1.CustomerID and T4.CustomerID = T1.CustomerID and T1.CustomerID ", "=", customerID.ToString(), new string[] { "" });
String
strCustomerID = "",
strTitle = "",
strFirstName = "",
strLastName = "",
strDateOfBirth = "",
strHouseNo = "",
strStreetName = "",
strSuburb = "",
strCity = "",
strState = "",
strPostcode = "",
strPhone = "",
strEmail = "",
strDrivingLicenseNumber = "",
strImagePath = "";
foreach (DataTable table in d.Tables)
{
foreach (DataRow row in table.Rows)
{
foreach (DataColumn column in table.Columns)
{
if (column.ColumnName == "CustomerID")
{
strCustomerID = row[column].ToString();
txtCustomerID.Text = strCustomerID; // Hidden form field. Is it necessary?
}
if (column.ColumnName == "Title")
{
// There MUST be a more elegant solution!
cmbTitle.SelectedIndex = DataValidator.getComboBoxIndexOf(cmbTitle, row[column].ToString());
}
if (column.ColumnName == "FirstName")
{
txtFirstName.Text = row[column].ToString();
}
if (column.ColumnName == "MiddleName")
{
txtMiddleName.Text = row[column].ToString();
}
if (column.ColumnName == "LastName")
{
txtLastName.Text = row[column].ToString();
}
if (column.ColumnName == "DateOfBirth")
{
dpDateOfBirth.SelectedDate = DataValidator.stringToDate(row[column].ToString());
}
if (column.ColumnName == "ImagePath")
{
strImagePath = row[column].ToString();
imgCustomerImage.Source = new BitmapImage(new Uri(strImagePath, UriKind.Relative));
}
if (column.ColumnName == "HouseNumber")
{
txtHouseNumber.Text = row[column].ToString();
}
if (column.ColumnName == "StreetName")
{
txtStreet.Text = row[column].ToString();
}
if (column.ColumnName == "Suburb")
{
txtSuburb.Text = row[column].ToString();
}
if (column.ColumnName == "City")
{
txtCity.Text = row[column].ToString();
}
if (column.ColumnName == "State")
{
cmbState.SelectedIndex = DataValidator.getComboBoxIndexOf(cmbState, row[column].ToString());
}
if (column.ColumnName == "Postcode")
{
txtPostcode.Text = row[column].ToString();
}
if (column.ColumnName == "MobilePhone")
{
txtPhone.Text = row[column].ToString();
}
if (column.ColumnName == "Email")
{
txtEmail.Text = row[column].ToString();
}
if (column.ColumnName == "DrivingLicenseNumber")
{
txtDrivingLicenseNumber.Text = row[column].ToString();
}
if (column.ColumnName == "IssueDate")
{
dpDrivingLicenseIssueDate.SelectedDate = DataValidator.stringToDate(row[column].ToString());
}
if (column.ColumnName == "ExpiryDate")
{
dpDrivingLicenseExpiry.SelectedDate = DataValidator.stringToDate(row[column].ToString());
}
if (column.ColumnName == "Convictions")
{
cmbDrivingConvictions.SelectedIndex = DataValidator.getComboBoxIndexOf(cmbDrivingConvictions, row[column].ToString());
}
if (column.ColumnName == "Country")
{
cmbDrivingLicenseCountry.SelectedIndex = DataValidator.getComboBoxIndexOf(cmbDrivingLicenseCountry, row[column].ToString());
}
if (column.ColumnName == "CredCardNumber")
{
txtCreditCardCardNumber.Text = row[column].ToString();
}
if (column.ColumnName == "CredCardType")
{
cmbCreditCardType.SelectedIndex = DataValidator.getComboBoxIndexOf(cmbCreditCardType, row[column].ToString());
}
if (column.ColumnName == "NameOnCredCard")
{
txtCreditCardCardName.Text = row[column].ToString();
}
if (column.ColumnName == "CredCardExpiry")
{
txtCreditCardExpiry.Text = row[column].ToString();
}
if (column.ColumnName == "CredCardSecurityCode")
{
txtCreditCardSecurityCode.Text = row[column].ToString();
}
}
}
}
}
