private void btnAdd_Click(object sender, RoutedEventArgs e) { Sqlite.ExecuteNonQuery(Query.addStudentToGroup(addstudentnum, addgroupNum)); dgStudentsInGroup.ItemsSource = dataTracker.getGroupStudents(groupID.ToString()); dgStudentsInGroup.Items.Refresh(); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (tbFName.Text != null && tbLName.Text != null) { StudentList = new StudentDetail(); if (int.TryParse(tbSId.Text.ToString(), out int SId)) { StudentList.studentId = SId; } StudentList.firstName = tbFName.Text; StudentList.lastName = tbLName.Text; if (int.TryParse(tbEId.Text.ToString(), out int EId)) { StudentList.educatorId = EId; } if (int.TryParse(tbGLevel.Text.ToString(), out int gLvl)) { StudentList.gradeLevel = gLvl; } StudentList.sFullName = tbLName.Text.ToString() + "," + tbFName.Text.ToString(); Sqlite.ExecuteNonQuery(Query.insertStudent(StudentList)); Close(); } }
private void btDescdel_Click(object sender, RoutedEventArgs e) { try { MessageBoxResult result; //prompt message box and hold result result = MessageBox.Show("Are you sure want to delete?", "confirm", MessageBoxButton.YesNo); if (dgDesc.SelectedItem != null && result == MessageBoxResult.Yes) { int id = (dgDesc.SelectedItem as DescriptionDetail).DescId; Sqlite.ExecuteNonQuery(Query.delDesc(id)); dgDesc.ItemsSource = dataTracker.makeDescriptionList(); dgDesc.Items.Refresh(); } } catch (Exception ex) { //handle error method HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }
/// <summary> /// on click "save" button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, RoutedEventArgs e) { GroupList = new GroupDetail(); GroupList.groupName = txtGroupName.Text; GroupList.groupStartDate = dteDate.SelectedDate.Value; if (GroupList.groupStartDate.Month < 10) { GroupList.groupSStartDate = GroupList.groupStartDate.Year.ToString() + "-0" + GroupList.groupStartDate.Month.ToString(); } else { GroupList.groupSStartDate = GroupList.groupStartDate.Year.ToString() + "-" + GroupList.groupStartDate.Month.ToString(); } if (GroupList.groupStartDate.Day < 10) { GroupList.groupSStartDate += "-0" + GroupList.groupStartDate.Day.ToString(); } else { GroupList.groupSStartDate += "-" + GroupList.groupStartDate.Day.ToString(); } GroupList.groupDesc = txtSubject.Text; GroupList.groupStartTime = scheduleHours + ":" + scheduleMins; Sqlite.ExecuteNonQuery(Query.insertGroup(GroupList)); Close(); }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (tbDesc.Text != "" && DescDate != null) { descDetail.date = DescDate.SelectedDate.Value; if (descDetail.date.Month < 10) { descDetail.sDate = descDetail.date.Year.ToString() + "-0" + descDetail.date.Month.ToString(); } else { descDetail.sDate = descDetail.date.Year.ToString() + "-" + descDetail.date.Month.ToString(); } if (descDetail.date.Day < 10) { descDetail.sDate += "-0" + descDetail.date.Day.ToString(); } else { descDetail.sDate += "-" + descDetail.date.Day.ToString(); } descDetail.description = tbDesc.Text; descDetail.name = tbName.Text; if (Int32.TryParse(tbSourceId.Text, out int sourId)) { descDetail.sourceId = sourId; } Sqlite.ExecuteNonQuery(Query.updateDesc(descDetail)); this.Hide(); } } catch (Exception ex) { //handle error method HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }
private void Button_Click_2(object sender, RoutedEventArgs e) { try { bool isNum = int.TryParse(tbGrade.Text.ToString(), out int grade); //float fGrade = grade; if (isNum == true && grade >= 0 && grade < 4) { tbGrade.Text = grade.ToString(); int aIndex = (dgstudentsScore.SelectedItem as StudentScoreDetail).gradeIndex; Sqlite.ExecuteNonQuery(Query.updateGrade(aIndex, grade)); dgstudentsScore.ItemsSource = dataTracker.getStudentScoreList(groupId, aId); dgstudentsScore.Items.Refresh(); } } catch (Exception) { throw; } }
private void btnDelGroup_Click(object sender, RoutedEventArgs e) { try { MessageBoxResult result; //prompt message box and hold result result = MessageBox.Show("Are you suer want to delete?", "confirm", MessageBoxButton.YesNo); if (dgGroupList.SelectedItem != "" && result == MessageBoxResult.Yes) { int gid = (dgGroupList.SelectedItem as GroupDetail).groupID; Sqlite.ExecuteNonQuery(Query.delGroup(gid)); dgGroupList.ItemsSource = dataTracker.makeGroupList(); dgGroupList.Items.Refresh(); } } catch (Exception) { throw; } }
public void updateStudentGrade(int index, int grade) { Sqlite.ExecuteNonQuery(Query.updateGrade(index, grade)); }