Ejemplo n.º 1
0
        public static bool InsertCustomer(Customer customer)
        {
            int           rows = 0;
            SqlConnection con  = Acme_Used_CarsDB.GetConnection();
            SqlCommand    cmd  = new SqlCommand();

            cmd.CommandText = "insert into Customer values (@number,@name,@inventoryid)";
            cmd.CommandType = CommandType.Text;
            cmd.Connection  = con;
            cmd.Parameters.AddWithValue("@number", customer.number);
            cmd.Parameters.AddWithValue("@name", customer.name);
            cmd.Parameters.AddWithValue("@inventoryid", customer.inventoryid);
            try
            {
                con.Open();
                rows = cmd.ExecuteNonQuery();
            }
            catch (SqlException err)
            {
                MessageBox.Show(err.Message, "Database Error");
            }
            finally
            {
                con.Close();
            }
            if (rows == 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 2
0
        public static bool InsertVehicle(Vehicle vehicle)
        {
            int           rows    = 0;
            SqlConnection con     = Acme_Used_CarsDB.GetConnection();
            SqlCommand    command = new SqlCommand();

            command.CommandText = "insert into Vehicle values (@inventoryid,@manufacturer,@ModelName,@year,@vehicleid,@costvalue)";
            command.CommandType = CommandType.Text;
            command.Connection  = con;
            command.Parameters.AddWithValue("@inventoryid", vehicle.InventoryID);
            command.Parameters.AddWithValue("@manufacturer", vehicle.Manufacturer);
            command.Parameters.AddWithValue("@ModelName", vehicle.ModelName);
            command.Parameters.AddWithValue("@year", vehicle.Year);
            command.Parameters.AddWithValue("@vehicleid", vehicle.VehicleID);
            command.Parameters.AddWithValue("@costvalue", vehicle.CostValue);
            try
            {
                con.Open();
                rows = command.ExecuteNonQuery();
            }
            catch (SqlException err)
            {
                MessageBox.Show(err.Message, "Database Error");
            }
            finally
            {
                con.Close();
            }
            if (rows == 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 3
0
        public static List <Vehicle> GetVehicles()
        {
            SqlConnection  con     = Acme_Used_CarsDB.GetConnection();
            List <Vehicle> vehList = new List <Vehicle>();
            SqlCommand     command = new SqlCommand();

            command.CommandText = "select * from Vehicle";
            command.CommandType = CommandType.Text;
            command.Connection  = con;
            try
            {
                con.Open();
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Vehicle v = new Vehicle();
                    v.InventoryID  = Convert.ToInt32(reader[0]);
                    v.Manufacturer = reader[1].ToString();
                    v.ModelName    = reader[2].ToString();
                    v.Year         = Convert.ToInt32(reader[3]);
                    v.VehicleID    = reader[4].ToString();
                    v.CostValue    = Convert.ToDecimal(reader[5]);
                    vehList.Add(v);
                }
                reader.Close();
            }
            catch (SqlException err)
            {
                MessageBox.Show(err.Message, "Database Error");
            }
            finally
            {
                con.Close();
            }
            return(vehList);
        }