Пример #1
0
 public void SaveData(Student_GroupEntity student)
 {
     using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
     {
         try
         {
             con.Execute("INSERT INTO Student_Main_Group (StudentId, AcademicYrSem, Programme, GroupNumber, GroupId) values (@StudentId, @AcademicYrSem, @Programme, @GroupNumber, @GroupId)", student);
         }
         catch (Exception e)
         {
             MessageBox.Show(e.Message);
         }
     }
 }
Пример #2
0
 public void UpdateData(Student_GroupEntity student)
 {
     using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
     {
         try
         {
             con.Execute("UPDATE Student_Main_Group SET AcademicYrSem=@AcademicYrSem, Programme=@Programme, GroupNumber=@GroupNumber, GroupId=@GroupId WHERE StudentId=@StudentId", student);
         }
         catch (Exception e)
         {
             MessageBox.Show(e.Message);
         }
     }
 }
 private void update_btn__Click(object sender, RoutedEventArgs e)
 {
     try
     {
         student = CreateStudentEntity();
         _studentViewModel.UpdateStudentData(student);
         student_group_data_grid.ItemsSource = _studentViewModel.LoadStudentData();
         ClearAll();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
        private void student_group_data_grid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            updateMode            = true;
            delete_btn_.IsEnabled = true;
            DataGrid dataGrid = (DataGrid)sender;

            student = dataGrid.SelectedItem as Student_GroupEntity;

            if (student != null)
            {
                academicYrSem_combobx.Text = student.AcademicYrSem;
                programme_combobx.Text     = student.Programme;
                groupNumber_combobx.Text   = student.GroupNumber.ToString();
                groupId_txtbx.Text         = student.GroupId;
            }
        }
Пример #5
0
        private void grp_combobx_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            ComboBox grpComboBx = sender as ComboBox;

            if (grpComboBx.SelectedItem != null)
            {
                if (tagName == "Lab")
                {
                    Student_SubGroupEntity selectedGrp = grpComboBx.SelectedItem as Student_SubGroupEntity;
                    grp_combobx_val = selectedGrp.SubGroupId;
                }
                else
                {
                    Student_GroupEntity selectedGrp = grpComboBx.SelectedItem as Student_GroupEntity;
                    grp_combobx_val = selectedGrp.GroupId;
                }
                CheckValidations();
            }
        }
        private Student_GroupEntity CreateStudentEntity()
        {
            int StudentId;

            if (updateMode)
            {
                StudentId = student.StudentId;
            }
            else
            {
                StudentId = students.Last().StudentId + 1;
            }
            string AcademicYrSem = academicYrSem_combobx.Text;
            string Programme     = programme_combobx.Text;
            int    GroupNumber   = int.Parse(groupNumber_combobx.Text);
            string GroupId       = groupId_txtbx.Text;


            student = new Student_GroupEntity(StudentId, AcademicYrSem, Programme, GroupNumber, GroupId);
            return(student);
        }
 public void UpdateStudentData(Student_GroupEntity student)
 {
     _studentData.UpdateData(student);
 }
 public void SaveStudentData(Student_GroupEntity student)
 {
     _studentData.SaveData(student);
 }