protected void btnStatus_Click(object sender, EventArgs e) { HtmlButton btnStatus = (HtmlButton)sender; string receiptID = btnStatus.Attributes["value"]; DataRow sale = dsSales.Receipt.Select("id = " + receiptID)[0]; if (!(bool)sale.ItemArray[3]) //if not paid { sale["ordPaid"] = true; daReceipt.Update(dsSales.Receipt); dsSales.AcceptChanges(); } else if (User.IsInRole("Admin")) { sale["ordPaid"] = false; daReceipt.Update(dsSales.Receipt); dsSales.AcceptChanges(); } btnStatus.InnerText = "Paid"; if (!User.IsInRole("Admin")) //if not admin { btnStatus.Attributes.Add("disabled", "disabled"); } }
protected void btnDeleteConfirm_Click(object sender, EventArgs e) { DataRow[] orders = sale.GetChildRows("fk_orderline_receipt"); DataRow[] repairs = sale.GetChildRows("fk_serord_receipt"); foreach (DataRow o in orders) { o.Delete(); } foreach (DataRow r in repairs) { r.Delete(); } daOL.Update(dsSales.OrderLine); daServiceOrder.Update(dsSales.ServiceOrder); sale.Delete(); daReceipt.Update(dsSales.Receipt); dsSales.AcceptChanges(); Response.Redirect("~/Sales/"); }
protected void btnModify_Click(object sender, EventArgs e) { if (ddlCustomer.SelectedValue == "" || ddlPayment.SelectedValue == "") { return; } Dictionary <int, Order> orders = (Dictionary <int, Order>)Session["newOrders"]; //get saved orders DataRow sale; if (Request.QueryString["Mode"] != "Edit") { DateTime now = DateTime.Now; sale = dsSales.Receipt.NewRow(); sale["ordNumber"] = now.ToString("MMddHHmm"); sale["ordPaid"] = false; sale["empID"] = ddlEmployee.SelectedValue; } else { sale = dsSales.Receipt.FindByid(Convert.ToInt32(Request.QueryString["ID"])); } sale["ordDate"] = txtDate.Text; sale["paymentID"] = ddlPayment.SelectedValue; sale["custID"] = ddlCustomer.SelectedValue; if (Request.QueryString["Mode"] != "Edit") { dsSales.Receipt.Rows.Add(sale); } daReceipts.Update(dsSales.Receipt); if (lsbOrders.Items.Count > 0) { foreach (Order order in orders.Values) { DataRow nrOrder = dsSales.OrderLine.NewRow(); DataRow inv = dsSales.Inventory.Select("productID = " + order.productID)[0]; int stock = Convert.ToInt32(inv.ItemArray[1]); double invPrice = Convert.ToDouble(inv.ItemArray[4]); int inventoryID = Convert.ToInt32(inv.ItemArray[0]); if (order.qty <= stock) { nrOrder["orlPrice"] = invPrice * order.qty * 1.11; //price +10% +1% nrOrder["orlQuantity"] = order.qty; //quantity nrOrder["orlOrderReq"] = false; //not new order nrOrder["orlNote"] = order.note; //note nrOrder["inventoryID"] = inventoryID; //inventoryID nrOrder["receiptID"] = sale.ItemArray[0]; //receiptID //update orderline dsSales.OrderLine.Rows.Add(nrOrder); //update inventory inv["invQuantity"] = stock - order.qty; } else { //in stock part nrOrder["orlPrice"] = invPrice * stock * 1.11; //price (in stock part) +10% +1% nrOrder["orlQuantity"] = stock; //quantity (in stock part) nrOrder["orlOrderReq"] = false; //in stock part nrOrder["orlNote"] = order.note + " (In Stock)"; //note nrOrder["inventoryID"] = inventoryID; //inventoryID nrOrder["receiptID"] = sale.ItemArray[0]; //receiptID //update db dsSales.OrderLine.Rows.Add(nrOrder); //Order New part DataRow orderNew = dsSales.OrderLine.NewRow(); orderNew["orlPrice"] = invPrice * (order.qty - stock) * 1.01; //price (Order New part) +1% orderNew["orlQuantity"] = order.qty - stock; //quantity (Order New part) orderNew["orlOrderReq"] = true; //Order New part orderNew["orlNote"] = order.note + " (Order New)"; //note orderNew["inventoryID"] = inventoryID; //inventoryID orderNew["receiptID"] = sale.ItemArray[0]; //receiptID //update orderline dsSales.OrderLine.Rows.Add(orderNew); //update inventory inv["invQuantity"] = 0; } } } daOL.Update(dsSales.OrderLine); daInventory.Update(dsSales.Inventory); dsSales.AcceptChanges(); Response.Redirect("SaleRecord.aspx?ID=" + sale.ItemArray[0].ToString()); }