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