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