public ReturnRentalReceipt(Controller controller, Invoice invoice, Form frm) { this.controller = controller; this.invoice = invoice; this.frm = frm; account = controller.getAccount(invoice.getAccountID()); car = controller.getCar(invoice.getCarID()); InitializeComponent(); lblLastName.Text = account.getLastName(); lblFirstName.Text = account.getFirstName(); lblAccountNumber.Text = account.getDriversLicense(); lblAddress.Text = account.getAddress(); lblCity.Text = account.getCity(); lblState.Text = account.getState(); lblZip.Text = account.getZip(); lblDays.Text = invoice.getDuration(); lblPreCost.Text = String.Format("{0:C}",Double.Parse(invoice.getPreCharge())); lblMake.Text = car.getMake(); lblModel.Text = car.getModel(); lblModelCost.Text = String.Format("{0:C}", controller.rentalModelCost(car.getRentalModel())); }
internal Car getCar(string aCarId) { Car car = null; try { string sql = "SELECT Car.* FROM Car WHERE (Car.Id = @aCarId)"; conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString); MySqlCommand command = new MySqlCommand(sql, conn); command.Parameters.AddWithValue("aCarId", aCarId); conn.Open(); MySqlDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { car = new Car(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { // Always call Close when done reading. reader.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { conn.Close(); } return car; }