protected void btnSubmitOrder_Click(object sender, EventArgs e) { // instantiate object for access to methods // clsCustomers c = new clsCustomers(); try { // First enter into orders table // // get customerID int custID = Convert.ToInt32(Session["customerID"]); // set order status to pending for order // string status = "pending"; // submit order to Orders table // c.submitOrder(custID, status); // 2. get order ID and submit order details // variable to store current order ID of order int orderNumber; // method to access customer's newly placed order // orderNumber = c.getOrderedID(custID); // convert product ID to int // //int itemID = Convert.ToInt32(lblPoduct.Text); // variable to store the product's ID // int proID = Convert.ToInt32(Request.QueryString["productType"]); // get product name by its ID // string proName = c.getDdlProductName(proID); // get customer quantity // int custQty = Convert.ToInt32(lblQuantity.Text); // calculate grand total // decimal gTotal; int ttlAmtItems = Convert.ToInt32(lblQuantity.Text); decimal costPerItem = Convert.ToDecimal(lblCostPerItem.Text); gTotal = ttlAmtItems * costPerItem; // get/set customer text // string description = lblTextDesc.Text; string fileUploadNm = " "; c.submitOrderDetails(orderNumber, custID, proID, proName, custQty, costPerItem, gTotal, description, fileUploadNm); // inform customer that order was submitted and return confirmation and confirmation number (order number) // lblOrderSuccess.Text = "Order successfully submitted, confirmation number: " + orderNumber.ToString(); // btnSubmitOrder.Visible = false; lnkGoBack.Visible = false; lnkPlaceOrder.Visible = true; // 3. } catch (Exception ex) { string error = "Error occurred please try again later.. " + ex.ToString(); lblError.Text = error; //error + ex.ToString(); } } /* btnSubmitOrder_Click() */
} /* end Page_Load() */ protected void btnSubmit_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { try { // get access to methods from class // clsCustomers c = new clsCustomers(); // get customer ID and convert to INT // int custID = Convert.ToInt32(Session["customerID"]); // get the file name in to filename variable and get file extension // string filename = Path.GetFileName(FileUpload1.FileName); string extension = Path.GetExtension(filename); // get current date/time/second // string getCurrentDate = DateTime.Now.ToString("_yyy-MM-dd-h-mm-tt"); // set order status to pending for order // string status = "pending"; // submit order to Orders table // c.submitOrder(custID, status); int orderNumber; // method to access customer's newly placed order // orderNumber = c.getOrderedID(custID); // variable to store the product's ID // int proID = Convert.ToInt32(Request.QueryString["printType"]); // get product name by its ID // string proName = c.getDdlProductName(proID); // calculate the grand total // int ttlAmtItems = Convert.ToInt32(Request.QueryString["qty"]); decimal gTotal; decimal costPerItem = Convert.ToDecimal(lblPricePerPage.Text); gTotal = ttlAmtItems * costPerItem; // get customer quantity // int custQty = ttlAmtItems; // get the customer input text // string description = lblDesc.Text; string fullFileNameAndDate = filename + getCurrentDate + extension; // save the selected file to the specified folder // FileUpload1.SaveAs(Server.MapPath("PrintJobUploads/") + fullFileNameAndDate); // insert order to orderDetails table // c.submitOrderDetails(orderNumber, custID, proID, proName, ttlAmtItems, costPerItem, gTotal, description, fullFileNameAndDate); // get file name for input to database // lblUploadSuccess.Text = "File has been successfully uploaded to: " + filename + getCurrentDate + extension; // inform customer that order was submitted and return confirmation and confirmation number (order number) // lblUploadSuccess.Text = "Order successfully submitted, confirmation number: " + orderNumber.ToString(); btnSubmit.Visible = false; lnkGoBack.Visible = false; lnkPlaceOrder.Visible = true; FileUpload1.Visible = false; } /* end try{} */ catch (Exception ex) { lblUploadSuccess.Text = "Error occurred: " + ex.ToString(); } /* end catch{} */ } /* end if statement */ }