public async Task<IActionResult> Edit(int id, [Bind("InvoiceId,DateOfCorrection,CorrectionCause,Id,Number,DateOfIssue,DateOfDelivery,ContractorId,PaymentMethodId,InvoiceStatusId")] InvoiceCorrection invoiceCorrection) { if (id != invoiceCorrection.Id) { return NotFound(); } if (ModelState.IsValid) { try { _context.Update(invoiceCorrection); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!InvoiceCorrectionExists(invoiceCorrection.Id)) { return NotFound(); } else { throw; } } return RedirectToAction(nameof(Index)); } ViewData["ContractorId"] = new SelectList(_context.Contractor, "Id", "Discriminator", invoiceCorrection.ContractorId); ViewData["InvoiceStatusId"] = new SelectList(_context.InvoiceStatus, "Id", "Id", invoiceCorrection.InvoiceStatusId); ViewData["PaymentMethodId"] = new SelectList(_context.PaymentMethod, "Id", "Id", invoiceCorrection.PaymentMethodId); return View(invoiceCorrection); }
private void DoubleClick_Open(object sender, MouseButtonEventArgs e) { if (CompanyDataGrid.SelectedItem != null && invoiceOpen) { if (InvoiceCorrections.IsChecked != true) { Invoice inv = CompanyDataGrid.SelectedItem as Invoice; InvoiceDetails invoiceDetails = new InvoiceDetails(inv, inv.Id, inv.IdCompany); invoiceDetails.Show(); } else { InvoiceCorrection invoiceCorrection = CompanyDataGrid.SelectedItem as InvoiceCorrection; EditedInvoiceDetails edited = new EditedInvoiceDetails(invoiceCorrection); edited.Show(); } } else if (CompanyDataGrid.SelectedItem != null && StorageOpen) { Product prd = CompanyDataGrid.SelectedItem as Product; StorageAdditionalOperations storageAdditionalOperations = new StorageAdditionalOperations(prd); storageAdditionalOperations.Show(); storageAdditionalOperations.Closed += (s, eventarg) => { LoadProductsList(); }; } else { MessageBox.Show("Wybierz pozycję z listy!"); } }
public static void SaveCorrectedInvoice(InvoiceCorrection invoiceCorrection) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { string s1 = "CorrectionID, CorrectionNumber, CorrectionDate, CorrectionReason, InvoiceConnection, CorrectionConnection"; cnn.Execute("insert into CorrectedPdf(" + s1 + ")values(@correctionID,@correctionNumber,@correctionDate,@correctionReason,@invoiceConnection,@correctionConnection)", invoiceCorrection); } }
public async Task<IActionResult> Create([Bind("InvoiceId,DateOfCorrection,CorrectionCause,Id,Number,DateOfIssue,DateOfDelivery,ContractorId,PaymentMethodId,InvoiceStatusId")] InvoiceCorrection invoiceCorrection) { if (ModelState.IsValid) { _context.Add(invoiceCorrection); await _context.SaveChangesAsync(); return RedirectToAction(nameof(Index)); } ViewData["ContractorId"] = new SelectList(_context.Contractor, "Id", "Discriminator", invoiceCorrection.ContractorId); ViewData["InvoiceStatusId"] = new SelectList(_context.InvoiceStatus, "Id", "Id", invoiceCorrection.InvoiceStatusId); ViewData["PaymentMethodId"] = new SelectList(_context.PaymentMethod, "Id", "Id", invoiceCorrection.PaymentMethodId); return View(invoiceCorrection); }
public EditedInvoiceDetails(InvoiceCorrection invoiceCorrection) { InitializeComponent(); showInvoice = SQLiteDataAccess.LoadInvoice(invoiceCorrection.InvoiceConnection)[0]; this.companyID = 1; invoiceID = invoiceCorrection.CorrectionID; LoadInvoiceList(); ID.Text = invoiceCorrection.CorrectionID.ToString(); LoadCompanyList(); IdCompany.Text = showCompanyName.CompanyName; LoadSellerList(); IdSeller.Text = showCompanySeller.Name + " " + showCompanySeller.Surname; Number.Text = invoiceCorrection.CorrectionNumber.ToString(); CreationDate.Text = invoiceCorrection.CorrectionDate; SaleDate.Text = invoiceCorrection.CorrectionDate; PaymentType.Text = showInvoice.PaymentType; PaymentDeadline.Text = showInvoice.PaymentDeadline; ToPay.Text = showInvoice.ToPay; ToPayInWords.Text = showInvoice.ToPayInWords; Paid.Text = showInvoice.Paid; DateOfIssue.Text = showInvoice.DateOfIssue; NameOfService.Text = showInvoice.NameOfService; if (String.IsNullOrEmpty(showInvoice.AccountNumber)) { AccountNumber.Visibility = Visibility.Hidden; AccountNumberLabel.Visibility = Visibility.Hidden; } else { AccountNumber.Text = showInvoice.AccountNumber; } EditPdfCB.IsChecked = false; Corection.Text = invoiceCorrection.CorrectionReason; DateOfCoretion.Text = invoiceCorrection.CorrectionDate; }