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;
}
