private void calculate_mileage()
        {
            //make sure data is commited
            updateLineItems();
            //loop through each
            double mileageValue = 0;
            //foreach (DataGridViewRow row in dgvItems.Rows)
            //{

            calculations calculations = new calculations();

            calculations.mileage(/*Convert.ToInt32(rowdgvItems.Rows[0].Cells[0].Value),*/ quoteNumber); //i dont need to loop through this i think...
            mileageValue = mileageValue + calculations._mileageTotal;

            //}


            //use this figure to update total
            string sql = "UPDATE dbo.slimline_install_quote SET mileage_cost = " + mileageValue.ToString() + "WHERE id = " + quoteNumber.ToString();

            using (SqlConnection conn = new SqlConnection(CONNECT.ConnectionString))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                    cmd.ExecuteNonQuery();
                conn.Close();
            }
        }
        private void updateLineItems()  //look at all of the variables and update based on this
        {
            string sql = "UPDATE dbo.slimline_install_quote SET site_address_1 = '" + txtSiteAddress1.Text + "', site_address_2 = '" + txtSiteAddress2.Text + "'," +
                         "site_address_3 = '" + txtSiteAddress3.Text + "',post_code = '" + txtPostCode.Text + "',county = '" + txtCounty.Text + "' WHERE id = " + quoteNumber;

            using (SqlConnection conn = new SqlConnection(CONNECT.ConnectionString))
            {
                conn.Open();

                using (SqlCommand cmd = new SqlCommand(sql, conn))
                    cmd.ExecuteNonQuery();
                // ^^^^^^^^^^ updates the site address
                if (buttonPressed == -1)
                {
                    buttonString();  //generate the string
                    sql = "Update dbo.slimline_install_quote SET " + sqlButton + " WHERE id = " + quoteNumber;
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                        cmd.ExecuteNonQuery();
                    // MessageBox.Show(sqlButton);
                }
                if (updateMiles == -1)
                {
                    sql = "UPDATE dbo.slimline_install_quote SET mileage_one_way = '" + txtMiles.Text + "', site_visits = '" + txtVisits.Text + "',total_mileage = '" + txtTotalMiles.Text + "', london = " + Convert.ToInt32(chkLondon.Checked).ToString() + " WHERE id = " + quoteNumber.ToString();
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                        cmd.ExecuteNonQuery();
                    updateMiles = -1;
                }
                ////now update every line item
                if (buttonPressed == -1)
                {
                    sql = "UPDATE dbo.slimline_install_door SET " + sqlButton + " WHERE quote_id = " + quoteNumber;
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                        cmd.ExecuteNonQuery();
                    //MessageBox.Show(sqlButton);
                    buttonPressed = 0;
                }
                loaddgv(); //also need to recalculate the maths on this..

                for (int i = 0; i < dgvItems.Rows.Count; i++)
                {
                    calculations calculations = new calculations();
                    calculations.getValue(Convert.ToInt32(dgvItems.Rows[i].Cells[0].Value));
                    double temp = Convert.ToDouble(calculations._totalValue.ToString());
                    // * this by the qty
                    temp = temp * Convert.ToDouble(dgvItems.Rows[i].Cells[13].Value.ToString());
                    sql  = "UPDATE dbo.slimline_install_door SET total_value = " + temp + " WHERE id = " + dgvItems.Rows[i].Cells[0].Value.ToString();
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                        cmd.ExecuteNonQuery();
                }

                // i think a loaddgv here will stop it from not adding correct value
                loaddgv();


                //i think we also need to update the sumTotal of quote while we are here...
                double sumTotal = 0;
                for (int i = 0; i < dgvItems.Rows.Count; i++)
                {
                    if (Convert.ToString(dgvItems.Rows[i].Cells[15].Value) != "")
                    {
                        string temp = Convert.ToString(dgvItems.Rows[i].Cells[15].Value);
                        temp     = temp.Substring(1, temp.Length - 1);
                        sumTotal = sumTotal + Convert.ToDouble(temp);
                    }
                }
                if (sumTotal > 0)
                {
                    sql = "UPDATE dbo.slimline_install_quote SET sumTotal = " + sumTotal + "WHERE id = " + quoteNumber;
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                    {
                        cmd.ExecuteNonQuery();
                    }
                }

                conn.Close();
                loaddgv();
            }
        }