protected void btnAddItem_Click(object sender, EventArgs e) { if (validFields()) { if (!productExist()) { tblOrderDetails = Cache["tblOrderDetails"] as MyDataSet.OrderDetailsDataTable; tblOrdercf = Cache["tblOrdercf"] as MyDataSet.OrdercfDataTable; Products prod = getProductInformation(); var newRow = tblOrderDetails.NewOrderDetailsRow(); //newRow.OrderDetailId = autoIncrement newRow.Item = int.Parse(ddlProductName.SelectedValue); newRow.Product = ddlProductName.SelectedItem.ToString(); newRow.Price = prod.PPrice; newRow.Quant = int.Parse(txtQuantity.Text); newRow.OrderID = tblOrdercf[0].OrderId; newRow.Num = newRow.Num * -1; tblOrderDetails.AddOrderDetailsRow(newRow); Cache["tblOrderDetails"] = tblOrderDetails; grdOrder.DataSource = tblOrderDetails; grdOrder.DataBind(); } calcTotal(); resetFields(); } }
protected void btnFinalizeOrder_Click(object sender, EventArgs e) { tblOrderDetails = Cache["tblOrderDetails"] as MyDataSet.OrderDetailsDataTable; adpOrderDetails.Update(tblOrderDetails); tblOrdercf = Cache["tblOrdercf"] as MyDataSet.OrdercfDataTable; string subTemp = txtSubtotal.Text.Remove(0, 1); double calcSub = double.Parse(subTemp); subTotal = (decimal)(calcSub); double dTax = 0.13; tax = subTotal * (decimal)(dTax); total = subTotal + tax; tblOrdercf[0].OrderSubTotal = subTotal; tblOrdercf[0].OrderTax = tax; tblOrdercf[0].OrderTotal = total; adpOrdercf.Update(tblOrdercf); UpdateProductTable(); //Response.Redirect("~/OrderForm.aspx"); }
public void createOrder() { tblOrdercf = adpOrdercf.GetData(); int result = adpOrdercf.Insert(DateTime.Now, 0, 0, 0); tblOrdercf = adpOrdercf.GetDataMax(); Cache["tblOrdercf"] = tblOrdercf; OrderId = tblOrdercf[0].OrderId; tblOrderDetails = adpOrderDetails.GetDataByOrderId(OrderId); Cache["tblOrderDetails"] = tblOrderDetails; }
protected void btnSearch_Click(object sender, EventArgs e) { lblErrorMessage.Text = ""; if (String.IsNullOrEmpty(txtOrderNumber.Text)) { lblErrorMessage.Text = "Please enter an order number"; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } else { int id = int.Parse(txtOrderNumber.Text); tblOrdercf = adpAllOrdercf.GetDataByID(id); var row = tblOrdercf; if (row.Count > 0) { if (row != null) { txtDate.Text = row[0].OrderDate.ToString(); txtSubtotal.Text = row[0].OrderSubTotal.ToString(); txtTax.Text = row[0].OrderTax.ToString(); txtTotal.Text = row[0].OrderTotal.ToString(); tblOrderDetails = adpOrderDetails.GetDataByOrderId(id); var rowOrdercf = tblOrderDetails; //lblErrorMessage.Text = rowOrdercf.Count.ToString(); grdOrder.DataSource = null; grdOrder.DataBind(); if (row.Count > 0 && row != null) { grdOrder.DataSource = tblOrderDetails; grdOrder.DataBind(); } if (rowOrdercf.Count == 0) { lblErrorMessage.Text = "This order was not Completed"; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } } } else { lblErrorMessage.Text = " Order ID " + id + " not found"; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } } }