protected void Page_Load(object sender, EventArgs e) { if (int.TryParse(Request.QueryString["Id"], out var id)) { var order = DataUtilityClass.SelectOrderById(id); var customer = DataUtilityClass.SelectCustomerById(order.CustId); if (customer != null) { tbxCustId.Text = customer.Id.ToString(); tbxName.Text = customer.First + " " + customer.Last; tbxOrder.Text = ""; tbxOrder.Text += order.Prod1Qty > 0 ? order.Prod1Qty + " Cheese Pizza $11.99 ea\n" : ""; tbxOrder.Text += order.Prod2Qty > 0 ? order.Prod2Qty + " Stromboli $8.99 ea\n" : ""; tbxOrder.Text += order.Prod3Qty > 0 ? order.Prod3Qty + " Hot Chicken Wings (dozen) $9.99 ea\n" : ""; tbxOrder.Text += order.Prod4Qty > 0 ? order.Prod4Qty + " BBQ Chicken Wings (dozen) $9.99 ea\n" : ""; tbxOrder.Text += order.Prod5Qty > 0 ? order.Prod5Qty + " Spaghetti Dinner $11.99 ea\n" : ""; tbxOrder.Text += order.Prod6Qty > 0 ? order.Prod6Qty + " Salad $9.99 ea" : ""; tbxDate.Text = order.OrderDate; tbxTime.Text = order.OrderTime; tbxSubtotal.Text = order.SubTotal.ToString("C"); tbxTax.Text = order.TaxAmt.ToString("C"); tbxGrandTotal.Text = order.GrandTotal.ToString("C"); } else { Response.Redirect("CustomerViewAll.aspx"); } } else { Response.Redirect("CustomerViewAll.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (int.TryParse(Request.QueryString["Id"], out var id)) { var customer = DataUtilityClass.SelectCustomerById(id); if (customer != null) { tbxId.Text = id.ToString(); tbxFirstName.Text = customer.First; tbxLastName.Text = customer.Last; tbxStreetAddress.Text = customer.Street; tbxCity.Text = customer.City; tbxState.Text = customer.State; tbxZipCode.Text = customer.Zip; tbxPhoneNumber.Text = customer.Phone; tbxPhoneType.Text = customer.PhoneType; } else { Response.Redirect("CustomerViewAll.aspx"); } } else { Response.Redirect("CustomerViewAll.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (DataUtilityClass.SelectOrderCount() == 0) { lblTableInformation.Text = "No orders have been added."; gvOrders.Visible = false; } else { lblTableInformation.Text = "Order List"; } }
protected void btnSubmit_Click(object sender, EventArgs e) { var custId = Convert.ToInt32(DDCustomer.SelectedValue); var orderdate = DateTime.Today.ToShortDateString(); var ordertime = DateTime.Now.ToShortTimeString(); DataUtilityClass.InsertOrder( new Order(Convert.ToInt32(custId), orderdate, ordertime, _prod1Qty, _prod2Qty, _prod3Qty, _prod4Qty, _prod5Qty, _prod6Qty, _subTotal, _taxAmt, _grandTotal)); lblNotification.Text = "Order is successfully sumited."; lblNotification.ForeColor = Color.Green; lblNotification.Visible = true; Reset(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var customerList = DataUtilityClass.SelectAllCustomers(); foreach (var customer in customerList) { DDCustomer.Items.Add(new ListItem(customer.Id + ": " + customer.First + " " + customer.Last, customer.Id.ToString())); } } Page.MaintainScrollPositionOnPostBack = true; }
protected void btnAddCustomer_Click(object sender, EventArgs e) { ClearError(); if (!FieldsIsValid()) { return; } var firstName = UppercaseFirstLetterPerWord(tbxFirstName.Text); var lastName = UppercaseFirstLetterPerWord(tbxLastName.Text); var streetAddress = UppercaseFirstLetterPerWord(tbxStreetAddress.Text); var city = UppercaseFirstLetterPerWord(tbxCity.Text); var state = UppercaseFirstLetterPerWord(tbxState.Text); var zipCode = tbxZipCode.Text; var phoneNumber = tbxPhoneNumber.Text; var phoneType = DDPhoneType.SelectedValue; DataUtilityClass.InsertCustomer( new Customer(firstName, lastName, streetAddress, city, state, zipCode, phoneNumber, phoneType)); lblNotification.Visible = true; ClearFields(); }