//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) { }
}