protected override void OnNavigatedTo(NavigationEventArgs e)
{
try
{
base.OnNavigatedTo(e);
getIds = (string)e.Parameter;
getParentID = getIds.Substring(0,1);
getChildID = getIds.Substring(2);
objChildrenViewModel = new ChildrenViewModel();
objRegChild = new RegisterChild();
objRegChild = objChildrenViewModel.getChildDetails(Convert.ToInt32(getChildID), Convert.ToInt32(getParentID));
testsViewModel = new TestsViewModel();
test = testsViewModel.GetTests(Convert.ToInt32(getIds.Substring(2)));
lsViewTest.Items.Add("Test ID" + "\t" + "Right" + "\t" + "Wrong" + "\t" + "Date & Time");
foreach (var c in test)
{
lsViewTest.Items.Add(c.Id + " \t" + c.RightAnswers + "\t" + c.WrongAnswers + "\t" + c.Date);
}
base.OnNavigatedTo(e);
lblChId.Text = "" + objRegChild.Id + " - " + objRegChild.Name + " " + objRegChild.Surname;
}
catch (Exception)
{
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
try
{
base.OnNavigatedTo(e);
parentId = (int)e.Parameter;
childrensViewModel = new ChildrensViewModel();
children = childrensViewModel.GetChildren(parentId);
regChild = new RegisterChild();
lsvChooseChild.Items.Add("ID" + "-" + "NAME_SURNAME");
foreach(var c in children)
{
lsvChooseChild.Items.Add(c.Id + "-" + c.Name + "_" + c.Surname);
selectedChildId = c.Id;
//Retrive selecte element from listView
//regChild = (RegisterChild)lsViewChildren.SelectedValue;
}
//var sel = lsViewChildren.SelectedItems.Cast<Object>.ToArray();
regChild = (RegisterChild)lsvChooseChild.SelectedValue;
base.OnNavigatedTo(e);
}
catch (Exception)
{
}
}
//Display the ID of the parent currently logged in
protected override void OnNavigatedTo(NavigationEventArgs e)
{
regChild = new RegisterChild();
try
{
base.OnNavigatedTo(e);
regChild = (RegisterChild)e.Parameter;
idNum = "" + regChild.Id;
name = "" + regChild.Name;
surname = "" + regChild.Surname;
age = "" + regChild.Age;
grade = "" + regChild.Grade;
parentID = "" + regChild.ParentId;
//Display Child details on load Code
lblChildsID.Text = idNum;
txtCurrentChildName.Text = name;
txtCurrentChildSurname_.Text = surname;
txtCurrentChildAge.Text = age;
cbCurrentChildGrade.Items.Add(grade);
cbCurrentChildGrade.Items.Add("");
cbCurrentChildGrade.Items.Add("Grade 1");
cbCurrentChildGrade.Items.Add("Grade 2");
//displayChildsDetails(idNum, name, age, grade);
}
catch (Exception)
{
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
try
{
base.OnNavigatedTo(e);
getIds = (string)e.Parameter;
parentID = Convert.ToInt32(getIds.Substring(0, 1));
childID = Convert.ToInt32(getIds.Substring(2));
objRegChild = new RegisterChild();
objChildrenViewModel = new ChildrenViewModel();
objRegChild = objChildrenViewModel.getChildDetails(childID, parentID);
base.OnNavigatedTo(e);
}
catch (Exception)
{
}
}
//Button to delete all child test results
private void btnDeleteAll_Click(object sender, RoutedEventArgs e)
{
if(!getChildID.Equals(""))
{
int convChildId = myChildId(getChildID);
int convParentId = myParentId(getParentID);
objChildrenViewModel = new ChildrenViewModel();
objRegChild = new RegisterChild();
objTestViewModel = new TestViewModel();
objRegChild = objChildrenViewModel.getChildDetails(convChildId, convParentId);
objTestViewModel.deleteChildTestRecords(convChildId);
this.Frame.Navigate(typeof(SelectChildToViewPage), convParentId);
string msg = "All child test records for " + objRegChild.Name + " " + objRegChild.Surname + " were successfully deleted";
messageBox(msg);
}
else
{
messageBox("Child id can't be empty!");
}
}
//Button to update child details
private void btnEditChildDetails_Click(object sender, RoutedEventArgs e)
{
regChild = new RegisterChild();
childrenViewModel = new ChildrenViewModel();
int convertChildId = 0;
int convertParentId = 0;
string strMsg = "";
try
{
int verifyNum;
bool isNumerical = int.TryParse(idNum, out verifyNum);
if (idNum.Equals("") || isNumerical == false)
{
strMsg = "Please select a child first before proceeding with the editing process!";
messageBox(strMsg);
}
else
{
convertChildId = Convert.ToInt32(idNum);
convertParentId = Convert.ToInt32(parentId);
regChild = childrenViewModel.getChildDetails(convertChildId, parentId);
if ((convertChildId <= 0) && (convertParentId <= 0))
{
strMsg = "Please select a child first before proceeding with the editing process!";
messageBox(strMsg);
}
else
{
if (regChild != null)
{
this.Frame.Navigate(typeof(EditedSelectedChildPage), regChild);
string msg = "Found child details in the database!";
messageBox(msg);
}
else
{
string msg = "Couldn't retrive child infomation from the database";
messageBox(msg);
}
}
}
}
catch(Exception)
{
}
}
//Retrive all Parent details from the database where email and password match user inputs
public RegisterChild getChildDetails(int id, int parentId)
{
reg = new RegisterChild();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
reg = db.Query<RegisterChild>("Select * from Child where Id =" + id + " and ParentId = '"+ parentId +"'").FirstOrDefault();
}
return reg;
}
