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;
}
}
