コード例 #1
0
        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);
        }
コード例 #2
0
        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);
        }