public static Customer getCustomerFromVehicle(string vrm)
{
Customer customer = new Customer();
using (MySqlConnection con = new MySqlConnection(connection))
{
string query = "SELECT customerID FROM CustomersVehicles WHERE vrm = @vrm";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Parameters.AddWithValue("@vrm", vrm);
cmd.Connection = con;
con.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
customer = CustomerProvider.getCustomerFromID(sdr["customerID"].ToString());
break;
}
}
con.Close();
}
}
return(customer);
}
public static Job getJobDetails(string jobID)
{
Job job = new Job();
using (MySqlConnection con = new MySqlConnection(connection))
{
string query = "SELECT * FROM Jobs WHERE jobID = '" + jobID + "'";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Connection = con;
con.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
job = new Job();
job.jobID = (sdr["jobID"]).ToString();
job.start = DateTime.Parse(sdr["startDate"].ToString());
try
{
job.end = DateTime.Parse(sdr["endDate"].ToString());
}
catch
{
job.end = null;
}
try
{
job.paid = DateTime.Parse(sdr["paidDate"].ToString());
}
catch
{
job.paid = null;
}
job.bay = Int32.Parse(sdr["bay"].ToString());
job.status = sdr["status"].ToString();
job.type = sdr["type"].ToString();
job.customer = VehicleProvider.getCustomerFromVehicle(getVehicleFromJob(jobID).vrm);
job.discount = CustomerProvider.getDiscounts(VehicleProvider.getCustomerFromVehicle(getVehicleFromJob(jobID).vrm).customerID);
job.vehicle = getVehicleFromJob(jobID);
job.notes = getJobNotes(jobID);
job.parts = getPartsForJob(jobID);
job.labour = getLabour(jobID);
job.mechanic = getAssigedMechanic(jobID);
}
}
con.Close();
}
}
return(job);
}