public ActionResult SearcU(Users user)
{
// var repo = new UserRepository(new PizzaPalacedbContext(optionsBuilder.Options));
var users = Repo.GetUsertable(); // Get all user
var userorder = users.Where(g => g.FirstName == user.FirstName); // searching user
var userID = user.Id; // user ID
var won = Repo.GetOrdersTable(); // Get all Order
var order = won.Where(q => q.UserIdfk == userID); // All user order
var pizzas = Repo.GetPizza(); // Get all Pizza
var PizzasUser = pizzas.Where(q => q.OrdersIdfk == userID); // pizza of order
if (userorder == null)
{
TempData["Error"] = "Error: User not found";
return(View());
}
else
{
PizzaOrders OTPT = new PizzaOrders
{
OT = order,
PT = PizzasUser,
UT = userorder
};
return(View(OTPT));
}
}
public ActionResult SuggestedOrder(Users user)
{
// var repo = new UserRepository(new PizzaPalacedbContext(optionsBuilder.Options));
var users = Repo.GetUsertable(); // Get all user
var userorder2 = users.FirstOrDefault(g => g.FirstName == user.FirstName && g.LastName == user.LastName && g.PhoneNumber == user.PhoneNumber); // select user
if (userorder2 == null)
{
ModelState.AddModelError("", "Error: Order not found");
return(View());
}
else if (userorder2 != null)
{
var userorder = users.Where(g => g.FirstName == user.FirstName && g.LastName == user.LastName && g.PhoneNumber == user.PhoneNumber); // searching user
var userID = userorder2.Id; // user ID
var won = Repo.GetOrdersTable(); // Get all Order
var order = won.Where(q => q.UserIdfk == userID); // All user order
var pizzas = Repo.GetPizza(); // Get all Pizza
var PizzasUser = pizzas.Where(q => q.OrdersIdfk == userID); // pizza of order
var lastorder = won.LastOrDefault(q => q.UserIdfk == userID); // last order
var lastPizzasUser = pizzas.LastOrDefault(q => q.OrdersIdfk == lastorder.OrderId); // last pizza of order
PizzaOrders OTPT = new PizzaOrders
{
OT = order,
PT = PizzasUser,
UT = userorder
};
ViewData["lastorder"] = lastorder;
ViewData["lastPizzasUser"] = lastPizzasUser;
return(View());
}
return(View());
}
public void CreateOrder(PizzaOrders orders)
{
var requestedOrders = orders.OrderItems;
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
var orderCode = GetOrderCode(orders.UserName);
string orderQuery = "insert into [order] values(" + "'" + orders.UserName + "'" + "," + "'" + orderCode + "'" + ");";
SqlCommand command1 = new SqlCommand(orderQuery, connection, transaction);
SqlCommand command2 = null;
try
{
command1.ExecuteNonQuery();
foreach (var item in requestedOrders)
{
string orderItemQuery = "insert into [orderItem] values(" + item.Id + "," + "'" + orderCode + "'" + ");";
command2 = new SqlCommand(orderItemQuery, connection, transaction);
command2.ExecuteNonQuery();
}
Commit(transaction);
}
catch (Exception ex)
{
Rollback(transaction);
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
PizzaOrders temp = new PizzaOrders();
temp.Order_ID = Convert.ToInt32(lblOrder_ID.Text);
lblFeedback.Text = temp.DeleteOneOrder(temp.Order_ID) + " Order Deleted.";
}
protected void btnSearch_Click(object sender, EventArgs e)
{
PizzaOrders temp = new PizzaOrders();
DataSet ds = temp.SearchOrders(txtFirstName.Text, txtLastName.Text);
gvOrders.DataSource = ds;
gvOrders.DataMember = ds.Tables[0].TableName;
gvOrders.DataBind();
}
// Adds values to the junction table
public void AddPizzaOrders(int orderId, int PizzaId)
{
PizzaOrders po = new PizzaOrders
{
OrderId = orderId,
PizzaId = PizzaId
};
_db.PizzaOrders.Add(po);
}
public IActionResult Index()
{
ViewBag.Message = "PizzaOrderController";
PizzaOrders OTPT = new PizzaOrders
{
OT = Repo.GetOrdersTable(),
PT = Repo.GetPizza(),
UT = Repo.GetUsertable()
};
return(View(OTPT));
}
public void UpdateOrder(PizzaOrders orders)
{
var listedId = new List <OrderItems>();
var requestedOrders = orders.OrderItems;
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
string orderUpdatequery = "update [order] set username="******"'" + orders.UserName + "'" + " where OrderCode =" + "'" + orders.OrderCode + "'" + ";";
SqlCommand command1 = new SqlCommand(orderUpdatequery, connection, transaction);
string oldItems = "select Id from [orderItem] with(nolock) where OrderCode = " + "'" + orders.OrderCode + "'" + " ;";
SqlCommand command2 = new SqlCommand(oldItems, connection, transaction);
using (SqlDataReader dataReader = command2.ExecuteReader())
{
while (dataReader.Read())
{
listedId.Add(new OrderItems()
{
Id = dataReader.GetInt32(dataReader.GetOrdinal("Id"))
});
}
}
try
{
command1.ExecuteNonQuery();
var records = listedId.Zip(requestedOrders, (n, w) => new { OrderItemIds = n, updatedRecords = w });
foreach (var item in records)
{
string updateOrderItem = "update [orderItem] set pizzaId = " + item.updatedRecords.Id + " where Id = " + item.OrderItemIds.Id + "";
SqlCommand command3 = new SqlCommand(updateOrderItem, connection, transaction);
command3.ExecuteNonQuery();
}
Commit(transaction);
}
catch (Exception ex)
{
Rollback(transaction);
}
}
}
public void NewPizza( )
{
if (currentPizzaObject != null) //not first run
{
//store old pizza
TotalPizzaScores.Add(theOrder.ScorePizza());
PizzaList.Add(currentPizza);
PizzaObjects.Add(currentPizzaObject);
currentPizzaObject.transform.position = new Vector3(0, 0, 20f);
currentPizzaObject.SetActive(false);
}
else //first run
{
}
//_BW TODO addcomponenet/getcomponent all expensive at runtime - especially in UPDATE
currentPizzaObject = (GameObject)Instantiate(dough, DoughSpawnPoint.position, Quaternion.identity);
// currentPizzaObject.transform.localScale = new Vector3(2.5f, 1f, 2.5f);
doughMeshScript = currentPizzaObject.GetComponentInChildren <MeshFix>();
theOrder = currentPizzaObject.gameObject.AddComponent <PizzaOrders>();
theOrder.CreateOrder();
if (theOrder.PizzaOrderSize == Constants.PizzaSizes.small)
{
currentPizzaObject.transform.localScale = Constants.SMALL_PIZZA_SCALE;
}
else if (theOrder.PizzaOrderSize == Constants.PizzaSizes.medium)
{
currentPizzaObject.transform.localScale = Constants.MEDIUM_PIZZA_SCALE;
}
else if (theOrder.PizzaOrderSize == Constants.PizzaSizes.large)
{
currentPizzaObject.transform.localScale = Constants.LARGE_PIZZA_SCALE;
}
//_ME cleaned up this a bit
//
//currentPizzaObject.gameObject.GetComponent<PizzaOrders>().CreateOrder();
//currentPizzaObject.gameObject.AddComponent<PizzaClass>();
//currentPizza = currentPizzaObject.GetComponent<PizzaClass>();
currentPizza = currentPizzaObject.gameObject.AddComponent <PizzaClass>();
theOrder.DeliverPizza(currentPizza);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
lblOrder.Text = "";
pizzaPrice = 0;
toppingPrice = 0;
pizzaTopping = "";
PizzaOrders temp = new PizzaOrders();
if (rbSmall.Checked == true)
{
pizzaSize.Text = "Small";
pizzaPrice = 7;
}
else if (rbMedium.Checked == true)
{
pizzaSize.Text = "Medium";
pizzaPrice = 10;
}
else
{
pizzaSize.Text = "Large";
pizzaPrice = 12;
}
if (chkPepperoni.Checked)
{
pizzaTopping += "Pepperoni";
toppingPrice += .50;
}
if (chkSausage.Checked)
{
pizzaTopping += " Sausage";
toppingPrice += .50;
}
if (chkMeatball.Checked)
{
pizzaTopping += " Meatball";
toppingPrice += .50;
}
if (chkHam.Checked)
{
pizzaTopping += " Ham";
toppingPrice += .50;
}
if (chkPeppers.Checked)
{
pizzaTopping += " Peppers";
toppingPrice += .50;
}
if (chkOnions.Checked)
{
pizzaTopping += " Onions";
toppingPrice += .50;
}
if (chkOlives.Checked)
{
pizzaTopping += " Olives";
toppingPrice += .50;
}
if (chkSpinach.Checked)
{
pizzaTopping += " Spinach";
toppingPrice += .50;
}
if (chkPineapple.Checked)
{
pizzaTopping += " Pineapple";
toppingPrice += .50;
}
if (chkBBQSauce.Checked)
{
pizzaTopping += " BBQ Sauce";
toppingPrice += .50;
}
if (chkExtraCheese.Checked)
{
pizzaTopping += " Extra Cheese";
toppingPrice += .50;
}
temp.PizzaSize = pizzaSize.Text;
temp.Toppings = pizzaTopping;
temp.FirstName = txtFirstName.Text;
temp.LastName = txtLastName.Text;
temp.Street1 = txtStreet1.Text;
temp.Street2 = txtStreet2.Text;
temp.City = ddlCity.SelectedItem.ToString();
temp.State = ddlState.SelectedItem.ToString();
temp.ZipCode = txtZipCode.Text;
temp.Phone = txtPhone.Text;
temp.Email = txtEmail.Text;
temp.TotalCost = pizzaPrice + toppingPrice;
// Add Total Price to Order Label
lblOrder.Text += (pizzaPrice + toppingPrice).ToString("c");
// Display Order info in ListBox
lbxOrder.Items.Add("Your Order:");
lbxOrder.Items.Add(pizzaSize.Text + " Pizza with" + pizzaTopping);
lbxOrder.Items.Add("Delivery Info:");
lbxOrder.Items.Add(txtFirstName.Text + " " + txtLastName.Text);
lbxOrder.Items.Add(txtStreet1.Text + " " + txtStreet2.Text);
lbxOrder.Items.Add(ddlCity.SelectedItem.Text + ", " + ddlState.SelectedItem.Text + ", " + txtZipCode.Text);
// store ID of the person being updated
temp.Order_ID = Convert.ToInt32(lblOrder_ID.Text);
lblFeedback.Text = temp.UpdateAnOrder().ToString() + " Order Updated.";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["LoggedIn"] != null && Session["LoggedIn"].ToString() == "TRUE")
{
//do nothing...they are good
}
else
{
Response.Redirect("Default.aspx");
}
string strOrd_ID = "";
int intOrd_ID = 0;
//Does Per_ID Exist?
if ((!IsPostBack) && Request.QueryString["Ord_ID"] != null)
{
// if this is an update, hide submit button
btnSubmit.Visible = false;
//If so...Gather Person's ID and Fill Form
strOrd_ID = Request.QueryString["Ord_ID"].ToString();
lblOrder_ID.Text = strOrd_ID;
intOrd_ID = Convert.ToInt32(strOrd_ID);
//Fill the "temp" order's info based on ID
PizzaOrders temp = new PizzaOrders();
SqlDataReader dr = temp.FindOneOrder(intOrd_ID);
while (dr.Read())
{
string pSize = dr["PizzaSize"].ToString();
if (pSize == "Small")
{
rbSmall.Checked = true;
}
else if (pSize == "Medium")
{
rbMedium.Checked = true;
}
else if (pSize == "Large")
{
rbLarge.Checked = true;
}
pizzaSize.Text = dr["PizzaSize"].ToString();
string pTopping = dr["Toppings"].ToString();
if (pTopping.Contains("Pepperoni"))
{
chkPepperoni.Checked = true;
}
if (pTopping.Contains("Sausage"))
{
chkSausage.Checked = true;
}
if (pTopping.Contains("Meatball"))
{
chkMeatball.Checked = true;
}
if (pTopping.Contains("Ham"))
{
chkHam.Checked = true;
}
if (pTopping.Contains("Peppers"))
{
chkPeppers.Checked = true;
}
if (pTopping.Contains("Onions"))
{
chkOnions.Checked = true;
}
if (pTopping.Contains("Olives"))
{
chkOlives.Checked = true;
}
if (pTopping.Contains("Spinach"))
{
chkSpinach.Checked = true;
}
if (pTopping.Contains("Pineapple"))
{
chkPineapple.Checked = true;
}
if (pTopping.Contains("BBQ Sauce"))
{
chkBBQSauce.Checked = true;
}
if (pTopping.Contains("Extra Cheese"))
{
chkExtraCheese.Checked = true;
}
pizzaTopping = dr["Toppings"].ToString();
txtFirstName.Text = dr["FirstName"].ToString();
txtLastName.Text = dr["LastName"].ToString();
txtStreet1.Text = dr["Street1"].ToString();
txtStreet2.Text = dr["Street2"].ToString();
ddlCity.SelectedValue = dr["City"].ToString();
ddlState.SelectedValue = dr["State"].ToString();
txtZipCode.Text = dr["ZipCode"].ToString();
txtPhone.Text = dr["Phone"].ToString();
txtEmail.Text = dr["Email"].ToString();
lblOrder.Text = dr["TotalCost"].ToString();
}
}
else
{
//Do nothing....basic add page (empty)
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
// Clear Order Total Label
lblOrder.Text = "";
bool isValid = true;
// Check if First Name is filled in
if (!ValidationLibrary.IsItFilledIn(txtFirstName.Text))
{
isValid = false;
}
// Check if Last Name is filled in
if (!ValidationLibrary.IsItFilledIn(txtLastName.Text))
{
isValid = false;
}
// Check if Email Address is Valid
if (!ValidationLibrary.IsValidEmail(txtEmail.Text))
{
isValid = false;
}
// Check if Phone Number is Valid
if (!ValidationLibrary.IsValidPhoneNumber(txtPhone.Text))
{
isValid = false;
}
if (isValid == true && Page.IsValid)
{
PizzaOrders temp = new PizzaOrders();
temp.PizzaSize = pizzaSize.Text;
temp.Toppings = pizzaTopping;
temp.FirstName = txtFirstName.Text;
temp.LastName = txtLastName.Text;
temp.Street1 = txtStreet1.Text;
temp.Street2 = txtStreet2.Text;
temp.City = ddlCity.SelectedItem.ToString();
temp.State = ddlState.SelectedItem.ToString();
temp.ZipCode = txtZipCode.Text;
temp.Phone = txtPhone.Text;
temp.Email = txtEmail.Text;
temp.TotalCost = pizzaPrice + toppingPrice;
// Display errors or results in Feedback Label
if (temp.Feedback.Contains("ERROR:"))
{
lblFeedback.Text = temp.Feedback;
}
else
{
// FillLabel(temp);
lblFeedback.Text = temp.AddOrder();
// Add Total Price to Order Label
lblOrder.Text += (pizzaPrice + toppingPrice).ToString("c");
// Display Order info in ListBox
lbxOrder.Items.Add("Your Order:");
lbxOrder.Items.Add(pizzaSize.Text + " Pizza with" + pizzaTopping);
lbxOrder.Items.Add("Delivery Info:");
lbxOrder.Items.Add(txtFirstName.Text + " " + txtLastName.Text);
lbxOrder.Items.Add(txtStreet1.Text + " " + txtStreet2.Text);
lbxOrder.Items.Add(ddlCity.SelectedItem.Text + ", " + ddlState.SelectedItem.Text + ", " + txtZipCode.Text);
}
}
}
public void UpdateOrder([FromBody] PizzaOrders orders)
{
PizzaService service = new PizzaService(Configuration);
service.UpdateOrder(orders);
}
