protected void gvToppings_RowEditing(object sender, GridViewEditEventArgs e) { var ctx = new MaryPizzaEntities(); gvToppings.EditIndex = e.NewEditIndex; //gvToppings.DataSource = ctx.Toppings; gvToppings.DataBind(); }
protected void btnAddTopping_Click(object sender, EventArgs e) { var ctx = new MaryPizzaEntities(); Topping newTopping = new Topping(); newTopping.name = tbToppingName.Text; newTopping.active = cbActive.Checked ? "yes" : "no"; ctx.Toppings.Add(newTopping); ctx.SaveChanges(); gvToppings.DataBind(); }
protected void btnOrders_Click(object sender, EventArgs e) { var ctx = new MaryPizzaEntities(); var orders = from Order in ctx.Orders where Order.orderDate >= cdrStart.SelectedDate && Order.orderDate <= cdrEnd.SelectedDate select Order; gvOrders.DataSource = orders.ToList(); gvOrders.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { using (MaryPizzaEntities ctx = new MaryPizzaEntities()) { List<Topping> toppings = new List<Topping>(); foreach (ListItem topping in cblToppings.Items) { if (topping.Selected) { toppings.Add(ctx.Toppings .Where(c => c.name == topping.Text) .Select(c => c) .First()); } } Order order = new Order(); order.firstname = tbFirstName.Text; order.lastName = tbLastName.Text; order.email = tbEmail.Text; order.phone = tbPhone.Text; order.size = ddlPizzaSize.SelectedValue; order.noOfPizzas = Convert.ToInt32(tbNoOfPizza.Text); order.Toppings = toppings; order.delivery = ddlDelivery.SelectedValue; order.orderDate = DateTime.Now; ctx.Orders.Add(order); ctx.SaveChanges(); foreach (ListItem topping in cblToppings.Items) { if (topping.Selected) { Session["Toppings"] += topping.Text + "</br>"; } } Session["FirstName"] = tbFirstName.Text; Session["LastName"] = tbLastName.Text; Session["Email"] = tbEmail.Text; Session["Phone"] = tbPhone.Text; Session["Size"] = ddlPizzaSize.SelectedValue; Session["NoOfPizza"] = tbNoOfPizza.Text; //Session["Toppings"] = toppings; Session["Delivery"] = ddlDelivery.SelectedValue; } Server.Transfer("OrderSubmitted.aspx", false); }
protected void gvToppings_RowUpdating(object sender, GridViewUpdateEventArgs e) { //int ToppingID = (int)gvToppings.DataKeys[e.RowIndex].Value; //TextBox ToppingName = (TextBox)gvToppings.Rows[e.RowIndex].FindControl("Name"); //string = (string)gvToppings.Rows[e.RowIndex].FindControl("txtSurname"); //var entityModel = new MaryPizzaEntities(); //Topping topping = entityModel.Toppings.Where(c => c. == customerId).First(); //customer.Name = txtName.Text; //customer.Surname = txtSurname.Text; //entityModel.SaveChanges(); var ctx = new MaryPizzaEntities(); gvToppings.EditIndex = -1; //gvToppings.DataSource = ctx.Toppings; gvToppings.DataBind(); }