public ActionResult InsertDetalleProd(Factura_ProductoBO dto) { NegFactura obj = new NegFactura(); obj.InsertDetalleProd(dto); return(RedirectToAction("InsertDetalleServ")); }
public string InsertarDetalleProducto(Factura_ProductoBO dto) { string result = string.Empty; try { using (OracleConnection cn = new OracleConnection(strOracle)) { cn.Open(); using (OracleCommand command = new OracleCommand(providerStoreProcedure.spNameDetalleProd, cn)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add(new OracleParameter("E_COD_PRODUCTO", OracleDbType.Decimal)).Value = dto.COD_PRODUCTO; command.Parameters.Add(new OracleParameter("E_CAN_PRODUCTO_VENDIDO", OracleDbType.Decimal)).Value = dto.CAN_PRODUCTO_VENDIDO; command.Parameters.Add(new OracleParameter("S_N_COD_SAL", OracleDbType.Decimal)).Direction = System.Data.ParameterDirection.Output; command.Parameters.Add(new OracleParameter("S_V_MSJ_SAL", OracleDbType.Varchar2, 4000)).Direction = System.Data.ParameterDirection.Output; command.ExecuteNonQuery(); result = Convert.ToString(command.Parameters["S_V_MSJ_SAL"].Value); } cn.Close(); } } catch (Exception e) { throw e; } return(result); }
public string InsertDetalleProd(Factura_ProductoBO dto) { daoFactura dao = new daoFactura(); return(dao.InsertarDetalleProducto(dto)); }