private async Task AccountStore(ObservableCollection <AccountsModel> account)
{
try
{
var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "data.db3");
using (var db = new SQLite.SQLiteConnection(dbpath))
{
foreach (AccountsModel accountM in Accounts)
{
var accountInDB = db.Find <AccountsModel>(accountM.Accountid);
if (accountInDB != null)
{
db.Delete(accountM);
}
db.Insert(accountM);
}
db.Commit();
db.Dispose();
db.Close();
}
}
catch (SQLiteException)
{
}
}
async Task RunReadTest()
{
await Task.Factory.StartNew(() =>
{
using (var db = new SQLiteConnection(DatabasePath))
{
db.RunInTransaction(async () => {
var person1 = db.Find<Person>(f => f.FullName.EndsWith("8"));
var person2 = db.Find<Person>(f => f.FullName.EndsWith("3"));
var message = person1 != null && person2 != null
? "Completed!"
: "Did not find both people!";
await dispatcher.RunIdleAsync(a => { ReadResult = message; });
});
}
});
}
private async void ButtonEdit_ClickM(object sender, EventArgs e)
{
using (var con = new SQLite.SQLiteConnection(App.FilePath))
{
Match = (MatchData)MatchViews.SelectedItem;
var matchToEdit = con.Find <MatchData>(Match.MatchId);
await Navigation.PushAsync(new MatchEditEntry(matchToEdit));
}
}
private void ButtonDelete_Click(object sender, EventArgs e)
{
if (DeleteButton.Text == "Delete")
{
DeleteButton.Text = "Confirm?";
DateContent.BackgroundColor = Color.Red;
RatingContent.BackgroundColor = Color.Red;
GoalsContent.BackgroundColor = Color.Red;
AssistsContent.BackgroundColor = Color.Red;
TacklesContent.BackgroundColor = Color.Red;
DribblesContent.BackgroundColor = Color.Red;
KeyPassesContent.BackgroundColor = Color.Red;
StaminaContent.BackgroundColor = Color.Red;
}
else
{
using (var con = new SQLite.SQLiteConnection(App.FilePath))
{
training = (TrainingData)TrainingViews.SelectedItem;
var trainingToDelete = con.Find <TrainingData>(training.TrainingId);
con.Delete <TrainingData>(trainingToDelete.TrainingId);
TrainingViews.ItemsSource = null;
sessions = con.Table <TrainingData>().ToList();
TrainingViews.ItemsSource = sessions;
}
DeleteButton.Text = "Delete";
DateContent.BackgroundColor = Color.Black;
RatingContent.BackgroundColor = Color.Black;
GoalsContent.BackgroundColor = Color.Black;
AssistsContent.BackgroundColor = Color.Black;
TacklesContent.BackgroundColor = Color.Black;
DribblesContent.BackgroundColor = Color.Black;
KeyPassesContent.BackgroundColor = Color.Black;
StaminaContent.BackgroundColor = Color.Black;
DateContent.Text = " ";
RatingContent.Text = " ";
GoalsContent.Text = " ";
AssistsContent.Text = " ";
TacklesContent.Text = " ";
DribblesContent.Text = " ";
KeyPassesContent.Text = " ";
StaminaContent.Text = " ";
}
}
private void BtnSerch_Clicked(object sender, EventArgs e)
{
List <TUser> Users = new List <TUser>();
var id = int.Parse(txId.Text);
string strPath = GetDbPath();
using (var con = new SQLite.SQLiteConnection(strPath))
{
Users.Add(con.Find <TUser>(id));
UserList.ItemsSource = Users;
}
}
private async void ButtonEdit_Click(object sender, EventArgs e)
{
using (var con = new SQLite.SQLiteConnection(App.FilePath))
{
training = (TrainingData)TrainingViews.SelectedItem;
var trainingToEdit = con.Find <TrainingData>(training.TrainingId);
await Navigation.PushAsync(new TrainingEditPage(trainingToEdit));
}
}
public static CourseSchedule FindCourseSchedule (decimal classId)
{
CheckAndCreateDatabase ();
string path = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.Personal), "CourseSchedule.sqlite");
using (SQLiteConnection db = new SQLiteConnection (path)) {
// create the tables
var classSchedule = db.Find<CourseSchedule> (c => c.ClassId == classId);
// close the connection
db.Close ();
return classSchedule;
}
}
public static void UpdateDeck(DeckViewModel deck)
{
using (var database = new SQLiteConnection(databasePath))
{
var _deck = database.Find<Deck>(d1 => d1.Id.ToString() == deck.UniqueId);
if (_deck != null)
{
_deck.CategoryId = new Guid(deck.Category.UniqueId);
_deck.Title = deck.Title;
_deck.Author = deck.Author;
_deck.Subject = deck.Subject;
_deck.Description = deck.Description ;
_deck.ImagePath = deck.ImagePath;
database.Update(deck);
}
}
}
public static void UpdateCategory(CategoryViewModel category)
{
using (var database = new SQLiteConnection(databasePath))
{
var _category = database.Find<Category>(c1 => c1.Id.ToString() == category.UniqueId);
if (_category != null)
{
_category.Name = category.Name;
database.Update(_category);
}
}
}
public static void UpdateCard(CardsViewModel card)
{
using (var database = new SQLiteConnection(databasePath))
{
var _card = database.Find<Card>(c1 => c1.Id.ToString() == card.UniqueId);
if (_card != null)
{
_card.FrontContent = card.FrontContent;
_card.BackContent = card.BackContent;
database.Update(_card);
}
}
}
public static void DeleteDeck(DeckViewModel deck)
{
using (var database = new SQLiteConnection(databasePath))
{
var _deck = database.Find<Deck>(d1 => d1.Id.ToString() == deck.UniqueId);
database.Delete(_deck);
}
}
public static void DeleteCategory(CategoryViewModel category)
{
using (var database = new SQLiteConnection(databasePath))
{
var _category = database.Find<Category>(c1 => c1.Id.ToString() == category.UniqueId);
database.Delete(category);
}
}
public static void DeleteCard(CardsViewModel card)
{
using (var database = new SQLiteConnection(databasePath))
{
var _card = database.Find<Card>(c1 => c1.Id.ToString() == card.UniqueId);
database.Delete(_card);
}
}
static public AlertCategory getAlertCategory(string category)
{
return(db.Find <AlertCategory>(category));
}
public MainWindow(string dbpath)
{
db_ = new SQLiteConnection(dbpath);
db_.CreateTable<Task>();
db_.CreateTable<ProgSettings>();
tasks_ = new ObservableCollection<Task>(db_.Table<Task>().OrderBy(t => t.Order));
settings_ = db_.Find<ProgSettings>(1);
minimise_ = new MinimizeToTray(this, settings_.BallonShown);
settings_.Plugins = new ObservableCollection<Plugin>(new Plugin[] { new PluginCore(settings_), new PluginWords(db_) });
if (settings_ == null)
settings_ = new ProgSettings(db_);
else
settings_.DB = db_;
foreach (Task newItem in tasks_)
{
newItem.PropertyChanged += this.OnItemPropertyChanged;
}
InitializeComponent();
List_Tasks.ItemsSource = tasks_;
Text_Add_Item.Focus();
workArc_.Right = true;
playArc_.Right = false;
workGrey_.Right = false;
playGrey_.Right = true;
customRenders_.Add(workArc_);
customRenders_.Add(playArc_);
customRenders_.Add(workGrey_);
customRenders_.Add(playGrey_);
this.ResetTimer(true, DateTime.Now);
App.Tick += Tick;
Closed += MainWindow_Closed;
mediaPlayer_.Open(new Uri(Environment.CurrentDirectory + "\\bell.mp3"));
mediaPlayer_.Volume = 1.0;
tasks_.CollectionChanged += this.OnCollectionChanged;
}
private void ButtonDelete_ClickM(object sender, EventArgs e)
{
if (DeleteButton.Text == "Delete")
{
DeleteButton.Text = "Confirm?";
DateContent.BackgroundColor = Color.Red;
OpponentContent.BackgroundColor = Color.Red;
MinutesContent.BackgroundColor = Color.Red;
MatchTypeContent.BackgroundColor = Color.Red;
RatingContent.BackgroundColor = Color.Red;
GoalsContent.BackgroundColor = Color.Red;
AssistsContent.BackgroundColor = Color.Red;
TacklesContent.BackgroundColor = Color.Red;
DribblesContent.BackgroundColor = Color.Red;
KeyPassesContent.BackgroundColor = Color.Red;
StaminaContent.BackgroundColor = Color.Red;
}
else
{
using (var con = new SQLite.SQLiteConnection(App.FilePath))
{
Match = (MatchData)MatchViews.SelectedItem;
var matchToDelete = con.Find <MatchData>(Match.MatchId);
con.Delete <MatchData>(matchToDelete.MatchId);
MatchViews.ItemsSource = null;
matches = con.Table <MatchData>().ToList();
MatchViews.ItemsSource = matches;
}
DeleteButton.Text = "Delete";
DateContent.BackgroundColor = Color.Black;
OpponentContent.BackgroundColor = Color.Black;
MinutesContent.BackgroundColor = Color.Black;
MatchTypeContent.BackgroundColor = Color.Black;
RatingContent.BackgroundColor = Color.Black;
GoalsContent.BackgroundColor = Color.Black;
AssistsContent.BackgroundColor = Color.Black;
TacklesContent.BackgroundColor = Color.Black;
DribblesContent.BackgroundColor = Color.Black;
KeyPassesContent.BackgroundColor = Color.Black;
StaminaContent.BackgroundColor = Color.Black;
DateContent.Text = " ";
OpponentContent.Text = " ";
MinutesContent.Text = " ";
MatchTypeContent.Text = " ";
RatingContent.Text = " ";
GoalsContent.Text = " ";
AssistsContent.Text = " ";
TacklesContent.Text = " ";
DribblesContent.Text = " ";
KeyPassesContent.Text = " ";
StaminaContent.Text = " ";
}
}
