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); }