public ReportViewInvoice(int id)
{
InitializeComponent();
DataAccess da = new DataAccess();
InvoiceId = id;
Outgo = da.InvoiceGet(id);
}
public SpareOutgoEditView(invoice _inv)
{
da = new DataAccess();
InitializeComponent();
edtNumber.Text = da.SpareOutgoGetMaxId().ToString();
Invoice = da.InvoiceGet(_inv.id);
}
// загрузка Item из БД, заполнение полей =====================
private void ItemToForm(int ItemID)
{
//.1
Item = da.InvoiceGet(ItemID);
if (Item.account == null)
Item.accountReference.Load();
if (Item.account != null)
edtAccount.SelectedValue = Item.account.id;
edtAccountAddress.Text = Item.AccountAddress;
edtAccountBankMFO.Text = Item.AccountBankMFO;
edtAccountBankName.Text = Item.AccountBankName;
edtBankAccount.SelectedValue = Item.BankAccountID;
edtAccountUNN.Text = Item.AccountUNN;
if (Item.InvoiceDate.HasValue)
edtDate.SelectedDate = Item.InvoiceDate.Value;
edtNumber.Text = Item.InvoiceNumber.ToString();
edtSum.Content = Item.InvoiceSum.ToString();
}
// заполнение Item из полей, сохранение в БД =================
private invoice FormToItem()
{
da = new DataAccess();
if (Item == null)
Item = new invoice();
Item.InvoiceDate = edtDate.SelectedDate.HasValue ? edtDate.SelectedDate.Value : DateTime.Now;
int AccountID = 0;
if (edtAccount.SelectedValue != null)
{
AccountID = (int)edtAccount.SelectedValue;
}
Item.AccountUNN = edtAccountUNN.Text;
Item.AccountBankName = edtAccountBankName.Text;
BankAccountView bav = edtBankAccount.SelectedItem as BankAccountView;
if (bav != null)
{
Item.BankAccountID = bav.id;
}
Item.AccountAddress = edtAccountAddress.Text;
Item.AccountBankMFO = edtAccountBankMFO.Text;
Item.InvoiceSum = (double)InvoiceSum;
int INum = 0;
//if(Item.InvoiceNumber.HasValue)
//INum = Item.InvoiceNumber.Value;
if (Int32.TryParse(edtNumber.Text, out INum))
Item.InvoiceNumber = INum;
da.InvoiceEdit(Item, AccountID);
return Item;
}
private void CreateOutgoByInvoice()
{
da = new DataAccess();
this.Item = FormToItem();
bool WarningFlag = false;
List<SpareInInvoiceView> items = da.GetSparesByInvoiceID(Item.id);
foreach (SpareInInvoiceView siiv in items)
{
if (!siiv.IncomeID.HasValue)
{
WarningFlag = true;
}
}
if (WarningFlag)
{
MessageBox.Show("Вероятно, данный счет-фактура создан в предыдущей версии программы, поэтому не все товары могут быть перенесены в новую накладную.");
}
SpareOutgoEditView v = new SpareOutgoEditView(this.Item);
v.ShowDialog();
//Close();
}
// Создать инвойс
private void CreateInvoice()
{
DeleteNew = true;
Item = new invoice();
Item = da.InvoiceCreate(Item);
edtNumber.Text = Item.InvoiceNumber.ToString();
}
/// <summary>
/// Deprecated Method for adding a new object to the invoices EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToinvoices(invoice invoice)
{
base.AddObject("invoices", invoice);
}
/// <summary>
/// Create a new invoice object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
public static invoice Createinvoice(global::System.Int32 id)
{
invoice invoice = new invoice();
invoice.id = id;
return invoice;
}
public void InvoiceEdit(invoice item, int AccountID)
{
objDataContext = new DriveEntities();
invoice original = objDataContext.invoices.FirstOrDefault(b => b.id == item.id);
if (original != null)
{
original.InvoiceDate = item.InvoiceDate;
original.InvoiceSum = item.InvoiceSum;
original.AccountBankName = item.AccountBankName;
original.BankAccountID = item.BankAccountID;
//original.AccountName = item.AccountName;
original.AccountUNN = item.AccountUNN;
original.AccountAddress = item.AccountAddress;
original.AccountBankMFO = item.AccountBankMFO;
original.InvoiceNumber = item.InvoiceNumber;
//original.account = item.account;
if (AccountID > 0)
{
original.account = objDataContext.accounts.FirstOrDefault(i => i.id == AccountID);
original.AccountName = original.account.name;
}
//original.base_doc = item.base_doc;
//original.base_doc_date = item.base_doc_date;
//original.currency = objDataContext.currencies.FirstOrDefault(i => i.code == CurrencyCode);
//original.si_date = item.si_date;
//original.warehouse = objDataContext.warehouses.FirstOrDefault(i => i.name == WarehouseName);
//original.cashless = item.cashless;
objDataContext.SaveChanges();
}
}
public invoice InvoiceCreate(invoice _obj)
{
objDataContext = new DriveEntities();
if (objDataContext.invoices.Count() > 0)
_obj.InvoiceNumber = objDataContext.invoices.Max(x => x.InvoiceNumber) + 1;
else
_obj.InvoiceNumber = 1;
objDataContext.AddToinvoices(_obj);
objDataContext.SaveChanges();
//_obj.InvoiceNumber = _obj.id;
return _obj;
}