Пример #1
0
        public static void addAdmin(admin_tab admin)
        {
            DataClassesDataContext context = new DataClassesDataContext();

            context.admin_tab.InsertOnSubmit(admin);
            context.SubmitChanges();
        }
Пример #2
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string name    = Name_field.Text.Trim();
            string surname = Surname_field.Text.Trim();
            string login   = Login_field.Text.Trim();
            string pass    = Pass_Field.Text.Trim();
            bool   avaible = isAvaible.IsChecked.Value;

            if (!Login.checklogin(login))
            {
                return;
            }
            if ((name.Length == 0) || (surname.Length == 0) || (login.Length == 0) || (pass.Length == 0))
            {
                MessageBox.Show("Wypełnij wszystkie pola");
                return;
            }
            if (mode == 2)
            {
                if (Degree_choose.SelectedItem == null)
                {
                    MessageBox.Show("Wybierz stopień naukowy");
                    return;
                }
                DataClassesDataContext context = new DataClassesDataContext();
                Lecturer new_lec = new Lecturer();
                int      new_id  = (context.Lecturer.OrderByDescending(x => x.ID_lecturer).FirstOrDefault()).ID_lecturer + 1;
                new_lec.ID_lecturer = (short)new_id;
                new_lec.Name        = name;
                new_lec.Surname     = surname;
                new_lec.Degree      = Degree_choose.Text;
                MenuAdminLogic.addLecturer(new_lec);
                MenuAdminLogic.addLogin(login, pass, "lecturer", isAvaible.IsChecked.Value, (short)new_id);
            }
            else if (mode == 3)
            {
                if (Sem_choose.SelectedItem == null)
                {
                    MessageBox.Show("Wybierz semestr");
                    return;
                }
                DataClassesDataContext context = new DataClassesDataContext();
                Student stu    = new Student();
                int     new_id = (context.Student.OrderByDescending(x => x.ID_Album).FirstOrDefault()).ID_Album + 1;
                stu.ID_Album = (short)new_id;
                stu.Name     = name;
                stu.Surname  = surname;

                var sem_id = ((Tuple <int, string, string>)Sem_choose.SelectedItem).Item1;
                MenuAdminLogic.addStudent(stu);
                MenuAdminLogic.addLogin(login, pass, "student", isAvaible.IsChecked.Value, (short)new_id);
                MenuAdminLogic.addStuInSem(new_id, sem_id);
            }
            else if (mode == 1)
            {
                DataClassesDataContext context = new DataClassesDataContext();
                admin_tab new_admin            = new admin_tab();
                int       new_id = (context.admin_tab.OrderByDescending(x => x.admin_id).FirstOrDefault()).admin_id + 1;
                new_admin.admin_id      = (short)new_id;
                new_admin.admin_name    = name;
                new_admin.admin_surname = surname;
                MenuAdminLogic.addAdmin(new_admin);
                MenuAdminLogic.addLogin(login, pass, "admin", isAvaible.IsChecked.Value, (short)new_id);
            }
            this.Close();
        }