public static void deleteAllMessages()
{
using (HikeChatsDb context = new HikeChatsDb(App.MsgsDBConnectionstring))
{
context.messages.DeleteAllOnSubmit <ConvMessage>(context.GetTable <ConvMessage>());
SubmitWithConflictResolve(context);
}
}
public static void deleteAllGroups()
{
using (HikeChatsDb context = new HikeChatsDb(App.MsgsDBConnectionstring))
{
context.groupInfo.DeleteAllOnSubmit <GroupInfo>(context.GetTable <GroupInfo>());
MessagesTableUtils.SubmitWithConflictResolve(context);
}
}
public static void clearDatabase()
{
#region DELETE CONVS,CHAT MSGS, GROUPS, GROUP MEMBERS,THUMBNAILS
ConversationTableUtils.deleteAllConversations();
DeleteAllThumbnails();
DeleteAllAttachmentData();
GroupManager.Instance.DeleteAllGroups();
using (HikeChatsDb context = new HikeChatsDb(App.MsgsDBConnectionstring))
{
context.messages.DeleteAllOnSubmit <ConvMessage>(context.GetTable <ConvMessage>());
context.groupInfo.DeleteAllOnSubmit <GroupInfo>(context.GetTable <GroupInfo>());
try
{
context.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException e)
{
Debug.WriteLine(e.Message);
// Automerge database values for members that client
// has not modified.
foreach (ObjectChangeConflict occ in context.ChangeConflicts)
{
occ.Resolve(RefreshMode.KeepChanges);
}
}
// Submit succeeds on second try.
context.SubmitChanges(ConflictMode.FailOnFirstConflict);
}
#endregion
#region DELETE USERS, BLOCKLIST
using (HikeUsersDb context = new HikeUsersDb(App.UsersDBConnectionstring))
{
context.blockedUsersTable.DeleteAllOnSubmit <Blocked>(context.GetTable <Blocked>());
context.users.DeleteAllOnSubmit <ContactInfo>(context.GetTable <ContactInfo>());
try
{
context.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException e)
{
Debug.WriteLine(e.Message);
// Automerge database values for members that client
// has not modified.
foreach (ObjectChangeConflict occ in context.ChangeConflicts)
{
occ.Resolve(RefreshMode.KeepChanges);
}
}
// Submit succeeds on second try.
context.SubmitChanges(ConflictMode.FailOnFirstConflict);
}
#endregion
#region DELETE MQTTPERSISTED MESSAGES
using (HikeMqttPersistenceDb context = new HikeMqttPersistenceDb(App.MqttDBConnectionstring))
{
context.mqttMessages.DeleteAllOnSubmit <HikePacket>(context.GetTable <HikePacket>());
try
{
context.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException e)
{
Debug.WriteLine(e.Message);
// Automerge database values for members that client
// has not modified.
foreach (ObjectChangeConflict occ in context.ChangeConflicts)
{
occ.Resolve(RefreshMode.KeepChanges);
}
}
// Submit succeeds on second try.
context.SubmitChanges(ConflictMode.FailOnFirstConflict);
}
#endregion
#region DELETE FAVOURITES AND PENDING REQUESTS
DeleteFavourites();
DeletePendingRequests();
#endregion
}
