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