private string LoadMoreMessagesDatabase()
{
try
{
SqLiteDatabase dbDatabase = new SqLiteDatabase();
var localList = dbDatabase.GetMessageList(Convert.ToInt32(UserDetails.UserId), Userid, FirstMessageId);
if (localList?.Count > 0) //Database.. Get Messages Local
{
localList = new List <DataTables.MessageTb>(localList.OrderByDescending(a => a.Id));
foreach (var m in localList.Select(messages => new GetUserMessagesObject.Message
{
Id = messages.Id,
FromId = messages.FromId,
ToId = messages.ToId,
Text = messages.Text,
MediaFile = messages.MediaFile,
MediaType = messages.MediaType,
DeletedFs1 = messages.DeletedFs1,
DeletedFs2 = messages.DeletedFs2,
Seen = messages.Seen,
Time = messages.Time,
Extra = messages.Extra,
TimeText = messages.TimeText,
Position = messages.Position,
}))
{
MAdapter.Insert(m, FirstMessageId);
}
dbDatabase.Dispose();
return("1");
}
else
{
dbDatabase.Dispose();
return("0");
}
}
catch (Exception e)
{
Console.WriteLine(e);
return("0");
}
}
private string LoadMoreMessagesDatabase()
{
try
{
SqLiteDatabase dbDatabase = new SqLiteDatabase();
var localList = dbDatabase.GetMessageList(UserDetails.UserId, Userid, FirstMessageId);
if (localList?.Count > 0) //Database.. Get Messages Local
{
localList = new List <DataTables.MessageTb>(localList.OrderByDescending(a => a.Id));
foreach (var messages in localList)
{
GetUserMessagesObject.Message m = new GetUserMessagesObject.Message
{
Id = messages.Id,
FromId = messages.FromId,
ToId = messages.ToId,
Text = messages.Text,
Seen = messages.Seen,
Time = messages.Time,
FromDeleted = messages.FromDeleted,
ToDeleted = messages.ToDeleted,
TextTime = messages.TextTime,
Position = messages.Position,
};
MAdapter.Insert(m, FirstMessageId);
}
dbDatabase.Dispose();
return("1");
}
else
{
dbDatabase.Dispose();
return("0");
}
}
catch (Exception e)
{
Console.WriteLine(e);
return("0");
}
}
