//save change to database private bool Save() { equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter(); order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter(); service_orderTableAdapter service_OrderTableAdapter = new service_orderTableAdapter(); receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter(); customerModifyTableAdapter customerModifyTableAdapter = new customerModifyTableAdapter(); try { order_LineTableAdapter.Update(dsSales.order_line); service_OrderTableAdapter.Update(dsSales.service_order); receiptModifyTableAdapter.Update(dsSales.receiptModify); equipmentModifyTableAdapter.Update(dsSales.equipmentModify); customerModifyTableAdapter.Update(dsSales.customerModify); dsSales.AcceptChanges(); dsSales.customerModify.Clear(); dsSales.receiptModify.Clear(); dsSales.order_line.Clear(); dsSales.service_order.Clear(); dsSales.equipmentModify.Clear(); customerModifyTableAdapter.Fill(dsSales.customerModify); receiptModifyTableAdapter.Fill(dsSales.receiptModify); order_LineTableAdapter.Fill(dsSales.order_line); service_OrderTableAdapter.Fill(dsSales.service_order); equipmentModifyTableAdapter.Fill(dsSales.equipmentModify); return(true); } catch { dsSales.RejectChanges(); return(false); } }
static SalesReceipt() { ProductsTableAdapter productsTableAdapter = new ProductsTableAdapter(); servicesTableAdapter servicesTableAdapter = new servicesTableAdapter(); receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter(); order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter(); try { receiptModifyTableAdapter.Fill(dsSales.receiptModify); productsTableAdapter.Fill(dsSales.Products); servicesTableAdapter.Fill(dsSales.services); order_LineTableAdapter.Fill(dsSales.order_line); } catch (Exception) { } }
//method to save changes back to the order_line table private bool SaveOrder() { order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter(); try { order_LineTableAdapter.Update(dsSales.order_line); dsSales.AcceptChanges(); dsSales.order_line.Clear(); order_LineTableAdapter.Fill(dsSales.order_line); return(true); } catch { dsSales.RejectChanges(); return(false); } }
static SalesSearch() { dsSales = new dsSales(); customerModifyTableAdapter customerModifyTableAdapter = new customerModifyTableAdapter(); equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter(); receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter(); order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter(); service_orderTableAdapter service_OrderTableAdapter = new service_orderTableAdapter(); try { customerModifyTableAdapter.Fill(dsSales.customerModify); equipmentModifyTableAdapter.Fill(dsSales.equipmentModify); receiptModifyTableAdapter.Fill(dsSales.receiptModify); order_LineTableAdapter.Fill(dsSales.order_line); service_OrderTableAdapter.Fill(dsSales.service_order); } catch (Exception) { } }
static Purchase() { receiptTableAdapter daReceipt = new receiptTableAdapter(); daReceipt.Fill(dsReceipt.receipt); employeeTableAdapter daEmployee = new employeeTableAdapter(); daEmployee.Fill(dsReceipt.employee); productTableAdapter daProducts = new productTableAdapter(); productTable = daProducts.GetData(); order_lineTableAdapter daLine = new order_lineTableAdapter(); daLine.Fill(dsReceipt.order_line); service_orderTableAdapter daService = new service_orderTableAdapter(); daService.Fill(dsReceipt.service_order); equipmentTableAdapter daEqu = new equipmentTableAdapter(); daEqu.Fill(dsReceipt.equipment); }
protected void submit_Click(object sender, EventArgs e) { DataRow r = dsReceipt.receipt.NewRow(); r["custID"] = ListBox2.SelectedValue; r["empID"] = dsReceipt.employee.Select("empLogin = '******'")[0]["id"]; r["ordDate"] = DateTime.Now; r["paymentID"] = ddlPayment.SelectedValue; dsReceipt.receipt.Rows.Add(r); object adapter = null; List <DataRow> ChildRows = new List <DataRow>(); DataTable childTable = null; if (Mode == PageMode.Sale) { childTable = dsReceipt.order_line; for (int i = 0; i < selectedProducts?.Rows.Count; i++) { if (Convert.ToInt32(Request.Form["ctl00$MainContent$gvSelectedProductsSales$ctl0" + (i + 2).ToString() + "$TextBox1"]) > 0) { DataRow l = dsReceipt.order_line.NewRow(); l["inventoryID"] = selectedProducts.Rows[i]["id"]; l["orlQuantity"] = Request.Form["ctl00$MainContent$gvSelectedProductsSales$ctl0" + (i + 2).ToString() + "$TextBox1"]; l["orlOrderReq"] = Convert.ToInt16(l["orlQuantity"]) > Convert.ToInt32(selectedProducts.Rows[i]["Stock"]); l["orlPrice"] = Convert.ToBoolean(l["orlOrderReq"]) ? Convert.ToDouble(selectedProducts.Rows[i]["Price"]) * 1.01 : Convert.ToDouble(selectedProducts.Rows[i]["Price"]); ChildRows.Add(l); } } adapter = new order_lineTableAdapter(); if (ChildRows.Count == 0) { dsReceipt.RejectChanges(); lblError.Text = "Please select at least one item to purchase"; return; } } else if (Mode == PageMode.Repair) { childTable = dsReceipt.service_order; DataRow eq = dsReceipt.equipment.NewRow(); eq["equModel"] = txtModel.Text; eq["equSerial"] = txtSerialNumber.Text; eq["custID"] = r["custID"]; eq["equtypeID"] = ddlType.SelectedValue; eq["equManuID"] = ddlManu.SelectedValue; dsReceipt.equipment.Rows.Add(eq); equipmentTableAdapter daEqu = new equipmentTableAdapter(); daEqu.Update(dsReceipt.equipment); DataRow so = dsReceipt.service_order.NewRow(); so["serordDateIn"] = DateTime.Now; so["serordIssue"] = RD.Text; so["serordWarranty"] = RadioButtonList1.SelectedValue == "1"; so["serviceID"] = ddlService.SelectedValue; //for reasons passing understanding, //the equipment table adapter does not update the id column in the dataset, //while the receipt adapter does so["equipID"] = Convert.ToInt32(dsReceipt.equipment.Max(row => row["id"])) + 1; ChildRows.Add(so); adapter = new service_orderTableAdapter(); } receiptTableAdapter daReceipt = new receiptTableAdapter(); daReceipt.Update(dsReceipt.receipt); foreach (DataRow cr in ChildRows) { cr["receiptId"] = r["id"]; childTable.Rows.Add(cr); } if (adapter is service_orderTableAdapter daService) { daService.Update(dsReceipt.service_order); } else if (adapter is order_lineTableAdapter daOrder) { daOrder.Update(dsReceipt.order_line); } dsReceipt.AcceptChanges(); Response.Redirect("~/Default"); }