public async Task <TM_SUCURSAL_ES> Insert(TM_SUCURSAL_ES input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idestservicio_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDESTSERVICIO);
dyParam.Add("num_idtpvia_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDTPVIA);
dyParam.Add("str_nomvia_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NOMVIA);
dyParam.Add("num_idccpp_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDCCPP);
dyParam.Add("str_nomccpp_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NOMCCPP);
dyParam.Add("num_idnumakm_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDNUMAKM);
dyParam.Add("str_nummzkil_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NUMMZKIL);
dyParam.Add("num_idloindp_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDLOINDP);
dyParam.Add("str_intlote_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_INTLOTE);
dyParam.Add("str_referencia_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_REFERENCIA);
dyParam.Add("str_cdpto_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_CDPTO);
dyParam.Add("str_cdprov_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_CDPROV);
dyParam.Add("str_cddist_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_CDDIST);
dyParam.Add("str_latitud_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_LATITUD);
dyParam.Add("str_longitud_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_LONGITUD);
dyParam.Add("str_usucreacion_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_USUCREACION);
dyParam.Add("num_idsesion_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDSESION);
dyParam.Add("num_identidadusuario_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDENTIDADUSUARIO);
dyParam.Add("num_identidadsso_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDENTIDADSSO);
dyParam.Add("num_idlocalsso_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDLOCALSSO);
dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output);
var query = _connectionFactory.GetQueryForSIROS("PKG_SUCURSAL.SP_RegistrarSucursal");
var result = await connection.QueryFirstOrDefaultAsync <TM_SUCURSAL_ES>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
public async Task <TM_SUCURSAL_ES> Update(TM_SUCURSAL_ES input)
{
try
{
return(await this._sucursalESRepository.Update(input));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <TM_SUCURSAL_ES> > GetCombo(TM_SUCURSAL_ES input)
{
try
{
return(await this._sucursalESRepository.GetCombo(input));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <TM_SUCURSAL_ES> > GetCombo(TM_SUCURSAL_ES input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idestservicio_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDESTSERVICIO);
dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output);
var query = _connectionFactory.GetQueryForSIROS("PKG_SUCURSAL.SP_GetListaComboSucursalxEst");
var result = await connection.QueryAsync <TM_SUCURSAL_ES>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result.AsList());
}
}
public async Task <TM_SUCURSAL_ES> Get(TM_SUCURSAL_ES input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idsucursalxes_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDSUCURSALXES);
dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output);
var query = _connectionFactory.GetQueryForSIROS("PKG_SUCURSAL.SP_GetListaSucursalxId");
var result = await connection.QueryFirstOrDefaultAsync <TM_SUCURSAL_ES>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
