//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 SalesNew() { dsSales = new dsSales(); customerModifyTableAdapter customerModifyTableAdapter = new customerModifyTableAdapter(); equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter(); try { customerModifyTableAdapter.Fill(dsSales.customerModify); equipmentModifyTableAdapter.Fill(dsSales.equipmentModify); } catch (Exception) { } }
//update eqipment to database private bool SaveEquipment() { equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter(); try { equipmentModifyTableAdapter.Update(dsSales.equipmentModify); dsSales.AcceptChanges(); dsSales.equipmentModify.Clear(); equipmentModifyTableAdapter.Fill(dsSales.equipmentModify); 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) { } }