-
Notifications
You must be signed in to change notification settings - Fork 0
/
DatabaseUpdate.cs
33 lines (32 loc) · 1.19 KB
/
DatabaseUpdate.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
using IHaveIdeas.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace IHaveIdeas.Data
{
class DatabaseUpdate
{
/// <summary>
/// Reorders saved cards pivot page cards after delete.
/// </summary>
/// <param name="pack">The pack number where a card was removed</param>
/// <param name="cardPosition">Position number of the card where card was removed</param>
public void ReOrderSavedCards(int pack, int cardPosition)
{
int newCardPosition = cardPosition;
using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path))
{
IEnumerable<SavedCards> reOrderQuery = db.Table<SavedCards>()
.Where(card => card.PackNumber == pack && card.CardNumber > cardPosition);
foreach (SavedCards savedCard in reOrderQuery)
{
savedCard.CardNumber = newCardPosition;
db.Update(savedCard);
newCardPosition++;
}
}
}
}
}