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(); } } } } }