public decimal LoadOfferings()
        {
            decimal sum = 0;
            try
            {
                int n = 1;
                da = new DataAccess();
                List<SpareInSpareIncomeView> items = da.GetIncomesByIncomeID(this._id);
                foreach (SpareInSpareIncomeView i in items)
                {
                    i.num = n;
                    sum += i.S.Value;
                    n++;
                }
                dgSpares.DataContext = items;
                edtSum.Content = "Сумма: " + sum.ToString();
                edtCount.Content = "Позиций в накладной: " + items.Count.ToString();
                if (items.Count > 0)
                    edtCurrency.IsEnabled = false;

                //OnAnyChangeCheck();
            }
            catch (Exception ex1)
            {
                MessageBox.Show(ex1.Message);
            }
            return sum;
        }

        private void AddRates()
        {
            DataAccess da = new DataAccess();
            List<currency_rate> rates = new List<currency_rate>();

            // USD
            currency c1 = da.GetCurrency("USD");
            currency_rate r1 = new currency_rate();
            r1.currency = c1;
            r1.rate = decimal.Parse(edtUSD.Text);
            r1.rate_date = DateTime.Now;

            // EURO
            currency c2 = da.GetCurrency("EUR");
            currency_rate r2 = new currency_rate();
            r2.currency = c2;
            r2.rate = decimal.Parse(edtEURO.Text);
            r2.rate_date = DateTime.Now;

            // RUR
            currency c3 = da.GetCurrency("RUR");
            currency_rate r3 = new currency_rate();
            r3.currency = c3;
            r3.rate = decimal.Parse(edtRUR.Text)/100;
            r3.rate_date = DateTime.Now;

            rates.Add(r1);
            rates.Add(r2);
            rates.Add(r3);
            da.CurrencyRatesCreate(rates);
        }

        public static int getAnalogues(string FilePath)
        {
            List<spare_analogue> items = new List<spare_analogue>();

            // Объявляем и забиваем файл в документ
            XmlDocument xd = new XmlDocument();
            FileStream fs = new FileStream(FilePath, FileMode.Open);
            xd.Load(fs);
            DataAccess da = new DataAccess();

            XmlNodeList list = xd.GetElementsByTagName("Row"); // Создаем и заполняем лист по тегу "user"
            for (int i = 0; i < list.Count; i++)
            {
                if (list[i].HasChildNodes)
                {
                    string Spare1Code1C = list[i].ChildNodes[0].InnerText;
                    string Spare2Code1C = list[i].ChildNodes[1].InnerText;
                    int is_equal = list[i].ChildNodes[2].InnerText.Contains("стина") ? 1 : 0;
                    da.SpareAnalogueCreate(is_equal, Spare1Code1C, Spare2Code1C);
                }
            }

            // Закрываем поток
            fs.Close();

            return items.Count;
        }

 public ReportViewRevision(List<SpareView> itms, DateTime dt)
 {
     InitializeComponent();
     DataAccess da = new DataAccess();
     items = itms;
     d = dt;
 }

 private void btnOK_Click(object sender, RoutedEventArgs e)
 {
     // check pass confirm
     if (string.IsNullOrWhiteSpace(edtPassword.Password))
     {
         MessageBox.Show("Пароль не может быть пустым!");
         return;
     }
     if (edtPassword.Password != edtPasswordConfirm.Password)
     {
         MessageBox.Show("Пароли не совпадают!");
         return;
     }
     DataAccess db = new DataAccess();
     if (user == null)
     {
         // create
         // check username
         if (db.UserNameExist(edtName.Text))
         {
             MessageBox.Show("Пользователь с таким именем уже существует!");
             return;
         }
         db.AdminUnitCreate(SaveItem());
     }
     else
     {
         // edit
         db.AdminUnitEdit(SaveItem());
     }
     Close();
 }

 public ReportViewInvoice(int id)
 {
     InitializeComponent();
     DataAccess da = new DataAccess();
     InvoiceId = id;
     Outgo = da.InvoiceGet(id);
 }

 private void LoadUsers()
 {
     DataAccess db = new DataAccess();
     items = db.GetAdminUnits();
     edtUser.DataContext = items;
     edtUser.SelectedIndex = 0;
 }

 public SpareOutgoEditView(invoice _inv)
 {
     da = new DataAccess();
     InitializeComponent();
     edtNumber.Text = da.SpareOutgoGetMaxId().ToString();
     Invoice = da.InvoiceGet(_inv.id);
 }

        private void EditRates()
        {
            DataAccess da = new DataAccess();
            List<currency_rate> rates = new List<currency_rate>();

            // USD
            currency c1 = da.GetCurrency("USD");
            currency_rate r1 = new currency_rate();
            r1.currency = c1;
            r1.rate = decimal.Parse(edtUSD.Text);
            r1.rate_date = edtDate.SelectedDate.Value;

            // EURO
            currency c2 = da.GetCurrency("EUR");
            currency_rate r2 = new currency_rate();
            r2.currency = c2;
            r2.rate = decimal.Parse(edtEURO.Text);
            r2.rate_date = edtDate.SelectedDate.Value;

            // RUR
            currency c3 = da.GetCurrency("RUR");
            currency_rate r3 = new currency_rate();
            r3.currency = c3;
            r3.rate = decimal.Parse(edtRUR.Text)/100;
            r3.rate_date = edtDate.SelectedDate.Value;

            rates.Add(r1);
            rates.Add(r2);
            rates.Add(r3);
            da.CurrencyRatesEdit(rates);
        }

 private void Button_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         if (Item == null)
         {
             DataAccess da = new DataAccess();
             bank_account ba = new bank_account();
             ba.account = da.GetAccount(AccountID);
             int BankID = (edtBank.SelectedItem as bank).id;
             ba.bank = da.BankGet(BankID);
             ba.BankAccount = edtAccountNumber.Text;
             ba.Description = edtDescription.Text;
             AccountID = da.BankAccountCreate(ba).id;
         }
         else
         {
             DataAccess da = new DataAccess();
             bank_account ba = da.bank_account_get(Item.id);
             int BankID = (edtBank.SelectedItem as bank).id;
             ba.bank = da.BankGet(BankID);
             ba.BankAccount = edtAccountNumber.Text;
             ba.Description = edtDescription.Text;
             da.BankAccountEdit(ba);
         }
     }
     catch (Exception)
     {
     }
     Close();
 }

 public ReportViewSalesCheck(int outgoId)
 {
     InitializeComponent();
     DataAccess da = new DataAccess();
     SpareOutgoId = outgoId;
     Outgo = da.SpareOutgoGet(outgoId);
 }

 public ReportViewOverpricing(int id)
 {
     InitializeComponent();
     DataAccess da = new DataAccess();
     ItemID = id;
     Outgo = da.OverpricingGet(id);
 }

 public ReportViewSpareOutgoTTNAppendix(int outgoId)
 {
     InitializeComponent();
     DataAccess da = new DataAccess();
     SpareOutgoId = outgoId;
     Outgo = da.SpareOutgoGet(outgoId);
 }

 private void CreateItem()
 {
     DataAccess da = new DataAccess();
     client item = new client();
     item.name = edtName.Text;
     item.description = edtDescr.Text;
     da.ClientCreate(item, cbCar.SelectedItem.ToString());
 }

 private void CreateItem()
 {
     DataAccess da = new DataAccess();
     account_type item = new account_type();
     item.name = edtName.Text;
     item.description = edtDescr.Text;
     da.AccountTypeCreate(item);
 }

 public void LoadItem(int id)
 {
     _id = id;
     DataAccess da = new DataAccess();
     unit b = da.GetUnit(id);
     edtName.Text = b.name;
     edtDescr.Text = b.description;
 }

 public void LoadItem(int id)
 {
     DataAccess da = new DataAccess();
     Item = da.BankAccountView(id);
     edtAccountNumber.Text = Item.BankAccount;
     edtBank.SelectedValue = Item.BankID;
     edtDescription.Text = Item.Description;
 }

 private void CreateItem()
 {
     DataAccess da = new DataAccess();
     brand item = new brand();
     item.name = edtName.Text;
     item.description = edtDescr.Text;
     da.BrandCreate(item);
 }

 public void LoadItem(int id)
 {
     _id = id;
     DataAccess da = new DataAccess();
     car_producer b = da.GetCarProducer(id);
     edtName.Text = b.name;
     edtDescr.Text = b.descripton;
 }

 public void LoadItem(int id)
 {
     _id = id;
     DataAccess da = new DataAccess();
     warehouse b = da.GetWarehouse(id);
     edtName.Text = b.name;
     edtDescr.Text = b.description;
 }