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