public AccountLookup(Controller controller, Form frm, Invoice aInvoice)
{
this.controller = controller;
this.frm = frm;
this.invoice = aInvoice;
InitializeComponent();
}
public void saveInvoice(Invoice invoice)
{
try{
DateTime dt = DateTime.Parse(invoice.getDate());
string sql = "INSERT INTO Invoice (CarId, AccountId, Duration, PreCharge, Date) values(@carId, @accountId, @duration, @preCharge, @date)";
conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
MySqlCommand command = new MySqlCommand(sql,conn);
command.Parameters.AddWithValue("carId", invoice.getCarID());
command.Parameters.AddWithValue("accountId", invoice.getAccountID());
command.Parameters.AddWithValue("duration", invoice.getDuration());
command.Parameters.AddWithValue("preCharge", invoice.getPreCharge());
command.Parameters.AddWithValue("date", dt.ToString("yyyy-MM-dd"));
conn.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conn.Close();
}
}
private void btnRent_Click(object sender, EventArgs e)
{
if(txtPreCharge.Text == "" || txtPreCharge.Text == "0" || txtPreCharge.Text == null){
MessageBox.Show("You must enter and calculate fields");
} else {
Invoice invoice = new Invoice(cmboCar.SelectedValue.ToString(), txtDuration.Text, txtPreCharge.Text, DateTime.Today.ToString("yyyy-MM-dd"));
loadForm(new AccountLookup(controller, this, invoice));
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
invoice = controller.lookupInvoiceForAccount(txtDriversLicense.Text);
if (invoice != null)
{
loadForm(new ReturnRentalReceipt(controller, invoice,this));
}
else
{
lblMessage.Text = "No rentals found.";
}
}
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 void updateInvoice(Invoice invoice)
{
try
{
string sql = "UPDATE Invoice SET Total = @total, Miles = @miles WHERE InvoiceId = @invoiceId";
conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
MySqlCommand command = new MySqlCommand(sql, conn);
command.Parameters.AddWithValue("total", invoice.getTotal());
command.Parameters.AddWithValue("miles", invoice.getMiles());
command.Parameters.AddWithValue("invoiceId", invoice.getInvoiceId());
conn.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conn.Close();
}
}
internal Invoice lookupInvoiceForAccount(string aDriversLicense)
{
Invoice invoice = null;
try
{
string sql = "SELECT * FROM Invoice WHERE (Total = -1 AND AccountId = @driversLicense)";
conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
MySqlCommand command = new MySqlCommand(sql, conn);
command.Parameters.AddWithValue("driversLicense", aDriversLicense);
conn.Open();
MySqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
invoice = new Invoice(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), reader[7].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 invoice;
}
internal void updateInvoice(Invoice invoice, bool isAvailable)
{
database.updateInvoice(invoice);
database.rentCar(invoice.getCarID(), isAvailable);
}