protected void btnSave_Click() { //order inputs have been validated //save the order using (MarcDatabase objEnt = new MarcDatabase()) { //create a new order object from EF Order objS; Order_Detail objO; //make sure we have a productID if (!String.IsNullOrWhiteSpace(Request.QueryString["ProductID"])) { objS = new Order(); //fill the object properties from our UI objS.CustomerID = TextBoxProductName.Text; objS.EmployeeID = 1; objS.Freight = 20; objS.OrderDate = DateTime.Now; objS.RequiredDate = DateTime.Now; objS.ShippedDate = DateTime.Now; objS.ShipVia = int.Parse(TextBoxProductName.Text); objS.ShipName = TextBoxShipName.Text; objS.ShipAddress = TextBoxShipAddress.Text; objS.ShipCity = TextBoxShipCity.Text; objS.ShipRegion = TextBoxShipRegion.Text; objS.ShipPostalCode = TextBoxPostalCode.Text; objS.ShipCountry = TextBoxShipCountry.Text; //add the new order to the database objEnt.Orders.Add(objS); //additonally, we need to create a related OrderDetail entry objO = new Order_Detail(); //fill the object properties from our UI int ProductID; int.TryParse(Request.QueryString["ProductID"].ToString(), out ProductID); objO.ProductID = ProductID; objO.UnitPrice = decimal.Parse(TextBoxUnitPrice.Text); objO.Quantity = short.Parse(TextBoxQuantity.Text); objO.Discount = 0; //add the new order detail to the database objEnt.Orders.Add(objS); } } //redirect to the order confirmed page Response.Redirect("Order_Confirm.aspx"); }
protected void getProduct() { //get the selected ID from the url int ProductID; //if the id is an integer, look up the supplier to populate the form if (int.TryParse(Request.QueryString["ProductID"].ToString(), out ProductID)) { using (MarcDatabase objEnt = new MarcDatabase()) { Product objS = objEnt.Products.Where(s => s.ProductID == ProductID).FirstOrDefault(); //fill the form controls from the model TextBoxProductName.Text = objS.ProductName; TextBoxUnitPrice.Text = objS.UnitPrice.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { try { //use ef to fill the grid using (MarcDatabase objEnt = new MarcDatabase()) { var data = from Product in objEnt.Products select Product; //fill the grid grdProducts2.DataSource = data.ToList(); grdProducts2.DataBind(); } } catch (Exception objError) { CException.EmailException(objError); Response.Redirect("error.aspx"); } }