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;
}
}
}
