protected void Page_Load(object sender, EventArgs e)
{
int count = 0;
cartItems = new List <CartItem>();
drinks = ProductsDA.GetAllDrinks();
double basePrice = drinks.First().ProductPrice;
rdoSmall.Text = rdoSmall.Text + " (" + Math.Round(basePrice, 2).ToString("C") + ")";
rdoMedium.Text = rdoMedium.Text + " (" + Math.Round(basePrice * MEDIUM_PRICE_MULTIPLIER, 2).ToString("C") + ")";
rdoLarge.Text = rdoLarge.Text + " (" + Math.Round(basePrice * LARGE_PRICE_MULTIPLIER, 2).ToString("C") + ")";
foreach (Products drink in drinks)
{
RadioButton newDrink = new RadioButton();
newDrink.Text = drink.ProductDetail;
newDrink.GroupName = "grpDrinks";
if (count < 1)
{
newDrink.Checked = true;
}
pnlDrink.Controls.Add(newDrink);
pnlDrink.Controls.Add(new LiteralControl("<br />"));
count++;
}
}
public HttpResponseMessage Delete(int id)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
ProductsDA.DeleteProduct(id, p.Claims);
return(new HttpResponseMessage(HttpStatusCode.OK));
}
protected void UpdatePrice_Click(object sender, EventArgs e)
{
try
{
double price = Convert.ToDouble(Price.Text);
if (price < 0)
{
InvalidSelectionError();
}
else
{
Products product = ProductsDA.GetProductByID(Convert.ToInt32(MenuItemID.Text));
product.ProductPrice = price;
ProductsDA.UpdateProduct(product);
Price.Text = "";
MenuItemID.Text = "";
MenuItemName.Text = "";
PriceTable.Visible = false;
ItemTable.Visible = false;
}
}
catch (Exception ex)
{
InvalidSelectionError();
}
}
public HttpResponseMessage Put(Product c)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
ProductsDA.UpdateProduct(c, p.Claims);
return(new HttpResponseMessage(HttpStatusCode.OK));
}
protected void EditItem_Click(object sender, EventArgs e)
{
Products product = ProductsDA.GetProductByID(Convert.ToInt32(dropdownItems.SelectedValue));
MenuItemName.Text = product.ProductDetail;
MenuItemID.Text = dropdownItems.SelectedValue;
Price.Text = product.ProductPrice.ToString();
PriceTable.Visible = true;
}
public HttpResponseMessage Post(Product c)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
int id = ProductsDA.InsertProduct(c, p.Claims);
HttpResponseMessage message = new HttpResponseMessage(HttpStatusCode.OK);
message.Content = new StringContent(id.ToString());
return(message);
}
public HttpResponseMessage Put(Product c)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
int i = ProductsDA.NotActiveToActive(c, p.Claims);
if (i == 0)
{
return(new HttpResponseMessage(HttpStatusCode.NoContent));
}
return(new HttpResponseMessage(HttpStatusCode.OK));
}
//add all the product corresponding to the customer aircraft loaded int he invoice and load the invoiceid, customer id and aircraft id from that same invoice
private void Sub_Create_Sub_Load(object sender, EventArgs e)
{
MySqlConnection connection = new MySqlConnection(connec);
connection.Open();
string query_1 = @"Select *
FROM sales_orders AS s1
JOIN invoices as i1
ON i1.Invoice_ID = s1.invoices_Invoice_ID
JOIN subscriptions AS s2
ON s2.Subscription_ID = s1.Subscription_ID
JOIN products as p1
ON s1.products_Product_ID = p1.Product_ID
WHERE invoice_completed_1y_2n = 1
AND invoices_Invoice_ID = " + invid + "";
MySqlCommand comm = connection.CreateCommand();
comm.CommandText = query_1;
DataTable table = new DataTable();
MySqlDataAdapter adapt = new MySqlDataAdapter(query_1, connection);
adapt.Fill(table);
while (row < table.Rows.Count)
{
SubscriptionsDA sub = new SubscriptionsDA();
txtInvID.Text = table.Rows[row]["invoices_Invoice_ID"].ToString();
custIdTxt.Text = table.Rows[row]["Customer_ID"].ToString();
aircraft_lbl.Text = table.Rows[row]["Aircraft_ID"].ToString();
string query_2 = @"Select *
FROM products as p1
WHERE Aircraft_ID = " + table.Rows[row]["Aircraft_ID"] + "";
MySqlCommand comm2 = connection.CreateCommand();
comm2.CommandText = query_2;
MySqlDataAdapter adapt2 = new MySqlDataAdapter(query_2, connection);
adapt2.Fill(table2);
while (row < table2.Rows.Count)
{
ProductsDA pro = new ProductsDA();
pro.Product_id = Convert.ToInt32(table2.Rows[row]["Product_ID"]);
pro.Product_name = table2.Rows[row]["Product_Name"].ToString();
pro.Product_type = table2.Rows[row]["Product_Type"].ToString();
product_list.Items.Add(pro.Show_product());
row += 1;
}
row += 1;
}
row = 0;
connection.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
List <CartItem> cartItems = (List <CartItem>)Session["items"];
drinks = ProductsDA.GetAllDrinks();
double pricemultiplier = 1;
string size = null;
if (rdoSmall.Checked)
{
size = "small";
}
else if (rdoMedium.Checked)
{
pricemultiplier = MEDIUM_PRICE_MULTIPLIER;
size = "medium";
}
else if (rdoLarge.Checked)
{
pricemultiplier = LARGE_PRICE_MULTIPLIER;
size = "large";
}
else
{
Response.Redirect("Drinks.aspx");
}
foreach (Control rdoDrink in pnlDrink.Controls)
{
if ((rdoDrink.GetType().Name == "RadioButton") && (((CheckBox)rdoDrink).Checked))
{
foreach (Products product in drinks)
{
if (product.ProductDetail == (((RadioButton)rdoDrink).Text))
{
int productID = ProductsDA.GetLatestProductID() + 2000;
drink = new Drink(size, product.ProductDetail, Math.Round(product.ProductPrice * pricemultiplier, 2), productID, Math.Round(product.ProductPrice * pricemultiplier, 2), product.ProductType, 1, product.ProductDetail);
cartItems = Cart.AddItemToCart(drink, cartItems);
Session["items"] = cartItems;
Response.Redirect("CartView.aspx");
}
}
}
}
Response.Redirect("Drinks.aspx");
}
protected void UpdateCategory_Click(object sender, EventArgs e)
{
dropdownItems.Items.Clear();
string category = dropdownCategory.SelectedValue;
products = ProductsDA.GetAllProducts();
foreach (Products product in products)
{
if (product.ProductType == category)
{
ListItem productItem = new ListItem();
productItem.Text = product.ProductDetail;
productItem.Value = product.ProductID.ToString();
dropdownItems.Items.Add(productItem);
ItemTable.Visible = true;
PriceTable.Visible = false;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
double sideTotal = 0;
string selectedSides = "";
Side newSide = null;
List <CartItem> cartItems = (List <CartItem>)Session["items"];
foreach (Control sides in pnlSides.Controls)
{
if (sides.GetType().Name == "RadioButton")
{
if (((CheckBox)sides).Checked)
{
string currentSide = ((CheckBox)sides).Text;
selectedSides += currentSide + " ";
foreach (Products s in allSides)
{
if (s.ProductDetail == currentSide)
{
sideTotal += s.ProductPrice;
}
}
}
}
}
int productID = ProductsDA.GetLatestProductID();
newSide = new Side(selectedSides, sideTotal, productID, sideTotal, "Side Item", 1, selectedSides);
cartItems = Cart.AddItemToCart(newSide, cartItems);
Session["items"] = cartItems;
Response.Redirect("CartView.aspx");
//newSide.SideType = selectedSides;
//newSide.SidePrice = sideTotal;
}
protected void Page_Load(object sender, EventArgs e)
{
if (((Employee)Session["employee"] == null) || (((Employee)Session["employee"]).EmployeeRole != "store manager"))
{
Response.Redirect("AdminLogin.aspx");
}
products = ProductsDA.GetAllProducts();
categories = new List <string>();
foreach (Products product in products)
{
if (!categories.Contains(product.ProductType))
{
categories.Add(product.ProductType);
ListItem categoryItem = new ListItem();
categoryItem.Text = product.ProductType;
categoryItem.Value = product.ProductType;
dropdownCategory.Items.Add(categoryItem);
}
}
}
//protected void rdoFamPk_CheckedChanged(object sender, EventArgs e)
//{
// //specials.ProductPrice = 19.99;
// //specials.ProductType = "Special";
// //specials.ProductDetail = "Family Pack";
//}
//protected void rdoIndivPk_CheckedChanged(object sender, EventArgs e)
//{
// ////specials.ProductPrice = 9.99;
// //specials.ProductType = "Special";
// //specials.ProductDetail = "Individual Pack";
//}
//protected void rdoLGFamPk_CheckedChanged(object sender, EventArgs e)
//{
// //specials.ProductPrice = 29.99;
// //specials.ProductType = "Special";
// //specials.ProductDetail = "Large Family Pack";
//}
protected void btnSpecOrder_Click(object sender, EventArgs e)
{
specials = new Products();
cartItems = (List <CartItem>)Session["items"];
int productID = ProductsDA.GetLatestProductID();
if (rdoFamPk.Checked == true)
{
specials.ProductID = productID;
specials.ProductPrice = 19.99;
specials.ProductQty = 1;
specials.ProductType = "Special";
specials.ProductDetail = "Family Pack";
}
else if (rdoIndivPk.Checked == true)
{
specials.ProductID = productID;
specials.ProductPrice = 9.99;
specials.ProductQty = 1;
specials.ProductType = "Special";
specials.ProductDetail = "Individual Pack";
}
else if (rdoLGFamPk.Checked == true)
{
specials.ProductID = productID;
specials.ProductPrice = 29.99;
specials.ProductQty = 1;
specials.ProductType = "Special";
specials.ProductDetail = "Large Family Pack";
}
cartItems = Cart.AddItemToCart(specials, cartItems);
Session["items"] = cartItems;
Response.Redirect("CartView.aspx");
}
public HttpResponseMessage Put(Products p)
{
ProductsDA.EditProduct(p);
return(new HttpResponseMessage(HttpStatusCode.OK));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
List <CartItem> cartItems = (List <CartItem>)Session["items"];
string pizzaSize = "";
string pizzaCheese = "";
string pizzaSauce = "";
string pizzaCrust = "";
string pizzaToppings = "";
string pizzaExtras = "";
double pizzaCost = 0;
//check for pizza size
if (rdoSmall.Checked)
{
pizzaSize = "Small";
pizzaCost = 8.99;
}
else if (rdoMedium.Checked)
{
pizzaSize = "Medium";
pizzaCost = 11.99;
}
else if (rdoLarge.Checked)
{
pizzaSize = "Large";
pizzaCost = 14.99;
}
//check for crust type
//found logic on stack overflow checks or Controls within the Panel
foreach (Control crustType in pnlCrusts.Controls)
{
//Searches for the type of the control, checks for RadioButton
if (crustType.GetType().Name == "RadioButton")
{
//casts the crust type control to radio button, checks if it's selected
if (((RadioButton)crustType).Checked)
{
//sets the pizza crust type
pizzaCrust = ((RadioButton)crustType).Text;
}
}
}
//String currentCrust = newPizza.PizzaCrust;
foreach (Products crust in allCrusts)
{
String crustSelection = crust.ProductDetail;
if (pizzaCrust == crustSelection)
{
pizzaCost += Convert.ToDouble(crust.ProductPrice);
}
}
//check for selection in rdoSauceList
foreach (Control sauceType in pnlSauce.Controls)
{
if (sauceType.GetType().Name == "RadioButton")
{
if (((RadioButton)sauceType).Checked)
{
pizzaSauce = ((RadioButton)sauceType).Text;
}
}
}
foreach (Products sauce in allSauces)
{
if (pizzaSauce == sauce.ProductDetail)
{
pizzaCost += sauce.ProductPrice;
}
}
//check for cheese type
if (rdoNone.Checked)
{
pizzaCheese = rdoNone.Text;
}
else if (rdoRegular.Checked)
{
pizzaCheese = rdoRegular.Text;
}
//check for toppings
foreach (Control topping in pnlToppings.Controls)
{
if (topping.GetType().Name == "CheckBox")
{
if (((CheckBox)topping).Checked)
{
string currentTopping = ((CheckBox)topping).Text;
pizzaToppings += currentTopping + " ";
foreach (Products top in allToppings)
{
if (top.ProductDetail == currentTopping)
{
pizzaCost += top.ProductPrice;
}
}
}
}
}
//check for extras
if (chkExtraCheese.Checked)
{
pizzaExtras = chkExtraCheese.Text + " ";
pizzaCost += 1.50;
}
if (chkExtraSauce.Checked)
{
pizzaExtras += chkExtraSauce.Text;
pizzaCost += 1.50;
}
//newPizza.PizzaExtras = pizzaExtras;
//newPizza.PizzaPrice = Math.Round(pizzaCost, 2);
//newPizza.ProductPrice = Math.Round(pizzaCost, 2);
//newPizza.ProductType = "Pizza";
//newPizza.ProductDetail = "New Pizza object";
//string pizza = newPizza.PizzaToppings;
int productID = ProductsDA.GetLatestProductID();
//if(rdolarge)
newPizza = new Pizza(productID, pizzaCost, "Pizza", 1, pizzaCost, pizzaSize + " " + pizzaCrust + " Pizza: " + pizzaToppings, pizzaToppings, pizzaCheese, pizzaSauce, pizzaCrust, pizzaExtras, pizzaSize, pizzaCost);
cartItems = Cart.AddItemToCart(newPizza, cartItems);
Session["items"] = cartItems;
Response.Redirect("CartView.aspx");
}
protected void btnOrder_Click(object sender, EventArgs e)
{
cartItems = (List <CartItem>)Session["items"];
currentPromo = new Promotional();
Promotional shirt1 = new Promotional();
Promotional shirt2 = new Promotional();
Promotional shirt3 = new Promotional();
Promotional shirt4 = new Promotional();
int productID = ProductsDA.GetLatestProductID();
if (ddlQtyShirt1.SelectedValue != "0" && ddlSizeShirt1.SelectedValue != " ")
{
shirt1.ProductID = productID;
shirt1.ProductQty = Convert.ToInt32(ddlQtyShirt1.SelectedValue);
shirt1.ProductPrice = 15.99 * shirt1.ProductQty;
shirt1.PromotionalSize = ddlSizeShirt1.SelectedValue;
shirt1.ProductType = "Promotional";
shirt1.ProductDetail = "Let the Shenanigans begin female shirt";
currentPromo = shirt1;
}
else
{
shirt1 = null;
}
if (ddlQtyShirt2.SelectedValue != "0" && ddlSizeShirt2.SelectedValue != " ")
{
shirt2.ProductID = productID;
shirt2.ProductQty = Convert.ToInt32(ddlQtyShirt2.SelectedValue);
shirt2.ProductPrice = 15.99 * shirt2.ProductQty;
shirt2.PromotionalSize = ddlSizeShirt2.SelectedValue;
shirt2.ProductType = "Promotional";
shirt2.ProductDetail = "Kiss me I'm a piza baker shirt";
currentPromo = shirt2;
}
else
{
shirt2 = null;
}
if (ddlQtyShirt3.SelectedValue != "0" && ddlSizeShirt3.SelectedValue != " ")
{
shirt3.ProductID = productID;
shirt3.ProductQty = Convert.ToInt32(ddlQtyShirt3.SelectedValue);
shirt3.ProductPrice = 15.99 * shirt3.ProductQty;
shirt3.PromotionalSize = ddlSizeShirt3.SelectedValue;
shirt3.ProductType = "Promotional";
shirt3.ProductDetail = "I shamrock Shenanigans shirt";
currentPromo = shirt3;
}
else
{
shirt3 = null;
}
if (ddlQtyShirt4.SelectedValue != "0" && ddlSizeShirt4.SelectedValue != " ")
{
shirt4.ProductID = productID;
shirt4.ProductQty = Convert.ToInt32(ddlQtyShirt4.SelectedValue);
shirt4.ProductPrice = 15.99 * shirt4.ProductQty;
shirt4.PromotionalSize = ddlSizeShirt4.SelectedValue;
shirt4.ProductType = "Promotional";
shirt4.ProductDetail = "I shamrock Shenanigans shirt";
currentPromo = shirt4;
}
else
{
shirt4 = null;
}
cartItems = Cart.AddItemToCart(currentPromo, cartItems);
Session["items"] = cartItems;
Response.Redirect("CartView.aspx");
//double orderTotal = 0;
//if(shirt1 != null)
//{
// shirt1.ProductPrice += orderTotal;
//}
//if (shirt2 != null)
//{
// shirt2.ProductPrice += orderTotal;
//}
//if (shirt3 != null)
//{
// shirt3.ProductPrice += orderTotal;
//}
//if (shirt4 != null)
//{
// shirt4.ProductPrice += orderTotal;
//}
}
// GET: Products
public List <Products> Get()
{
return(ProductsDA.GetProducts());
}
public List <Product> Get()
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
return(ProductsDA.GetProducts(p.Claims));
}
public Product Get(int id)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
return(ProductsDA.GetProduct(id, p.Claims));
}
public HttpResponseMessage Delete(int id)
{
ProductsDA.Remove(id);
return(new HttpResponseMessage(HttpStatusCode.OK));
}
