//compute total cost (base price of car plus all selected packages) public double computeTotalCost(Car newCar) { double totalCost; double numBasePrice = double.Parse(newCar.BasePrice, System.Globalization.NumberStyles.Currency); double optionTotal = 0; foreach (CarOption option in newCar.getOptionList()) { optionTotal += double.Parse(option.Price, System.Globalization.NumberStyles.Currency); } totalCost = numBasePrice + optionTotal; return(totalCost); }
//update database with new purchased values public void updateDataBaseFields(Car newCar, DBConnect objDB) { //update quantity sold for car string strSqlUpdateTotalQuantitySold = "UPDATE Cars SET TotalQuantitySold = TotalQuantitySold + 1 WHERE CarID = " + newCar.CarID; objDB.DoUpdate(strSqlUpdateTotalQuantitySold); //update total sales for car string strSqlUpdateTotalSales = "UPDATE Cars SET TotalSales = TotalSales + " + newCar.TotalCost + " WHERE CarID = " + newCar.CarID; objDB.DoUpdate(strSqlUpdateTotalSales); //update quantity sold for each package foreach (CarOption option in newCar.getOptionList()) { string strSqlUpdatePackageQuantity = "UPDATE Packages SET TotalQuantitySold = TotalQuantitySold + 1 WHERE PackageDescription = '" + option.Name + "'"; objDB.DoUpdate(strSqlUpdatePackageQuantity); } }