public Tuple <OmemoDeviceListSubscriptionState, DateTime> getOmemoDeviceListSubscription(string name, string accountId)
{
List <OmemoDeviceListSubscriptionTable> subscriptions = dB.Query <OmemoDeviceListSubscriptionTable>(true, "SELECT * FROM " + DBTableConsts.OMEMO_DEVICE_LIST_SUBSCRIPTION_TABLE + " WHERE id = ?;", OmemoDeviceListSubscriptionTable.generateId(accountId, name));
if (subscriptions is null || subscriptions.Count <= 0)
{
return(new Tuple <OmemoDeviceListSubscriptionState, DateTime>(OmemoDeviceListSubscriptionState.NONE, DateTime.MinValue));
}
return(new Tuple <OmemoDeviceListSubscriptionState, DateTime>(subscriptions[0].state, subscriptions[0].lastUpdateReceived));
}
public OmemoDeviceListSubscriptionTable getDeviceListSubscription(string chatJid, string accountId)
{
List <OmemoDeviceListSubscriptionTable> subscriptions = dB.Query <OmemoDeviceListSubscriptionTable>(true, "SELECT * FROM " + DBTableConsts.OMEMO_DEVICE_LIST_SUBSCRIPTION_TABLE + " WHERE id = ?;", OmemoDeviceListSubscriptionTable.generateId(chatJid, accountId));
if (subscriptions == null || subscriptions.Count <= 0)
{
return(new OmemoDeviceListSubscriptionTable(chatJid, accountId, OmemoDeviceListSubscriptionState.NONE, DateTime.MinValue));
}
return(subscriptions[0]);
}
