//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 receipt table
private bool SaveReceipt()
{
receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter();
try
{
receiptModifyTableAdapter.Update(dsSales.receiptModify);
dsSales.AcceptChanges();
dsSales.receiptModify.Clear();
receiptModifyTableAdapter.Fill(dsSales.receiptModify);
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) { }
}
