public void AddChattingItem(Models.ChattingItems x)
{
this.allItems.Add(x);
using (var conn = ChattingInfoDatabase.GetDbConnection()) {
var Database = conn.Table <Models.ChattingItems>();
conn.Insert(x);
}
NotifyPropertyChanged();
}
public void Clear()
{
this.allItems.Clear();
using (var conn = ChattingInfoDatabase.GetDbConnection()) {
var Database = conn.Table <Models.ChattingItems>();
foreach (var item in Database)
{
conn.Delete(item);
}
}
NotifyPropertyChanged();
}
public void UpdateNick(string uri)
{
foreach (var item in AllItems)
{
item.NickPath = uri;
item.NickImage = new Windows.UI.Xaml.Media.Imaging.BitmapImage(new Uri(uri));
using (var conn = ChattingInfoDatabase.GetDbConnection()) {
var Database = conn.Table <Models.ChattingItems>();
conn.InsertOrReplace(item);
}
}
NotifyPropertyChanged();
}
public void AddChattingItem(int sender, string message, string nickPath)
{
Models.ChattingItems theNew = new Models.ChattingItems()
{
Sender = sender, Msg = message,
NickPath = nickPath,
NickImage = new Windows.UI.Xaml.Media.Imaging.BitmapImage(new Uri(nickPath))
};
this.allItems.Add(theNew);
using (var conn = ChattingInfoDatabase.GetDbConnection()) {
var Database = conn.Table <Models.ChattingItems>();
conn.Insert(theNew);
}
NotifyPropertyChanged();
}
public ChattingViewModels()
{
using (var conn = ChattingInfoDatabase.GetDbConnection()) {
var allDB = conn.Table <Models.ChattingItems>();
string lastNick = "ms-appx://Midnight/Assets/IDPage/Test/tx.jpg";
if (allDB.Count() > 0)
{
lastNick = allDB.Last().NickPath;
}
foreach (var item in allDB)
{
this.allItems.Add(new Models.ChattingItems()
{
id = item.id,
Sender = item.Sender,
Msg = item.Msg,
NickPath = lastNick,
NickImage = new Windows.UI.Xaml.Media.Imaging.BitmapImage(new Uri(lastNick))
});
}
}
}
