public void InsertManualMovement(ManualMovement manualMovement) { int count = _manualMovementsRepository.GetAllManualMovementsCount(); manualMovement.Num_Lancamento = count + 1; _manualMovementsRepository.InsertManualMovement(manualMovement); }
public IActionResult Edit(int id, [Bind()] ManualMovement entity) { if (id != entity.ManualMovementId) { return(NotFound()); } if (ModelState.IsValid) { try { _bManualMovements.Update(entity); } catch (Exception ex) { throw ex; } return(RedirectToAction(nameof(Index))); } var products = _bProduct.GetListAll(x => true); var productCosifs = _bProductCosif.GetListAll(x => true); ViewBag.ProductId = new SelectList(products, "ProductId", "Description", entity.ProductId); ViewBag.ProductCosifId = new SelectList(productCosifs, "ProductCosifId", "CodProductCosif", entity.ProductCosifId); return(View(entity)); }
public IActionResult Create([Bind()] ManualMovement entity) { if (ModelState.IsValid) { _bManualMovements.Add(entity); return(RedirectToAction(nameof(Index))); } var products = _bProduct.GetListAll(x => true); var productCosifs = _bProductCosif.GetListAll(x => true); ViewBag.ProductId = new SelectList(products, "ProductId", "Description", entity.ProductId); ViewBag.ProductCosifId = new SelectList(productCosifs, "ProductCosifId", "CodProductCosif", entity.ProductCosifId); return(View(entity)); }
public void InsertManualMovement(ManualMovement manualMovement) { using (var cnn = new SqlConnection(GetConnectionString())) { cnn.Open(); cnn.Execute( @" INSERT INTO [MOVIMENTO_MANUAL] ([DAT_MES] ,[DAT_ANO] ,[NUM_LANCAMENTO] ,[COD_PRODUTO] ,[COD_COSIF] ,[VAL_VALOR] ,[DES_DESCRICAO] ,[COD_USUARIO]) VALUES (@Dat_Mes ,@Dat_Ano ,@Num_Lancamento ,@Cod_Produto ,@Cod_Cosif ,@Val_Valor ,@Des_Descricao ,@Cod_Usuario ); ", new { manualMovement.Dat_Mes, manualMovement.Dat_Ano, manualMovement.Num_Lancamento, manualMovement.Cod_Produto, manualMovement.Cod_Cosif, manualMovement.Val_Valor, manualMovement.Des_Descricao, manualMovement.Cod_Usuario }); } }