public float getTotalCost(Car car) { string sqlBasePrice = "SELECT BasePrice FROM Cars WHERE CarModel='" + car.Model + "'"; DataSet priceDS = connect.GetDataSet(sqlBasePrice); car.TotalPrice = float.Parse(priceDS.Tables[0].Rows[0]["BasePrice"].ToString()); List<CarOption> cartman = car.Packages; float pkgPrice= car.TotalPrice; for(int i = 0; i< cartman.Count; i++) { CarOption currentPkg = cartman[i]; pkgPrice += currentPkg.PackPrice; } // String sqlPkgPrice = "SELECT Price FROM Packages WHERE CarID='" + CarID + "'"; return pkgPrice; }
public DataSet Greg(Car c) { DataTable table1 = new DataTable("Output"); table1.Columns.Add("Selected Packages"); table1.Columns.Add("Price"); for (int i = 0; i < c.Packages.Count; i++) { CarOption currentPkg = c.Packages[i]; table1.Rows.Add(currentPkg.PackDesc, currentPkg.PackPrice); } DataSet outputDS = new DataSet("Greg"); outputDS.Tables.Add(table1); return outputDS; }
public Car GetCar(Car c) { return c; }
protected void btnConfirmOrder_Click(object sender, EventArgs e) { float totalCost = 0; if (txtName.Text == null) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Enter Your Name');</script>"); } else if (txtPhone.Text == null) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Enter Your Phone Number');</script>"); } else if (txtAddress1.Text == null) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Enter Your Current Address');</script>"); } else if (txtCity.Text == null) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Enter the City of Your Above Address');</script>"); } else if (txtState.Text == null) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Enter the State of Your Above Address');</script>"); } else if (txtZip.Text == null) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Enter the Zip Code for Your Above Address');</script>"); } else if (ddlMake.Text == "No Selection") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('You Must Select a Make and Model to Begin Building Your Car');</script>"); } /* else if (selectedPackages.Count==0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('You Must Pick at Least One Package for Your Car');</script>"); } */ else if (ddlColor.Text == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Choose a Color for Your Car or It will Look Like Crap');</script>"); } else if (rdbBuy.Checked == true) { rdbLease.Enabled = false; if (rdbBuy.Checked == false) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Choose a Payment Option');</script>"); } } else if(rdbLease.Checked==true) { rdbBuy.Enabled = false; if (rdbLease.Checked == false) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Choose a Payment Option');</script>"); } } else if (rdbCall.Checked == true) { rdbDealership.Enabled = false; if (rdbCall.Checked == false) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Choose a Follow Up Option');</script>"); } } else if (rdbDealership.Checked == true) { rdbCall.Enabled = false; if (rdbDealership.Checked == false) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Choose a Follow Up Option');</script>"); } } else { gvPackages.Enabled = false; ddlMake.Enabled = false; ddlModel.Enabled = false; ddlColor.Enabled = false; Processor P = new Processor(); string carName = ddlModel.Text; string sqlYear = "SELECT CarYear FROM Cars WHERE CarModel ='" + carName + "'"; DataSet yearDS = myConnect.GetDataSet(sqlYear); // DataRow DR = myConnect.GetRow(yearDS, 0); int year = int.Parse(yearDS.Tables[0].Rows[0]["CarYear"].ToString()); localCar = new Car(ddlMake.Text, ddlModel.Text, year, selectedPackages, ddlColor.Text); totalCost = P.getTotalCost(localCar); //Label1.Text = totalCost.ToString(); gvOutput.DataSource = P.Greg(localCar); gvOutput.DataBind(); } string output = "SELECT * FROM SelectedPackages"; DataSet outputDS = myConnect.GetDataSet(output); gvOutput.DataSource = outputDS; gvOutput.DataBind(); // gvOutput.Columns[0].FooterText = "Total cost: "; // gvOutput.Columns[2].FooterText = " " + totalCost; // string q = "SELECT SUM(PackagePrice) AS PackagePrice FROM SelectedPackages"; // DataSet k = myConnect.GetDataSet(q); // totalCost = float.Parse(k.Tables[0].Rows[0]["PackagePrice"].ToString()) + localCar.TotalPrice; // Label4.Text = "Total Cost: " + totalCost; lblOutName.Text = txtName.Text; lblOutPhone.Text = txtPhone.Text; lblOutMake.Text = ddlMake.Text; lblOutModel.Text = ddlModel.Text + " in " + ddlColor.Text; if (rdbBuy.Checked == true && rdbCall.Checked == true) { lblOtherOptions.Text = rdbBuy.Text + " and " + rdbCall.Text; } else if (rdbBuy.Checked == true && rdbDealership.Checked == true) { lblOtherOptions.Text = rdbBuy.Text +" and " + rdbDealership.Text; } if (rdbLease.Checked == true && rdbCall.Checked == true) { lblOtherOptions.Text = rdbLease.Text + " and " + rdbCall.Text; } else if (rdbLease.Checked == true && rdbDealership.Checked == true) { lblOtherOptions.Text = rdbLease.Text + " and " + rdbDealership.Text; } }