public async Task <IActionResult> Edit(int id, [Bind("CommissionsPaidProductId,CommissionsPaidId,ProductId,Commission,CreatedDate,CreatedBy,LastUpdateDate,LastUpdatedBy")] CommissionsPaidProduct commissionsPaidProduct) { if (id != commissionsPaidProduct.CommissionsPaidProductId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(commissionsPaidProduct); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CommissionsPaidProductExists(commissionsPaidProduct.CommissionsPaidProductId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CommissionsPaidId"] = new SelectList(_context.CommissionsPaids, "CommissionsPaidId", "CommissionsPaidId", commissionsPaidProduct.CommissionsPaidId); ViewData["ProductId"] = new SelectList(_context.Products, "ProductId", "ProductId", commissionsPaidProduct.ProductId); return(View(commissionsPaidProduct)); }
public async Task <IActionResult> Create([Bind("CommissionsPaidProductId,CommissionsPaidId,ProductId,Commission,CreatedDate,CreatedBy,LastUpdateDate,LastUpdatedBy,AssociateId, AssociateFirstName, AssociateLastName, Company, DateOfPayment, SplitId")] CommissionsPaidProduct commissionsPaidProduct) { if (ModelState.IsValid) { _context.CommissionsPaidProducts.FromSqlRaw("SET IDENTITY_INSERT CommissionsPaidProductID ON"); _context.Add(commissionsPaidProduct); _context.CommissionsPaidProducts.FromSqlRaw("SET IDENTITY_INSERT CommissionsPaidProductID OFF"); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CommissionsPaidId"] = new SelectList(_context.CommissionsPaids, "CommissionsPaidId", "CommissionsPaidId", commissionsPaidProduct.CommissionsPaidId); ViewData["ProductId"] = new SelectList(_context.Products, "ProductId", "ProductId", commissionsPaidProduct.ProductId); ViewData["AssociateId"] = new SelectList(_context.Associates, "AssociateId", "ProductId", commissionsPaidProduct.ProductId); return(View(commissionsPaidProduct)); }