// GET: VATRegisterBuys public async Task <IActionResult> Index(int?year, int?month) { VATRegisterBuy vATRegisterBuy = new VATRegisterBuy(); vATRegisterBuy.DateOfIssue = DateTime.Now.Date; vATRegisterBuy.DeliveryDate = DateTime.Now.Date; ViewData["VATRegisterBuy"] = vATRegisterBuy; //test VATRegisterBuyViewModel vATRegisterBuyViewModel = new VATRegisterBuyViewModel(); vATRegisterBuyViewModel.DateOfIssue = DateTime.Now.Date; vATRegisterBuyViewModel.DeliveryDate = DateTime.Now.Date; ViewData["VATRegisterBuyViewModel"] = vATRegisterBuyViewModel; //test end ViewData["ContractorId"] = new SelectList(_context.Contractor, "Id", "Name"); ViewData["Month"] = new SelectList(Tools.getMonthsDictionary(), "Key", "Value", DateTime.Now.Month); ViewData["Year"] = new SelectList(Tools.getYearsList(), DateTime.Now.Year); if (HttpContext.Session.GetString(SelectedMonth) == "month" && HttpContext.Session.GetString(SelectedYear) == "year") { HttpContext.Session.SetInt32(SelectedMonth, DateTime.Now.Month); HttpContext.Session.SetInt32(SelectedYear, DateTime.Now.Year); // year = HttpContext.Session.GetInt32(SelectedYear); // month = HttpContext.Session.GetInt32(SelectedMonth); } if (year is null && month is null) { year = HttpContext.Session.GetInt32(SelectedYear); month = HttpContext.Session.GetInt32(SelectedMonth); ViewData["Month"] = new SelectList(Tools.getMonthsDictionary(), "Key", "Value", month); ViewData["SelectedMonth"] = month; ViewData["Year"] = new SelectList(Tools.getYearsList(), year); ViewData["SelectedYear"] = year; } var applicationDbContext = _context.VATRegisterBuy.Include(i => i.Contractor); if (month != null && year != null) { HttpContext.Session.SetInt32(SelectedMonth, (int)month); HttpContext.Session.SetInt32(SelectedYear, (int)year); ViewData["Month"] = new SelectList(Tools.getMonthsDictionary(), "Key", "Value", month); ViewData["SelectedMonth"] = month; ViewData["Year"] = new SelectList(Tools.getYearsList(), year); ViewData["SelectedYear"] = year; var filteredResult = applicationDbContext.Where(p => p.DateOfIssue.Month == month && p.DateOfIssue.Year == year); return(View(await filteredResult.OrderBy(p => p.DateOfIssue).ToListAsync())); } else { return(View(await applicationDbContext.Where(p => p.Month == DateTime.Now.Month && p.Year == DateTime.Now.Year).ToListAsync())); } }
public async Task <IActionResult> CreateTest([Bind("Id,DeliveryDate,DateOfIssue,DocumentNumber,ContractorId,ValueBrutto,ValueNetto,TaxDeductibleValue,TaxFreeBuysValue,NoTaxDeductibleBuysValue,CarCost,BuyForTrade,OtherCost,DescriptionForTaxBook")] VATRegisterBuyViewModel vATRegisterBuyViewModel) { ViewData["ContractorId"] = new SelectList(_context.Contractor, "Id", "Name"); if (ModelState.IsValid) { vATRegisterBuyViewModel.Month = vATRegisterBuyViewModel.DateOfIssue.Month; vATRegisterBuyViewModel.Year = vATRegisterBuyViewModel.DateOfIssue.Year; vATRegisterBuyViewModel.Number = vATRegisterBuyViewModel.getOrderNumber(_context); VATRegisterBuy vATRegisterBuy = vATRegisterBuyViewModel.getVATRegisterBuy(); TaxBook taxBook = new TaxBook(); taxBook.Date = vATRegisterBuyViewModel.DateOfIssue; taxBook.InvoiceNumber = vATRegisterBuyViewModel.DocumentNumber; taxBook.ContractorId = vATRegisterBuyViewModel.ContractorId; taxBook.Description = vATRegisterBuyViewModel.DescriptionForTaxBook; if (vATRegisterBuyViewModel.BuyForTrade) { string description = "zakup handlowy"; taxBook.GoodsBuys = vATRegisterBuyViewModel.ValueNetto; taxBook.Description = description; } else if (vATRegisterBuyViewModel.OtherCost) { taxBook.OtherCosts = vATRegisterBuyViewModel.ValueNetto; } else if (vATRegisterBuyViewModel.CarCost) { decimal carCostDeductibleValue = Decimal.Parse(_context.Parameter.Single(p => p.Name == "odl_koszty_pojazd").Value); taxBook.OtherCosts = vATRegisterBuyViewModel.ValueNetto * carCostDeductibleValue; vATRegisterBuy.TaxDeductibleValue = vATRegisterBuy.TaxDeductibleValue / 2; CarCost carCost = new CarCost(); carCost.Date = vATRegisterBuyViewModel.DateOfIssue; carCost.Price = vATRegisterBuyViewModel.ValueBrutto; carCost.Description = vATRegisterBuyViewModel.DescriptionForTaxBook; // if (_context.CarCostType.Single(p=>p.Contains(carCost.Description))=!null) // { // carCost.CarCostTypeId = _context.CarCostType.Single(p=>p.Contains()); // } } _context.Add(taxBook); _context.Add(vATRegisterBuy); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(vATRegisterBuyViewModel)); }
// GET: VATRegisterBuys/CreateTest public IActionResult CreateTest() { ViewData["ContractorId"] = new SelectList(_context.Contractor, "Id", "Name"); VATRegisterBuyViewModel vATRegisterBuy = new VATRegisterBuyViewModel(); DateTime currDate = DateTime.Now; vATRegisterBuy.DateOfIssue = currDate; vATRegisterBuy.DeliveryDate = currDate; vATRegisterBuy.Month = currDate.Month; vATRegisterBuy.Year = currDate.Year; return(View(vATRegisterBuy)); }