public Report getTestReport()
{
Report list = new Report();
using (MySqlConnection conn = GetConnection())
{
MySqlCommand command = new MySqlCommand("getSampleReport", conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
list = new Report();
list.basicInfo.make = MySQLDBExtension.GetStringSafe(reader, "make");
list.basicInfo.year = MySQLDBExtension.GetStringSafe(reader, "year");
list.basicInfo.vin = MySQLDBExtension.GetStringSafe(reader, "vin");
list.basicInfo.mileage = MySQLDBExtension.GetStringSafe(reader, "mileage");
list.signature.fairmarketvalue = MySQLDBExtension.GetStringSafe(reader, "fairmarketvalue");
list.client.customer_name = MySQLDBExtension.GetStringSafe(reader, "customer_name");
}
command.Connection.Close();
}
return(list);
}
public Report getReport(string clientID)
{
Report list = new Report();
using (MySqlConnection conn = GetConnection())
{
MySqlCommand command = new MySqlCommand("getReport", conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new MySqlParameter("customer_id", clientID));
command.Connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
list = new Report();
list.basicInfo.make = MySQLDBExtension.GetStringSafe(reader, "make");
list.basicInfo.year = MySQLDBExtension.GetStringSafe(reader, "year");
list.basicInfo.vin = MySQLDBExtension.GetStringSafe(reader, "vin");
list.basicInfo.model = MySQLDBExtension.GetStringSafe(reader, "model");
list.basicInfo.color = MySQLDBExtension.GetStringSafe(reader, "color");
list.basicInfo.mileage = MySQLDBExtension.GetStringSafe(reader, "mileage");
list.basicInfo.location = MySQLDBExtension.GetStringSafe(reader, "location");
list.comments.transmission_comment = MySQLDBExtension.GetStringSafe(reader, "transmission_comments");
var transType = MySQLDBExtension.GetStringSafe(reader, "transmission_type");
if (!string.IsNullOrEmpty(transType))
{
if (transType == "0")
{
list.transmission.transmission_type = "Automatic";
}
else
{
list.transmission.transmission_type = "Manual";
}
}
// test drive
list.testDrive.testdrive_comment = MySQLDBExtension.GetStringSafe(reader, "testdrive_comment");
list.testDrive.bouce_test = MySQLDBExtension.GetStringSafe(reader, "bounce_test");
list.testDrive.suspension_noise = MySQLDBExtension.GetStringSafe(reader, "suspension_noise");
// engine
list.engine.engine_comment = MySQLDBExtension.GetStringSafe(reader, "engine_comment");
list.engine.engine_size = MySQLDBExtension.GetStringSafe(reader, "engine_size");
list.engine.engine_performance = MySQLDBExtension.GetStringSafe(reader, "engine_performance");
var oilLevel = MySQLDBExtension.GetStringSafe(reader, "oil_level_quality");
if (!string.IsNullOrEmpty(transType))
{
if (transType == "0")
{
list.engine.oil_level_quality = "Excellent";
}
else if (transType == "1")
{
list.engine.oil_level_quality = "Good";
}
else if (transType == "2")
{
list.engine.oil_level_quality = "Fair";
}
else if (transType == "3")
{
list.engine.oil_level_quality = "Poor";
}
}
// sources
list.source.vehicle_sources_comment = System.Net.WebUtility.UrlDecode(MySQLDBExtension.GetStringSafe(reader, "vehicle_sources_comment"));
// format the string for the web
list.source.vehicle_sources_comment = list.source.vehicle_sources_comment.Replace(@"\n", "<br />");
list.source.vehicle_sources_haggerty = MySQLDBExtension.GetStringSafe(reader, "vehicle_sources_haggerty");
list.source.vehicle_sources_kbb = MySQLDBExtension.GetStringSafe(reader, "vehicle_sources_kbb");
list.source.vehicle_sources_nada = MySQLDBExtension.GetStringSafe(reader, "vehicle_sources_nada");
list.signature.fairmarketvalue = MySQLDBExtension.GetStringSafe(reader, "fairmarketvalue");
list.client.customer_name = MySQLDBExtension.GetStringSafe(reader, "customer_name");
list.comments.testdrive_comment = MySQLDBExtension.GetStringSafe(reader, "testdrive_comment");
list.comments.engine_comment = MySQLDBExtension.GetStringSafe(reader, "engine_comment");
list.comments.steering_comment = MySQLDBExtension.GetStringSafe(reader, "steering_comments");
list.comments.brake_comment = MySQLDBExtension.GetStringSafe(reader, "brakes_comments");
list.comments.rearend_comment = MySQLDBExtension.GetStringSafe(reader, "rearend_comments");
}
command.Connection.Close();
}
return(list);
}