public TimeLines_n_CreateBig_Page()
{
this.InitializeComponent();
//CurrentUserName = "******";
//SignInUserPwd.Text = "******";
//TODO: ARS-Get user's Name for Interactive.
CurrentUserName = "******";
using (var db = new PRSappContext())
{
//UsersDefaulHomePageListView.ItemsSource = db.Titles.ToList();
ShowTitlesListView.ItemsSource = db.Titles.ToList();
//UpdateTitlesListView.ItemsSource = db.Titles.ToList();
//DeleteTitlesListView.ItemsSource = db.Titles.ToList();
}
}
private static void Main()
{
SetupDatabase();
using (var db = new PRSappContext())
{
#region Query
var pListAndItems = db.PlayListAndItems.ToList();
foreach (var pListAndItem in pListAndItems)
{
Console.WriteLine($"{pListAndItem.PlayListName} has {pListAndItem.PlayListName} PlayListItems.");//
Console.WriteLine();
}
#endregion
}
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
#region Show current users titles
using (var context = new PRSappContext())
{
var usersTitles =
from t in context.Titles
where t.UserId == CurrentUserId
orderby t.TitleId descending
select t;
List <Title> selectedUsersTitles = usersTitles.ToList();
//foreach (var title in selectedUsersTitles)
//{
// Debug.WriteLine(selectedUsersTitles.ToString());
//}
//Refresh ListView's ItemsSource
ShowTitlesListView.ItemsSource = selectedUsersTitles;
}
#endregion
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
using (var db = new PRSappContext())
{
ShowTitlesListView.ItemsSource = db.Titles.ToList();
}
#region Show current users titles
using (var context = new PRSappContext())
{
var usersTitles =
from t in context.Titles
where t.UserId == CurrentUserId
orderby t.TitleId descending
select t;
List <Title> selectedUsersTitles = usersTitles.ToList();
//Refresh ListView's ItemsSource
ShowTitlesListView.ItemsSource = selectedUsersTitles;
}
#endregion
}
/// <summary>
/// Initializes the singleton application object. This is the first line of authored code
/// executed, and as such is the logical equivalent of main() or WinMain().
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
#region ARS- code set 1.1 (part 1 or 2) Handling PRSapp app life cycle
//ORIGIN of this code Set https://docs.microsoft.com/en-us/windows/uwp/launch-resume/reduce-memory-usage
// Subscribe to key lifecyle events to know when the app
// transitions to and from foreground and background.
// Leaving the background is an important transition
// because the app may need to restore UI.
this.EnteredBackground += AppEnteredBackground;
this.LeavingBackground += AppLeavingBackground;
// During the transition from foreground to background the
// memory limit allowed for the application changes. The application
// has a short time to respond by bringing its memory usage
// under the new limit.
Windows.System.MemoryManager.AppMemoryUsageLimitChanging += MemoryManager_AppMemoryUsageLimitChanging;
// After an application is backgrounded it is expected to stay
// under a memory target to maintain priority to keep running.
// Subscribe to the event that informs the app of this change.
Windows.System.MemoryManager.AppMemoryUsageIncreased += MemoryManager_AppMemoryUsageIncreased;
#endregion
////ARS- The Below Using statement is to: Add Code to create the database on application startup\\\\
//Since you want the database to be created on the device that the app runs on, add code
//to apply any pending migrations to the local database on application startup.
//The first time that the app runs, this will take care of creating the local database.
using (var db = new PRSappContext())
{
db.Database.Migrate();
}
}
private void ShowTitlesListView_OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
//Title dt_t = new Title();
//List<Title> ts = new List<Title>();
//ts.Add(dt_t.TitleId = 100);
// dt_t.TitleName = "Name1",
// dt_t.TtsRaw="IpsumLipsi",
// dt_t.UserId= 44,
// dt_t.DirPath = "C:Users\\Documents\\Media");
//ts.Add("TitleName1", "C:Users\\Documents\\Media");
//Multi selection
if (ShowTitlesListView.SelectedItems.Count > 1)
{
// List<Object> DeletionTitles;// = new List<Title>();
// List<Title> DeletionTitles = ((Title)ShowTitlesListView.SelectedItems);
// DeletionTitles.AddRange(SelectedTitles);
//List<Title> selectedTitles = selectedTitlesID;
//Get public Title Id for Deleting a single and user forgets to select it
// SelectedTitleId = selectedTitlesID.TitleId;
//var TitlesList = new List<Title>();
//using (var context = new PRSappContext())
//{
// var TitlesSelected =
// from t in context.Titles
// where t.TitleId == DeletionTitles.TitleId
// select t;
// // TitleListIds.AddRange(usersTitleDetails);
// TitleListIds = TitlesSelected.ToList();
// foreach (var item in TitleListIds)
// {
// Trace.WriteLine(item);
// }
//Refresh Show Titles List View
List <Title> selectedTitles = TitleListIds; //usersTitleDetails.ToList();
}
//}
//== "test")
//if (ShowTitlesListView.SelectedItems.Count > 1)
//{
// Title selectedTitleID = ((Title)ShowTitlesListView.SelectedItem);
// List<Title> selectedTitlesID = new List<Title>();
// //Get public Title Id for Deleting a single and user forgets to select it
// SelectedTitleId = selectedTitleID.TitleId;
// var TitlesList = new List<Title>();
// using (var context = new PRSappContext())
// {
// var usersTitleDetails =
// from t in context.Titles
// where t.TitleId == selectedTitleID.TitleId
// select t;
// // TitleListIds.AddRange(usersTitleDetails);
// List<Title> selectedUsersTitles = TitleListIds; //usersTitleDetails.ToList();
// }
//}
DataPackage dataPackage = new DataPackage();
foreach (var item in e.AddedItems.OfType <ListViewItem>())
{
// copy
dataPackage.RequestedOperation = DataPackageOperation.Copy;
}
//TitlesListView Title = ((new_client)Listview.SelectedItem);
//MyClient.new_name;
//MyClient.new_clientId;
if (ShowTitlesListView.SelectedItems.Count > 0)
{
Title selectedTitleID = ((Title)ShowTitlesListView.SelectedItem);
int _selectedTitleID = selectedTitleID.TitleId;
//Get public Title Id for Deleting a single and user forgets to select it
SelectedTitleId = selectedTitleID.TitleId;
using (var context = new PRSappContext())
{
var usersTitleDetails =
from t in context.Titles
where t.TitleId == selectedTitleID.TitleId
select t;
List <Title> selectedUsersTitles = usersTitleDetails.ToList();
////TitleDetailsListView.ItemsSource = selectedUsersTitles;
////TitleDetailsListView.SelectedIndex = 0;
}
}
#region Commented code for Selected item, Index, DataValue, and DataValuePath
// Debug.WriteLine("Selected: {0}", e.AddedItems[0]);
// SelectedItemIndex = ShowTitlesListView.SelectedIndex;
// Debug.WriteLine(SelectedItemIndex.ToString());
// SelectedItem = ShowTitlesListView.SelectedItem;
// Debug.WriteLine(SelectedItem.ToString());
// var SelectedDataValue = ShowTitlesListView.SelectedValue;
// Debug.WriteLine(SelectedDataValue.ToString());
// var SelectedValuePath = ShowTitlesListView.SelectedValuePath;
// Debug.WriteLine(SelectedValuePath.ToString());
// String text = UsersTitlesPListView.SelectedItems[2].ToString();
//do something
// var lookat = text;
//var item = e.AddedItems?.FirstOrDefault();
////int Uid = (int)item.ToString
//if (TitlesListView.SelectedItems.Count > 0)
//{
// var itemrow = ShowTitlesListView.SelectedItems[0];
// //rest of your logic
//}
//if (TitlesListView.SelectedItems.Count > 0)
//{
// var myitem = ShowTitlesListView.SelectedItems[0];
// //rest of your logic
//}
#endregion
}
private async void DeleteSelectionAsync_Click(object sender, RoutedEventArgs e)
{
//List<Object> items = ShowTitlesListView.SelectedItems.Cast<ListViewItem>()
// .Select(item => item.tit)
//List<SelectedItems> selItems = new List<SelectedItems>();
var listViewItems = ShowTitlesListView.SelectedItems;
foreach (var item in listViewItems)
{
}
//ListView.sho; SelectedItems selectedItems
// = new
//I need to to get the selected items into a list first.
//Multi selection
if (ShowTitlesListView.SelectedItems.Count > 0)
{
// List<Title> selectedtitles = new List<Title>()
// {
// foreach(var item in ShowTitlesListView.SelectedItems)
// new Department(){TitleID=1},
// new Department(){Id=2},
// new Department(){Id=3}
//};
// (Title)ShowTitlesListView = ((Title)ShowTitlesListView.SelectedItems);
using (var context = new PRSappContext())
{
//(
//var queryresults =
// from t in context.Titles
// where t.TitleId == ShowTitlesListView.SelectedItems.Add() // && t.TitleId == SelectedTitleId
// select t;
//context.Titles.RemoveRange(selectedTitles);
await context.SaveChangesAsync();
//Refresh listview after delete
var queryresults =
from t in context.Titles
where t.UserId == CurrentUserId // && t.TitleId == SelectedTitleId
select t;
int count = queryresults.Count();
if (count > 0)
{
//Put queryresults into a collection
List <Title> selectedUsersTitles = queryresults.ToList();
//Load Update Title Panel with Selected Item
ShowTitlesListView.ItemsSource = selectedUsersTitles;
}
//List<Title> titles = new List<Title>();
//titles = (Title)ShowTitlesListView.SelectedItems;
//context.Titles.RemoveRange(items);
}
}
//TODO: ARS- Use this if/else approach for PlayListFxsDetails List or Titles List
// becuase we only want one item/row/title domain object at a sime here
////if(TitleDetailsListView.SelectedItems.Count > 0)
////{
// var title = new Title()
//{
// TitleId = DeleteTitleId
//};
//using (var context = new PRSappContext())
//{
// //EntityState is set as ‘Deleted’
// context.Titles.Remove(title);
// //Have EF Core actually delete record from db
// context.SaveChanges();
// //Refresh listview after delete
// var queryresults =
// from t in context.Titles
// where t.UserId == CurrentUserId
// select t;
// int count = queryresults.Count();
// if (count > 0)
// {
// //Put queryresults into a collection
// List<Title> selectedUsersTitles = queryresults.ToList();
// //Load Update Title Panel with Selected Item
// TitleDetailsListView.ItemsSource = selectedUsersTitles;
// }
// ////else
// ////{
// ////}
//}
////}
}
private async void AddTitleBigAsync_Click(object sender, RoutedEventArgs e)
{
string ttsRaw;
string tag = (sender as Button).Tag.ToString();
if (tag == "btnAddTitleBigAsync")
{
#region validation user input checking (if,else if)
if (String.IsNullOrEmpty(boxAddTitleNameBig.Text.Trim()))
{
ttsRaw = CurrentUserName + "," +
"some belive, that one should give the title a name before adding it.";
boxAddTitleNameBig.Focus(FocusState.Pointer);
try
{
await this.SpeakTextAsync(ttsRaw, this.uiMediaElement);
}
catch (Exception ex)
{ Debug.WriteLine(ex.Message.ToString()); }
return;
}
else if (String.IsNullOrEmpty(boxTtsRawBig.Text.Trim()))
{
ttsRaw = "Confucious say" + "." +
", there are times when it helps to give it something" +
" to speak before adding it.";
boxTtsRawBig.Focus(FocusState.Pointer);
try
{
await this.SpeakTextAsync(ttsRaw, this.uiMediaElement);
}
catch (Exception ex)
{ Debug.WriteLine(ex.Message.ToString()); }
return;
}
#endregion
using (var context = new PRSappContext())
{
var title = new Title
{
//TitleId = Auto Generated - Primary Key
TitleName = boxAddTitleNameBig.Text,
TtsRaw = boxTtsRawBig.Text,
UserId = CurrentUserId,
DirPath = "In Database"
//Titles = new List<Title>
//{
// new Title
// {
// TitleName = NewTitleTitleName.Text,
// TtsRaw = NewTitleTtsRaw.Text
// },
//}
};
context.Titles.Add(title);
//Async Save
await context.SaveChangesAsync();
#region refresh Titles and Titles Details of Title just Added
var usersTitles =
from t in context.Titles
where t.UserId == CurrentUserId
orderby t.TitleId descending
select t;
List <Title> refreshedUsersTitles = usersTitles.ToList();
//ShowTitlesListView.ItemsSource = refreshedUsersTitles;
//validation logic
btnAddTitleBigAsync.IsEnabled = false;
#endregion
#region validation logic
boxAddTitleNameBig.IsReadOnly = true;
boxTtsRawBig.IsReadOnly = true;
btnTestPlayBig.Focus(FocusState.Pointer);
#endregion
}
#region refresh Titles and Title Details of Title just Added
//TODO: ARS- Get last PK Id Inserted
using (var context = new PRSappContext())
{
var usersTitle =
(from t in context.Titles
// where t.UserId == CurrentUserId
// select t;
where t.UserId == CurrentUserId
orderby t.TitleId descending
select t); //.FirstOrDefault();
var takeOne = usersTitle.Take(1);
List <Title> refreshedUsersTitles = takeOne.ToList();
//TitleDetailsListView.ItemsSource = refreshedUsersTitles;
}
#endregion
}
}
private static void SetupDatabase()
{
using (var db = new PRSappContext())
{
if (db.Database.EnsureCreated())
{
//working way down
db.PlayLists.Add(
new PlayList
{
Name = "Fish PlayList",
Uses = "ForceTalk",
PlayListItems = new List <PlayListItem>
{
new PlayListItem {
ItemTitleName = "Fish care 101"
},
new PlayListItem {
ItemTitleName = "Caring for tropical fish"
},
new PlayListItem {
ItemTitleName = "Types of ornamental fish"
}
}
});
db.PlayLists.Add(
new PlayList
{
Name = "Cats PlayList",
Uses = "t-30",
PlayListItems = new List <PlayListItem>
{
new PlayListItem {
ItemTitleName = "Cat care 101"
},
new PlayListItem {
ItemTitleName = "Caring for tropical cats"
},
new PlayListItem {
ItemTitleName = "Types of ornamental cats"
}
}
});
db.PlayLists.Add(
new PlayList
{
Name = "Catfish PlayList",
Uses = "Reminder",
PlayListItems = new List <PlayListItem>
{
new PlayListItem {
ItemTitleName = "Catfish care 101"
},
new PlayListItem {
ItemTitleName = "History of the catfish name"
}
}
});
db.SaveChanges();
//I created view manually in sqlite manager
//#region View
//db.Database.ExecuteSqlCommand(
// @"CREATE VIEW View_PlayListAndItems AS
// SELECT b.Name, Count(p.PlayListItemId) as ItemCount
// FROM PlayLists b
// JOIN PlayListItems p on p.PlayListId = b.PlayListId
// GROUP BY b.Name");
//#endregion
}
}
}
