public async Task <IActionResult> Edit(int id, [Bind("VatRatesId,Value")] VatRates vatRates)
{
if (id != vatRates.VatRatesId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vatRates);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VatRatesExists(vatRates.VatRatesId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(vatRates));
}
public async Task <IActionResult> Create([Bind("VatRatesId,Value")] VatRates vatRates)
{
if (ModelState.IsValid)
{
_context.Add(vatRates);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(vatRates));
}
protected override void ProcessCell(String sheet_name, Int32 row, Int32 column, String type, String value)
{
// System.Console.WriteLine("{0}({1},{2}) {3}:'{4}'", sheet, row, column, type, value);
// if (sheet_name != "БСР")
if (sheet_name == "БСР" && row == 2 && column == 12)
{
fmCOrder order = ObjectSpace.FindObject <fmCOrder>(
new BinaryOperator("Code", value));
if (order == null || order.Subject != TargetDoc.Subject)
{
throw new InvalidDataException("Заказ неверный или тема не соответствует заказу");
}
TargetDoc.Order = order;
return;
}
if (sheet_name == "БСР" && row == 2 && column == 16)
{
TargetDoc.Valuta = Valutas.FirstOrDefault(x => x.Code == ValutaCodeConvert(value));
foreach (var line in TargetDoc.SubLines)
{
line.Valuta = TargetDoc.Valuta;
}
}
if (sheet_name == "БСР" && row == 4 && column == 9)
{
BeginYear = (Int16)(Int32.Parse(value) - 1);
}
if (sheet_name == "БСР" && row == 4 && column == 16)
{
TargetDoc.VatRate = VatRates.FirstOrDefault(x => x.Code == VatCodeConvert(value));
foreach (var line in TargetDoc.SubLines)
{
line.VatRate = TargetDoc.VatRate;
}
}
foreach (var line in TargetDoc.SubLines)
{
if (line.LineName == sheet_name)
{
LoadTableCell(line, row, column, type, value);
break;
}
}
}
public void GivenInvoiceItemWithoutVatRegime_WhenDeriving_ThenItemDerivedVatRateIsFromInvoiceVatRegime()
{
this.InstantiateObjects(this.DatabaseSession);
var vatRate0 = new VatRates(this.DatabaseSession).FindBy(VatRates.Meta.Rate, 0);
var salesInvoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBilledFromInternalOrganisation(this.internalOrganisation)
.WithBillToCustomer(this.billToCustomer)
.WithBillToContactMechanism(this.billToContactMechanismMechelen)
.WithVatRegime(new VatRegimes(this.DatabaseSession).Export)
.Build();
var invoiceItem = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).WithQuantity(1).Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
this.DatabaseSession.Derive(true);
Assert.AreEqual(salesInvoice.VatRegime, invoiceItem.VatRegime);
Assert.AreEqual(vatRate0, invoiceItem.DerivedVatRate);
}
protected override void AppsSetup(Setup setup)
{
base.AppsSetup(setup);
var vatRate0 = new VatRates(this.Session).FindBy(VatRates.Meta.Rate, 0);
var englishLocale = new Locales(this.Session).EnglishGreatBritain;
var dutchLocale = new Locales(this.Session).DutchNetherlands;
new VatRegimeBuilder(this.Session)
.WithName("Co-Contractor")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Co-Contractor").WithLocale(englishLocale).Build())
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Medecontractant").WithLocale(dutchLocale).Build())
.WithUniqueId(CoContractorId)
.Build();
new VatRegimeBuilder(this.Session)
.WithName("Private Person")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Private Person").WithLocale(englishLocale).Build())
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("particulier").WithLocale(dutchLocale).Build())
.WithUniqueId(PrivatePersonId)
.Build();
new VatRegimeBuilder(this.Session)
.WithName("VAT Assessable")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("VAT Assessable").WithLocale(englishLocale).Build())
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("BTW-plichtig").WithLocale(dutchLocale).Build())
.WithUniqueId(AssessableId)
.Build();
new VatRegimeBuilder(this.Session)
.WithName("Export")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Export").WithLocale(englishLocale).Build())
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Export").WithLocale(dutchLocale).Build())
.WithVatRate(vatRate0)
.WithUniqueId(ExportId)
.Build();
new VatRegimeBuilder(this.Session)
.WithName("Intracommunautair")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Intracommunautair").WithLocale(englishLocale).Build())
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Intracommunautair").WithLocale(dutchLocale).Build())
.WithVatRate(vatRate0)
.WithUniqueId(IntraCommunautairId)
.Build();
new VatRegimeBuilder(this.Session)
.WithName("Not VAT assessable")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Not VAT assessable").WithLocale(englishLocale).Build())
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Niet BTW-plichtig").WithLocale(dutchLocale).Build())
.WithVatRate(vatRate0)
.WithUniqueId(NotAssessableId)
.Build();
new VatRegimeBuilder(this.Session)
.WithName("Exempt")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Exempt").WithLocale(englishLocale).Build())
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Vrijgesteld").WithLocale(dutchLocale).Build())
.WithUniqueId(ExemptId)
.WithVatRate(vatRate0)
.Build();
}
