async private void btnAddAssessment_Clicked(object sender, EventArgs e)
{
if (ValidateUserInput())
{
Assessment newAssessment = new Assessment();
newAssessment.AssessmentName = txtAssessmentName.Text;
newAssessment.AssessType = pickerAssessmentType.SelectedItem.ToString();
newAssessment.End = dpDueDate.Date;
newAssessment.GetNotified = pickerNotifications.SelectedIndex;
newAssessment.Course = _course.Id;
using (SQLiteConnection con = new SQLiteConnection(App.FilePath))
{
var objectiveCount = con.Query <Assessment>($"SELECT * FROM Assessments WHERE Course = '{_course.Id}' AND AssessType = 'Objective'");
var performanceCount = con.Query <Assessment>($"SELECT * FROM Assessments WHERE Course = '{_course.Id}' AND AssessType = 'Performance'");
if (newAssessment.AssessType.ToString() == "Objective" && objectiveCount.Count == 0)
{
con.Insert(newAssessment);
_main.assessments.Add(newAssessment);
await Navigation.PopModalAsync();
}
else if (newAssessment.AssessType.ToString() == "Performance" && performanceCount.Count == 0)
{
con.Insert(newAssessment);
_main.assessments.Add(newAssessment);
await Navigation.PopModalAsync();
}
else
{
await Navigation.PushModalAsync(new AssessmentError());
}
}
}
else
{
await Navigation.PushModalAsync(new InputError());
}
}
private async void EditAssessment_Clicked(object sender, EventArgs e)
{
string assessmentName = null;
if (PAAssessmentCheckBox.IsChecked && Assessment1.Text != null && Assessment1.Text != "No assessment assigned")
{
assessmentName = Assessment1.Text;
}
else if (OAAssessmentCheckBox.IsChecked && Assessment2.Text != null && Assessment2.Text != "No assessment assigned")
{
assessmentName = Assessment2.Text;
}
else
{
await DisplayAlert("Select Assessment", "Select an assessment to edit.", "OK");
}
if (assessmentName != null)
{
assessment = await App.Database.GetAssessmentAsync(assessmentName);
await Navigation.PushAsync(new EditAssessment(assessment, currentCourse, currentTerm));
}
}
async private void Assessment_Clicked(object sender, ItemTappedEventArgs e)
{
Assessment assessment = (Assessment)e.Item;
await Navigation.PushAsync(new AssessmentPage(assessment));
}
protected override async void OnAppearing()
{
await _connection.CreateTableAsync <Term>();
await _connection.CreateTableAsync <Course>();
await _connection.CreateTableAsync <Assessment>();
var termList = await _connection.Table <Term>().ToListAsync();
// Seed data if there are no Terms
if (!termList.Any())
{
// Seed Data
var newTerm = new Term();
newTerm.Title = "Term 1";
newTerm.StartDate = new DateTime(2020, 09, 01);
newTerm.EndDate = new DateTime(2020, 12, 18);
await _connection.InsertAsync(newTerm);
termList.Add(newTerm);
var newCourse = new Course();
newCourse.CourseName = "Mobile Application";
newCourse.StartDate = new DateTime(2020, 09, 01);
newCourse.EndDate = new DateTime(2020, 12, 18);
newCourse.Status = "Completed";
newCourse.InstructorName = "Tony Martin";
newCourse.InstructorPhone = "509-423-6233";
newCourse.InstructorEmail = "*****@*****.**";
newCourse.NotificationEnabled = 1;
newCourse.Notes = "Notes about the course";
newCourse.Term = newTerm.Id;
await _connection.InsertAsync(newCourse);
Assessment newObjectiveAssessment = new Assessment();
newObjectiveAssessment.Title = "MOP-1";
newObjectiveAssessment.StartDate = new DateTime(2020, 12, 15);
newObjectiveAssessment.EndDate = new DateTime(2020, 12, 18);
newObjectiveAssessment.Course = newCourse.Id;
newObjectiveAssessment.Type = "Objective";
newObjectiveAssessment.NotificationEnabled = 1;
await _connection.InsertAsync(newObjectiveAssessment);
Assessment newPerformanceAssessment = new Assessment();
newPerformanceAssessment.Title = "MAP-1";
newPerformanceAssessment.StartDate = new DateTime(2020, 12, 10);
newPerformanceAssessment.EndDate = new DateTime(2020, 12, 14);
newPerformanceAssessment.Course = newCourse.Id;
newPerformanceAssessment.Type = "Performance";
newPerformanceAssessment.NotificationEnabled = 1;
await _connection.InsertAsync(newPerformanceAssessment);
}
var courseList = await _connection.Table <Course>().ToListAsync();
var assessmentList = await _connection.Table <Assessment>().ToListAsync();
// Sets Notifications for Course and Assessment start/end times
if (_firstAppearnce)
{
_firstAppearnce = false;
int courseId = 0;
foreach (Course course in courseList)
{
courseId++;
if (course.NotificationEnabled == 1)
{
if (course.StartDate == DateTime.Today)
{
CrossLocalNotifications.Current.Show("Reminder", $"{course.CourseName} starts today!", courseId);
}
if (course.EndDate == DateTime.Today)
{
CrossLocalNotifications.Current.Show("Reminder", $"{course.CourseName} ends today!", courseId);
}
}
}
int assessmentId = courseId;
foreach (Assessment assessment in assessmentList)
{
assessmentId++;
if (assessment.NotificationEnabled == 1)
{
if (assessment.StartDate == DateTime.Today)
{
CrossLocalNotifications.Current.Show("Reminder", $"{assessment.Title} starts today!", assessmentId);
}
if (assessment.EndDate == DateTime.Today)
{
CrossLocalNotifications.Current.Show("Reminder", $"{assessment.Title} ends today!", assessmentId);
}
}
}
}
_termList = new ObservableCollection <Term>(termList);
termListView.ItemsSource = _termList;
base.OnAppearing();
}
async void ItemTapped(object sender, ItemTappedEventArgs e)
{
Assessment assessment = (Assessment)e.Item;
await Navigation.PushAsync(new EditAssessmentPage(_course, _main, assessment));
}
public Task <int> DeleteAssessmentAsync(Assessment assessment)
{
return(database.DeleteAsync(assessment));
}
public AssessmentDetails(Assessment assessment)
{
var currentAssessment = assessment;
InitializeComponent();
}
public async static void Populate()
{
Instructor instructor = new Instructor();
instructor.Name = "Stacey Williams";
instructor.Phone = "(111)111-1111";
instructor.Email = "*****@*****.**";
await App.Database.SaveInstructorAsync(instructor);
Instructor instructor2 = new Instructor();
instructor2.Name = "Kirk Patreece";
instructor2.Phone = "(222)222-2222";
instructor2.Email = "*****@*****.**";
await App.Database.SaveInstructorAsync(instructor2);
Instructor instructor3 = new Instructor();
instructor3.Name = "Tim Staulings";
instructor3.Phone = "(333)333-3333";
instructor3.Email = "*****@*****.**";
await App.Database.SaveInstructorAsync(instructor3);
Instructor instructor4 = new Instructor();
instructor4.Name = "Lane Berksdale";
instructor4.Phone = "(444)444-4444";
instructor4.Email = "*****@*****.**";
await App.Database.SaveInstructorAsync(instructor4);
Instructor instructor5 = new Instructor();
instructor5.Name = "Christian Miller";
instructor5.Phone = "(555)555-5555";
instructor5.Email = "*****@*****.**";
await App.Database.SaveInstructorAsync(instructor5);
Instructor instructor6 = new Instructor();
instructor6.Name = "Laura Wilks";
instructor6.Phone = "(666)666-6666";
instructor6.Email = "*****@*****.**";
await App.Database.SaveInstructorAsync(instructor6);
Instructor instructor7 = new Instructor();
instructor7.Name = "Robert Haines";
instructor7.Phone = "(256)652-7448";
instructor7.Email = "*****@*****.**";
await App.Database.SaveInstructorAsync(instructor7);
Assessment assessment = new Assessment();
assessment.Name = "assessment1";
assessment.AssessmentType = "PA";
assessment.AssessmentDescription = "Presentation";
await App.Database.SaveAssessmentAsync(assessment);
Assessment assessment2 = new Assessment();
assessment2.Name = "assessment2";
assessment2.AssessmentType = "PA";
assessment2.AssessmentDescription = "Coding Challenge";
await App.Database.SaveAssessmentAsync(assessment2);
Assessment assessment3 = new Assessment();
assessment3.Name = "assessment3";
assessment3.AssessmentType = "PA";
assessment3.AssessmentDescription = "Proposal Paper";
await App.Database.SaveAssessmentAsync(assessment3);
Assessment assessment4 = new Assessment();
assessment4.Name = "assessment4";
assessment4.AssessmentType = "PA";
assessment4.AssessmentDescription = "Essay";
await App.Database.SaveAssessmentAsync(assessment4);
Assessment assessment5 = new Assessment();
assessment5.Name = "assessment5";
assessment5.AssessmentType = "PA";
assessment5.AssessmentDescription = "Mobile Application";
await App.Database.SaveAssessmentAsync(assessment5);
Assessment assessment6 = new Assessment();
assessment6.Name = "assessment6";
assessment6.AssessmentType = "OA";
assessment6.AssessmentDescription = "40 Question Test";
await App.Database.SaveAssessmentAsync(assessment6);
Assessment assessment7 = new Assessment();
assessment7.Name = "assessment7";
assessment7.AssessmentType = "OA";
assessment7.AssessmentDescription = "50 Question Test";
await App.Database.SaveAssessmentAsync(assessment7);
Assessment assessment8 = new Assessment();
assessment8.Name = "assessment8";
assessment8.AssessmentType = "OA";
assessment8.AssessmentDescription = "60 Question Test";
await App.Database.SaveAssessmentAsync(assessment8);
Assessment assessment9 = new Assessment();
assessment9.Name = "assessment9";
assessment9.AssessmentType = "OA";
assessment9.AssessmentDescription = "CompTIA Certification";
await App.Database.SaveAssessmentAsync(assessment9);
Assessment assessment10 = new Assessment();
assessment10.Name = "assessment10";
assessment10.AssessmentType = "OA";
assessment10.AssessmentDescription = "Microsoft Certification";
await App.Database.SaveAssessmentAsync(assessment10);
Course course = new Course();
course.Name = "Software Introduction";
course.Status = "Inactive";
course.InstructorID = instructor7.InstructorID;
course.AssessmentID = assessment4.AssessmentID;
course.Assessment2ID = assessment6.AssessmentID;
await App.Database.SaveCourseAsync(course);
Course course2 = new Course();
course2.Name = "Ethics";
course2.Status = "Inactive";
course2.InstructorID = instructor2.InstructorID;
course2.AssessmentID = assessment.AssessmentID;
course2.Assessment2ID = assessment7.AssessmentID;
await App.Database.SaveCourseAsync(course2);
Course course3 = new Course();
course3.Name = "Algebra";
course3.Status = "Inactive";
course3.InstructorID = instructor3.InstructorID;
course3.AssessmentID = assessment3.AssessmentID;
course3.Assessment2ID = assessment8.AssessmentID;
await App.Database.SaveCourseAsync(course3);
Course course4 = new Course();
course4.Name = "Quality Assurance";
course4.Status = "Inactive";
course4.InstructorID = instructor4.InstructorID;
course4.AssessmentID = assessment.AssessmentID;
course4.Assessment2ID = assessment6.AssessmentID;
await App.Database.SaveCourseAsync(course4);
Course course5 = new Course();
course5.Name = "Software Development 1";
course5.Status = "Inactive";
course5.InstructorID = instructor5.InstructorID;
course5.AssessmentID = assessment4.AssessmentID;
course5.Assessment2ID = assessment10.AssessmentID;
await App.Database.SaveCourseAsync(course5);
Course course6 = new Course();
course6.Name = "Software Development 2";
course6.Status = "Inactive";
course6.InstructorID = instructor6.InstructorID;
course6.AssessmentID = assessment2.AssessmentID;
course6.Assessment2ID = assessment9.AssessmentID;
await App.Database.SaveCourseAsync(course6);
Course course7 = new Course();
course7.Name = "Sql Database";
course7.Status = "Inactive";
course7.InstructorID = instructor.InstructorID;
course7.AssessmentID = assessment2.AssessmentID;
course7.Assessment2ID = assessment10.AssessmentID;
await App.Database.SaveCourseAsync(course7);
Course course8 = new Course();
course8.Name = "Technical Communication";
course8.Status = "Inactive";
course8.InstructorID = instructor2.InstructorID;
course8.AssessmentID = assessment3.AssessmentID;
course8.Assessment2ID = assessment8.AssessmentID;
await App.Database.SaveCourseAsync(course8);
Course course9 = new Course();
course9.Name = "UI Design";
course9.Status = "Inactive";
course9.InstructorID = instructor3.InstructorID;
course9.AssessmentID = assessment2.AssessmentID;
course9.Assessment2ID = assessment7.AssessmentID;
await App.Database.SaveCourseAsync(course9);
Course course10 = new Course();
course10.Name = "Capstone";
course10.Status = "Inactive";
course10.InstructorID = instructor4.InstructorID;
course10.AssessmentID = assessment3.AssessmentID;
course10.Assessment2ID = assessment8.AssessmentID;
await App.Database.SaveCourseAsync(course10);
Course course11 = new Course();
course11.Name = "Technical Writing";
course11.Status = "Inactive";
course11.InstructorID = instructor5.InstructorID;
course11.AssessmentID = assessment4.AssessmentID;
course11.Assessment2ID = assessment6.AssessmentID;
await App.Database.SaveCourseAsync(course11);
Course course12 = new Course();
course12.Name = "Mobile Application";
course12.Status = "Inactive";
course12.InstructorID = instructor6.InstructorID;
course12.AssessmentID = assessment5.AssessmentID;
course12.Assessment2ID = assessment9.AssessmentID;
await App.Database.SaveCourseAsync(course12);
Course course13 = new Course();
course13.Name = "C# Basics";
course13.Status = "Inactive";
course13.InstructorID = instructor7.InstructorID;
course13.AssessmentID = assessment.AssessmentID;
course13.Assessment2ID = assessment6.AssessmentID;
await App.Database.SaveCourseAsync(course13);
Course course14 = new Course();
course14.Name = "Operating Systems for Developers";
course14.Status = "Inactive";
course14.InstructorID = instructor2.InstructorID;
course14.AssessmentID = assessment2.AssessmentID;
course14.Assessment2ID = assessment7.AssessmentID;
await App.Database.SaveCourseAsync(course14);
Course course15 = new Course();
course15.Name = "HTML / CSS";
course15.Status = "Inactive";
course15.InstructorID = instructor3.InstructorID;
course15.AssessmentID = assessment4.AssessmentID;
course15.Assessment2ID = assessment8.AssessmentID;
await App.Database.SaveCourseAsync(course15);
Course course16 = new Course();
course16.Name = "JavaScript Basics";
course16.Status = "Inactive";
course16.InstructorID = instructor4.InstructorID;
course16.AssessmentID = assessment5.AssessmentID;
course16.Assessment2ID = assessment9.AssessmentID;
await App.Database.SaveCourseAsync(course16);
Term term = new Term();
term.Name = "Term1";
term.StartDate = DateTime.Now.Date;
term.EndDate = DateTime.Now.AddMonths(6).Date;
term.CourseID = course.CourseID;
term.Course2ID = course2.CourseID;
term.Course3ID = course3.CourseID;
term.Course4ID = course4.CourseID;
term.Course5ID = course5.CourseID;
term.Course6ID = course6.CourseID;
await App.Database.SaveTermAsync(term);
Term term2 = new Term();
term2.Name = "Term2";
term2.StartDate = DateTime.Now.AddMonths(6).Date;
term2.EndDate = DateTime.Now.AddMonths(12).Date;
term2.CourseID = course7.CourseID;
term2.Course2ID = course8.CourseID;
term2.Course3ID = course9.CourseID;
term2.Course4ID = course10.CourseID;
term2.Course5ID = course11.CourseID;
term2.Course6ID = course12.CourseID;
await App.Database.SaveTermAsync(term2);
}
