public ObservableCollection<SubjectViewModel> GetAllSubjects(int CurrentID)
{
subjects = new ObservableCollection<SubjectViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var q = db.Query<Subject>("select * from subject where MemID = "+CurrentID+" ");
foreach (var _subject in q)
{
var subject = new SubjectViewModel()
{
Id = _subject.Id,
SbjName = _subject.SbjName,
SbjMark = _subject.SbjMark,
ObtainMark = _subject.ObtainMark,
Performance = _subject.Performance,
};
subjects.Add(subject);
}
}
return subjects;
}
private void btnAddSubject_Click(object sender, RoutedEventArgs e)
{
var objSubject = new SubjectViewModel();
string sbjName = string.Empty;
int sbjMark = 0;
int verifyNum;
string status = string.Empty;
try
{
bool isNumeric = int.TryParse(txbGoalMark.Text, out verifyNum);
if (isNumeric == true)
{
sbjName = txbSubject.Text;
sbjMark = Convert.ToInt16(txbGoalMark.Text);
if (!sbjName.Equals(""))
{
if ((sbjMark >= 50) && (sbjMark <= 100))
{
if (verifyDuplication(sbjName) != true)
{
objSubject.SetSubject(sbjName, sbjMark, GetID);
status = "Successfully added" + "\n" + sbjName + " with a goal mark of " + sbjMark;
lstOutput.Items.Add("Name: " + sbjName + "\nGoal mark of: " + sbjMark);
txbSubject.Text = "";
txbGoalMark.Text = "";
}
else
{
status = "Subject name already exist. \nPlease choose another name.";
}
}
else
{
status = "Please specify the goal mark between 50 and 100.";
}
}
else
{
status = "Please fill the subject name";
}
}
else
{
status = "Please enter a numeric number on the goal mark.";
}
}
catch (Exception ex)
{
messageBox("error " + ex.Message);
}
if (status != string.Empty)
messageBox(status);
}
private void btnClear_Click(object sender, RoutedEventArgs e)
{
var objSubject = new SubjectViewModel();
var objReminder = new ReminderViewModel();
var objStudy = new StudyViewModel();
string output = (string)cmbOutput.SelectedItem;
string table = string.Empty;
try
{
if (output == "Progress")
{
lsvOutput.Items.Clear();
objSubject.RemoveSubject(GetID);
}
else if (output == "Reminders")
{
lsvOutput.Items.Clear();
objReminder.RemoveReminder(GetID);
}
else if (output == "StudyTime")
{
lsvOutput.Items.Clear();
objStudy.RemoveStudy(GetID);
}
btnClear.Visibility = Visibility.Collapsed;
}
catch (Exception ex)
{
if (output == "Progress")
table = "Subjects";
else if (output == "Reminders")
table = "Reminders";
else if (output == "StudyTime")
table = "StudyTimes";
messageBox("error " + ex.Message + "\nPlease add " + table);
}
}
private void btnMark_Click(object sender, RoutedEventArgs e)
{
var objSubject = new SubjectViewModel();
string studyName = string.Empty;
string Performance = string.Empty;
string status = string.Empty;
int mark = 0;
int verifyNum;
try
{
bool isNumeric = int.TryParse(edtMark.Text, out verifyNum);
studyName = (string)cmbSubjects.SelectedItem;
var confirm = objSubject.getSubject(studyName, GetID);
if (confirm != null)
{
if (isNumeric == true)
{
mark = Convert.ToInt16(edtMark.Text);
if ((mark > 0) && (mark <= 100))
{
if (mark > confirm.SbjMark)
{
Performance = "Better";
status = "Performing better than the goal mark of " + Convert.ToString(confirm.SbjMark);
}
else if (mark == confirm.SbjMark)
{
Performance = "Good";
status = "Performing good, the marks are equal of " + Convert.ToString(confirm.SbjMark);
}
else if (mark < confirm.SbjMark)
{
Performance = "Badly";
status = "Performing badly than the goal mark of " + Convert.ToString(confirm.SbjMark);
}
objSubject.UpdateSubject(studyName, mark, Performance, GetID);
messageBox(status);
}
else
{
messageBox("Please specify a number between 0 and 100");
}
}
else
{
messageBox("Please specify a numeric obtained mark");
}
}
else
{
messageBox("Please select a subject");
}
}
catch (Exception ex)
{
messageBox("error " + ex.Message);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var studyStartTime = tmpStart.Time;
var studyEndTime = studyStartTime + TimeSpan.FromSeconds(10);
var studyStartTime1 = tmpEnd.Time;
var studyEndTime1 = studyStartTime1 + TimeSpan.FromSeconds(10);
time = studyEndTime1 - studyEndTime;
var objStudy = new StudyViewModel();
string studyName = string.Empty;
var objSubject = new SubjectViewModel();
string status = string.Empty;
studyName = (string)cmbSubjects.SelectedItem;
try
{
studyName = (string)cmbSubjects.SelectedItem;
var confirm = objSubject.getSubject(studyName,GetID);
if (confirm != null)
{
if (FutureTime())
{
if (GreaterEndTime())
{
objStudy.SetStudy(studyName, time.ToString(),GetID);
timer.Start();
}
else
{
status = "End time must be greater than the start time";
}
}
else
{
status = "Start time must be greater than the current time";
}
}
else
{
status = "Please select a subject to study";
}
}
catch (Exception ex)
{
messageBox("error " + ex.Message);
}
if (status != string.Empty)
messageBox(status);
}
