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; }
public void LoadItem(string name) { _groupName = name; DataAccess da = new DataAccess(); spare_group b = da.GetSpareGroup(name); edtName.Text = b.name; edtDescr.Text = b.description; }
private void EditItem() { DataAccess da = new DataAccess(); account_type item = new account_type(); item.id = _id; item.name = edtName.Text; item.description = edtDescr.Text; da.AccountTypeEdit(item); }
private int EditItem() { DataAccess da = new DataAccess(); spare_group item = new spare_group(); item.id = da.GetSpareGroups().FirstOrDefault(g => g.name == _groupName).id; item.name = edtName.Text; item.description = edtDescr.Text; return da.SpareGroupEdit(item); }
private spare_group CreateItem() { DataAccess da = new DataAccess(); spare_group i = new spare_group(); i.name = edtName.Text; i.description = edtDescr.Text; i.ParentGroup = da.GetSpareGroups().FirstOrDefault(g => g.name == _parentName); return da.SpareGroupCreate(i); }
private void EditItem() { DataAccess da = new DataAccess(); brand item = new brand(); item.id = _id; item.name = edtName.Text; item.description = edtDescr.Text; da.BrandEdit(item); }
private void BankAccountDelete() { DataAccess da = new DataAccess(); if ((dgSpares.SelectedItem as BankAccountView) != null) { da.BankAccountDelete((dgSpares.SelectedItem as BankAccountView).id); LoadBankAccounts(); } }
private void LoadWarehouses() { DataAccess da = new DataAccess(); List<warehouse> l = da.GetWarehouses(); warehouse w = new warehouse(); w.name = "Все склады"; l.Add(w); edtWarehouse.DataContext = l; edtWarehouse.SelectedItem = w; }
public decimal LoadOfferings() { if (Item != null) { da = new DataAccess(); List<SpareInOverpricingView> items = da.OverpricingOfferingGet(Item.id); dgSpares.DataContext = items; } return 0; }
private void LoadComboBox_CarMarks() { DataAccess da = new DataAccess(); List<car_mark> marks = da.GetCarMarks(); foreach (car_mark m in marks) { cbCar.Items.Add(m.name); } cbCar.SelectedIndex = 0; }
private void LoadComboBox_CarProducers() { DataAccess da = new DataAccess(); List<car_producer> cars = da.GetCarProducers(); foreach (car_producer m in cars) { cbProds.Items.Add(m.name); } cbProds.SelectedIndex = 0; }