public List <SavedDevices> GetSavedDevices(int userId, int subUserId)
{
var localValue = new List <SavedDevices>();
var cmd = new OracleCommand("rstask.PKG_USERS.get_saved_devices");
cmd.Parameters.Add("p_user_id", OracleDbType.Int32).Value = userId;
cmd.Parameters.Add("p_subuser_id", OracleDbType.Int32).Value = subUserId;
cmd.Parameters.Add("p_curs", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
string error;
new OracleDb <PKG_USERS>().ProcessEachRow(cmd, out error, delegate(OracleDataReader reader)
{
var saved = new SavedDevices();
saved.UserId = reader["USER_ID"].ToString().ToNumber <decimal>();
saved.SubUserId = reader["SUB_USER_ID"].ToString().ToNumber <decimal>();
saved.InsertDate = Convert.ToDateTime(reader["INSERT_DATE"].ToString());
saved.Vcode = reader["VCODE"].ToString();
saved.Address = reader["ADDRESS"].ToString();
saved.Browser = reader["BROWSER"].ToString();
saved.OperSystem = reader["OPERATING_SYSTEM"].ToString();
localValue.Add(saved);
});
if (!string.IsNullOrEmpty(error))
{
throw new Exception(error);
}
return(localValue);
}
public async Task <IList <BleDeviceInfo> > GetSavedDevicesAsync() => await SavedDevices.CastTask <JavaList <BleDeviceInfo> >();
