public IEnumerable <ClassStudent> GetClass()
        {
            List <ClassStudent> LoginData = new List <ClassStudent>();

            string conString = ConfigurationManager.ConnectionStrings["getConnection"].ToString();

            conn = new SqlConnection(conString);
            SqlCommand cmd = new SqlCommand("spCLASS", conn);

            cmd.CommandType = CommandType.StoredProcedure;
            conn.Open();
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                ClassStudent classStudent = new ClassStudent();


                classStudent.ID_CLass   = reader["ID_CLass"].ToString();
                classStudent.NameClass  = reader["NameClass"].ToString();
                classStudent.StartDay   = reader["StartDay"].ToString();
                classStudent.LeavingDay = reader["LeavingDay"].ToString();
                classStudent.Image      = reader["IMAGE"].ToString();
                LoginData.Add(classStudent);
            }
            conn.Close();
            return(LoginData);
        }
示例#2
0
        private void Show()
        {
            table.Items.Clear();
            StudentInterface a = new ClassStudent();

            a.ShowGroups(table);
        }
示例#3
0
        private void Show()
        {
            tablePersStudent.Items.Clear();
            Operations a = new ClassStudent();

            a.ShowPers(tablePersStudent);
        }
示例#4
0
        private void ShowSpec(string speciality)
        {
            table.Items.Clear();
            StudentInterface a = new ClassStudent();

            a.ShowGroupSpec(table, speciality);
        }
        public ClassStudent GetStudentBySno(string sno, out string strMessage)
        {
            strMessage = "";
            string    strSQL = "SELECT Sno,Sname,Clno,Stel,Ptel,Ttel,Spwd FROM Student WHERE Sno =" + sno;
            DataTable dt     = Global.dbHelp.GetDataTablebySQL(strSQL, out strMessage);

            if (dt == null)
            {
                return(null);
            }
            if (dt.Rows.Count < 1)
            {
                strMessage = "没有该用户!";
                return(null);
            }
            //构建一个用户
            string       sno1    = dt.Rows[0].ItemArray[0].ToString();
            string       sname   = dt.Rows[0].ItemArray[1].ToString();
            string       clno    = dt.Rows[0].ItemArray[2].ToString();
            string       stel    = dt.Rows[0].ItemArray[3].ToString();
            string       ptel    = dt.Rows[0].ItemArray[4].ToString();
            string       ttel    = dt.Rows[0].ItemArray[5].ToString();
            string       spwd    = dt.Rows[0].ItemArray[6].ToString();
            ClassStudent student = new ClassStudent(sno1, sname, clno, stel, ptel, ttel, spwd);

            return(student);
        }
示例#6
0
        public AddStudent()
        {
            InitializeComponent();
            StudentInterface a = new ClassStudent();

            group.ItemsSource = a.GetGroup();
        }
示例#7
0
 private void Button_Click_2(object sender, RoutedEventArgs e)
 {
     if (number.Text == "")
     {
         a1.Visibility = Visibility.Visible;
         p.Visibility  = Visibility.Visible;
         if (spec1.Text == "")
         {
             a2.Visibility = Visibility.Visible;
         }
     }
     else
     {
         if (spec1.Text == "")
         {
             a2.Visibility = Visibility.Visible;
             p.Visibility  = Visibility.Visible;
         }
         else
         {
             StudentInterface a = new ClassStudent();
             a.InsertGroup(number.Text, spec1.Text);
             table.Items.Clear();
             Show();
             number.Clear();
             spec1.SelectedIndex = -1;
         }
     }
 }
示例#8
0
 public void RemoveStudentClass(ClassStudent classStudent)
 {
     using (var context = new StudentManagementDBContext())
     {
         var entity = context.ClassStudentEntities.SingleOrDefault(m => m.ClassID == classStudent.ClassID && m.StudentID == classStudent.StudentID);
         context.ClassStudentEntities.Remove(entity);
         context.SaveChanges();
     }
 }
示例#9
0
        public ActionResult StudentInsert(FormCollection f)
        {
            ClassStudent s = new ClassStudent();

            s.Name        = f["Name"];
            s.DateOfBirth = f["DateOfBirth"];
            s.Gender      = f["Gender"];
            dblayer.InsertStudent(s);
            return(RedirectToAction("StudentDisplay"));
        }
示例#10
0
 public void AddStudentClass(ClassStudent classStudent)
 {
     using (var context = new StudentManagementDBContext())
     {
         var entity = Mapper.Map <ClassStudent, ClassStudentEntity>(classStudent);
         entity.ID = Guid.NewGuid();
         context.ClassStudentEntities.Add(entity);
         context.SaveChanges();
     }
 }
示例#11
0
        public ActionResult StudentUpdate(int id, FormCollection f)
        {
            ClassStudent s = new ClassStudent();

            s.StudentID   = id;
            s.Name        = f["Name"];
            s.DateOfBirth = f["DateOfBirth"];
            s.Gender      = f["Gender"];
            dblayer.UpdateStudent(s);
            return(RedirectToAction("StudentDisplay"));
        }
示例#12
0
        public AddRating()
        {
            InitializeComponent();
            StudentInterface a = new ClassStudent();

            group.ItemsSource      = a.GetGroup();
            mark.ItemsSource       = mas;
            student.ItemsSource    = mas1;
            Discipline.ItemsSource = mas2;
            string[] mas3 = { "1", "2", "3", "4", "5", "6", "7", "8" };
            semester.ItemsSource = mas3;
        }
示例#13
0
        public ActionResult DeleteConfirmed([Bind(Include = "ClassID,StudentID")] ClassStudent student)

        {
            student.ClassID = Convert.ToInt32(Request["ClassID"]);
            if (ModelState.IsValid)
            {
                db.ClassStudents.Remove(student);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            return(RedirectToAction("Current", "Students"));
        }
示例#14
0
 public ActionResult Edit([Bind(Include = "ClassID,StudentID")] ClassStudent classStudent)
 {
     if (ModelState.IsValid)
     {
         db.Entry(classStudent).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ClassID   = new SelectList(db.Classes, "ID", "Name", classStudent.ClassID);
     ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", classStudent.StudentID);
     return(View(classStudent));
 }
示例#15
0
        public List()
        {
            InitializeComponent();
            Show();
            StudentInterface a = new ClassStudent();

            group.ItemsSource = a.GetGroup();
            TeacherInterface t = new ClassTeacher();

            teacher.ItemsSource = t.GetTeacher();
            string[] mas1 = { "1", "2", "3", "4", "5", "6", "7", "8" };
            semester.ItemsSource = mas1;
        }
示例#16
0
        public AcademicRecord()
        {
            InitializeComponent();
            Show();
            StudentInterface g = new ClassStudent();

            group.ItemsSource = g.GetGroup();
            string[] mas1 = { "1", "2", "3", "4", "5", "6", "7", "8" };
            semester.ItemsSource = mas1;
            string[] mas2 = { "Зачет", "Экзамен", "Дифференцированный зачет" };
            type.ItemsSource = mas2;
            disc.ItemsSource = mas3;
        }
示例#17
0
        public ActionResult Create([Bind(Include = "ClassID,StudentID")] ClassStudent classStudent)
        {
            if (ModelState.IsValid)
            {
                db.ClassStudents.Add(classStudent);
                db.SaveChanges();
                return(RedirectToAction("Current", "Students"));
            }

            ViewBag.ClassID   = new SelectList(db.Classes, "ID", "Name", classStudent.ClassID);
            ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", classStudent.StudentID);
            return(View(classStudent));
        }
示例#18
0
        // GET: ClassStudents/Delete/5
        public ActionResult Delete(int?studentID)
        {
            if (studentID == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ClassStudent student = db.ClassStudents.Where(cs => cs.StudentID == studentID).FirstOrDefault();

            if (student == null)
            {
                return(View("NoJunction"));
            }
            return(View(student));
        }
示例#19
0
        // GET: ClassStudents/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ClassStudent classStudent = db.ClassStudents.Find(id);

            if (classStudent == null)
            {
                return(HttpNotFound());
            }
            return(View(classStudent));
        }
示例#20
0
 private void Button_Click(object sender, RoutedEventArgs e)
 {
     if (group.Text == "")
     {
         a1.Visibility = Visibility.Visible;
         p.Visibility  = Visibility.Visible;
     }
     else
     {
         tablePersStudent.Items.Clear();
         StudentInterface a = new ClassStudent();
         a.ShowPersGroup(tablePersStudent, group.Text);
         group.SelectedIndex = -1;
     }
 }
示例#21
0
        public AddList()
        {
            InitializeComponent();
            StudentInterface g = new ClassStudent();

            group.ItemsSource = g.GetGroup();
            TeacherInterface t = new ClassTeacher();

            teacher.ItemsSource = t.GetTeacher();
            string[] mas1 = { "1", "2", "3", "4", "5", "6", "7", "8" };
            semester.ItemsSource = mas1;
            string[] mas2 = { "Зачет", "Экзамен", "Дифференцированный зачет" };
            type.ItemsSource = mas2;
            disc.ItemsSource = mas3;
        }
示例#22
0
        // GET: ClassStudents/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ClassStudent classStudent = db.ClassStudents.Find(id);

            if (classStudent == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ClassID   = new SelectList(db.Classes, "ID", "Name", classStudent.ClassID);
            ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", classStudent.StudentID);
            return(View(classStudent));
        }
示例#23
0
 public void InsertStudent(ClassStudent s)
 {
     try
     {
         SqlCommand com = new SqlCommand("Sp_InsertStudent", con);
         com.CommandType = CommandType.StoredProcedure;
         com.Parameters.AddWithValue("@prm_snam", s.Name);
         com.Parameters.AddWithValue("@prm_sdob", s.DateOfBirth);
         com.Parameters.AddWithValue("@prm_sgen", s.Gender);
         con.Open();
         com.ExecuteNonQuery();
         con.Close();
     }
     catch (Exception e)
     { Console.WriteLine("Catch error: " + e); }
 }
        ///<summary>
        ///登录
        ///</summary>
        ///<param name = "sno"></param>
        ///<param name = "spwd"></param>
        ///<param name = "strMessage"></param>
        ///<returns>登录成功后,返回一个用户对象,否则NULL</returns>
        public ClassStudent Login(string sno, string spwd, out string strMessage)
        {
            strMessage = "";
            //构建一个学生对象
            ClassStudent student = GetStudentBySno(sno, out strMessage);

            if (student == null)
            {
                return(null);
            }
            if (student.Spwd != spwd)
            {
                strMessage = "用户密码错误!";
                return(null);
            }
            return(student);
        }
示例#25
0
 // string LeavingDay = Preferences.Get("my_key5", "default_value");
 public AddClassViewModel(INavigation _navigation, ClassStudent classStudent)
 {
     Navigation = _navigation;
     _class     = classStudent;
     if (_class != null)
     {
         NameClass          = _class.NameClass;
         ID_Teacher         = _class.ID_Teacher;
         StartDay           = _class.StartDay;
         LeavingDay         = _class.LeavingDay;
         ClassTittle        = "Sửa thông tin lớp";
         IsVisibleDeleteBtn = true;
     }
     else
     {
         ClassTittle = "Thêm thông tin lớp";
     }
 }
示例#26
0
        private void group_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            student.SelectedItem = null;
            StudentInterface s = new ClassStudent();
            ListInterface    d = new ClassList();

            student.ItemsSource = s.GetStudents(group.SelectedItem.ToString());
            if (type.Text != "" && semester.Text != "")
            {
                Discipline.SelectedItem = null;
                Discipline.ItemsSource  = d.GetDisciplineGroup(group.SelectedItem.ToString(), type.Text, semester.Text);
            }
            a3.Visibility = Visibility.Hidden;
            if (type.Text != "" && semester.Text != "" && Discipline.Text != "" && student.Text != "" && mark.Text != "")
            {
                p.Visibility = Visibility.Hidden;
            }
        }
    private void AddClasses()
    {
        // Create a class year
        SchoolYear year = new SchoolYear();

        year.Name  = "2015-2016";
        year.Start = DateTime.Parse("8-15-2015");
        year.End   = DateTime.Parse("5-15-2016");
        db.SchoolYears.InsertOnSubmit(year);
        db.SubmitChanges();

        // Create a class for each teacher
        // Get the teachers and students with their IDs
        var teachers = db.Users.Where(x => x.UserType == UserType.Teacher);

        User[] students    = db.Users.Where(x => x.UserType == UserType.Student).ToArray();
        int    nextStudent = 0;

        foreach (User teacher in teachers)
        {
            Class clss = new Class();
            clss.Year      = 1; // we know there is only one year ID
            clss.ClassName = string.Format("{0} {1} First Grade", teacher.FirstName, teacher.LastName);
            clss.TeacherID = teacher.UserID;
            db.Classes.InsertOnSubmit(clss);
            db.SubmitChanges();
            // Get the class ID
            clss = db.Classes.Where(x => x.TeacherID == teacher.UserID).First();
            // Assign students to the class
            for (int idx = 0; idx < students.Length / teachers.Count(); nextStudent++, idx++)
            {
                User         student = students[nextStudent];
                ClassStudent tie     = new ClassStudent();
                tie.UserID  = student.UserID;
                tie.ClassID = clss.ClassID;
                db.ClassStudents.InsertOnSubmit(tie);
            }
        }
    }
        /// <summary>
        /// 注册一个学生信息
        /// </summary>
        /// <param name="student">一个需要注册的学生对象</param>
        /// <param name="strMessage">返回执行信息</param>
        /// <returns>注册成功返回真</returns>
        public bool Register(ClassStudent student, out string strMessage)
        {
            strMessage = "";
            //写入数据库的的SQL语句
            string[] StrSQL = new string[1];  //SQL语句数组

            StrSQL[0]  = "INSERT INTO Student(Sno,Sname,Clno,Stel,Ptel,Ttel,Spwd) VALUES('";
            StrSQL[0] += student.Sno + "','";
            StrSQL[0] += student.Sname + "','";
            StrSQL[0] += student.Clno + "','";
            StrSQL[0] += student.Stel + "','";
            StrSQL[0] += student.Ptel + "','";
            StrSQL[0] += student.Ttel + "','";
            StrSQL[0] += student.Spwd + "')";
            if (Global.dbHelp.ExcuteSQLbyTrans(StrSQL, out strMessage))
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
示例#29
0
        /// <summary>
        /// 
        /// </summary>
        public override void Sync()
        {
            if (this.Source == null) return;
            List<Unit> listUnits = this.unitsEntity.LoadAllowSyncData();
            if (listUnits == null || listUnits.Count == 0)
            {
                this.Log.ContentLog("没有允许同步学生的学校!");
                return;
            }
            for (int i = 0; i < listUnits.Count; i++)
            {
                try
                {
                    List<Entity.Class> listClasses = this.classesEntity.LoadAllowSyncData(listUnits[i].UnitID);
                    if (listClasses == null || listClasses.Count == 0)
                    {
                        this.Log.ContentLog(string.Format("学校[{0},{1}]下没有允许同步学生的班级!", i + 1, listUnits[i]));
                        continue;
                    }
                    for (int j = 0; j < listClasses.Count; j++)
                    {
                        try
                        {

                            int count = this.classStusEntity.DeleteClassStudents(listClasses[j].ClassID);
                            this.Log.ContentLog(string.Format("删除班级[{0}]下关联的学生[{1}]人!", listClasses[j], count));

                            SyncStudents sources = this.Source.SyncAllStudents(listUnits[i].UnitName, string.Format("{0}", listClasses[j].JoinYear), listClasses[j].ClassName);
                            if (sources == null || sources.Count == 0)
                            {
                                this.Log.ContentLog(string.Format("第[{0},{1}]条学校[{2}]下班级[{3}]下没有学生同步!", i + 1, j + 1, listUnits[i], listClasses[j]));
                                continue;
                            }
                            Entity.Student data = null;
                            for (int k = 0; k < sources.Count; k++)
                            {
                                try
                                {
                                    data = new Entity.Student();
                                    data.StudentID = this.stusEntity.LoadStudentIDByCode(sources[k].Code);
                                    if (data.StudentID.IsValid && this.stusEntity.LoadRecord(ref data))
                                    {
                                        if (data.SyncStatus == 0x00)
                                        {
                                            continue;
                                        }
                                    }
                                    data.StudentCode = sources[k].Code;
                                    data.StudentName = sources[k].Name;
                                    data.IDNumber = sources[k].IDCard;
                                    data.JoinYear = int.Parse(sources[k].JoinYear);
                                    data.Gender = this.TransGender(sources[k].Gender);
                                    data.LastSyncTime = DateTime.Now;
                                    data.SyncStatus = 0x02;

                                    bool isInsert = false;
                                    if (!data.StudentID.IsValid)
                                    {
                                        data.StudentID = GUIDEx.New;
                                        isInsert = true;
                                    }
                                    string log = string.Format("同步第[{0},{1},{2}]条数据[{3}]", i + 1, j + 1, k + 1, data);
                                    if (this.stusEntity.UpdateRecord(data))
                                    {
                                        this.Log.ContentLog(log + "[成功]");
                                        if (isInsert)//新生插入权限。
                                        {
                                            this.SetStudentAccessRole(data, this.roleId);
                                        }
                                        //建立班级学生关系。
                                        ClassStudent cs = new ClassStudent();
                                        cs.ClassID = listClasses[j].ClassID;
                                        cs.StudentID = data.StudentID;
                                        cs.LastSyncTime = DateTime.Now;

                                        log = string.Format("[{0},{1},{2}]建立学校[{3}]班级({4})学生({5})关联关系[{6}]", i + 1, j + 1, k + 1, listUnits[i], listClasses[j], sources[k], cs);
                                        if (this.classStusEntity.UpdateRecord(cs))
                                        {
                                            this.Log.ContentLog(log + "[成功]");
                                        }
                                        else
                                        {
                                            this.Log.ContentLog(log + "[失败]");
                                        }
                                    }
                                    else
                                    {
                                        this.Log.ContentLog(log + "[失败]");
                                    }
                                }
                                catch (Exception x)
                                {
                                    string err = string.Format("同步[{0},{1},{2}]学生数据[{2}]异常:{3}", i + 1, j + 1, k + 1, data, x.Message);
                                    this.Log.ContentLog(err);
                                    this.Log.ErrorLog(new Exception(err, x));
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            string err = string.Format("同步第[{0},{1}]条学校[{2}]下班级[{3}]下学生数据时发生异常:{4}",
                                i + 1, j + 1, listUnits[i], listClasses[j], ex.Message);
                            this.Log.ContentLog(err);
                            this.Log.ErrorLog(new Exception(err, ex));
                        }
                    }
                }
                catch (Exception e)
                {
                    string err = string.Format("同步学校[{0},{1}]下的学生发生异常:{2}", i + 1, listUnits[i], e.Message);
                    this.Log.ContentLog(err);
                    this.Log.ErrorLog(new Exception(err, e));
                }
            }
        }
示例#30
0
 private void add_Click(object sender, RoutedEventArgs e)
 {
     if (surname.Text == "")
     {
         a1.Visibility = Visibility.Visible;
         p.Visibility  = Visibility.Visible;
         if (name.Text == "")
         {
             a2.Visibility = Visibility.Visible;
         }
         if (middle_name.Text == "")
         {
             a3.Visibility = Visibility.Visible;
         }
         if (series.Text == "")
         {
             a4.Visibility = Visibility.Visible;
         }
         if (number.Text == "")
         {
             a5.Visibility = Visibility.Visible;
         }
         if (group.Text == "")
         {
             a6.Visibility = Visibility.Visible;
         }
         if (phone.Text == "")
         {
             a8.Visibility = Visibility.Visible;
         }
         if (year.Text == "")
         {
             a9.Visibility = Visibility.Visible;
         }
         if (city.Text == "")
         {
             a10.Visibility = Visibility.Visible;
         }
         if (street.Text == "")
         {
             a11.Visibility = Visibility.Visible;
         }
         if (home.Text == "")
         {
             a12.Visibility = Visibility.Visible;
         }
         if (male.IsChecked == false && female.IsChecked == false)
         {
             a14.Visibility = Visibility.Visible;
         }
     }
     else
     {
         if (name.Text == "")
         {
             a2.Visibility = Visibility.Visible;
             p.Visibility  = Visibility.Visible;
             if (middle_name.Text == "")
             {
                 a3.Visibility = Visibility.Visible;
             }
             if (series.Text == "")
             {
                 a4.Visibility = Visibility.Visible;
             }
             if (number.Text == "")
             {
                 a5.Visibility = Visibility.Visible;
             }
             if (group.Text == "")
             {
                 a6.Visibility = Visibility.Visible;
             }
             if (phone.Text == "")
             {
                 a8.Visibility = Visibility.Visible;
             }
             if (year.Text == "")
             {
                 a9.Visibility = Visibility.Visible;
             }
             if (city.Text == "")
             {
                 a10.Visibility = Visibility.Visible;
             }
             if (street.Text == "")
             {
                 a11.Visibility = Visibility.Visible;
             }
             if (home.Text == "")
             {
                 a12.Visibility = Visibility.Visible;
             }
             if (male.IsChecked == false && female.IsChecked == false)
             {
                 a14.Visibility = Visibility.Visible;
             }
         }
         else
         {
             if (middle_name.Text == "")
             {
                 a3.Visibility = Visibility.Visible;
                 p.Visibility  = Visibility.Visible;
                 if (series.Text == "")
                 {
                     a4.Visibility = Visibility.Visible;
                 }
                 if (number.Text == "")
                 {
                     a5.Visibility = Visibility.Visible;
                 }
                 if (group.Text == "")
                 {
                     a6.Visibility = Visibility.Visible;
                 }
                 if (phone.Text == "")
                 {
                     a8.Visibility = Visibility.Visible;
                 }
                 if (year.Text == "")
                 {
                     a9.Visibility = Visibility.Visible;
                 }
                 if (city.Text == "")
                 {
                     a10.Visibility = Visibility.Visible;
                 }
                 if (street.Text == "")
                 {
                     a11.Visibility = Visibility.Visible;
                 }
                 if (home.Text == "")
                 {
                     a12.Visibility = Visibility.Visible;
                 }
                 if (male.IsChecked == false && female.IsChecked == false)
                 {
                     a14.Visibility = Visibility.Visible;
                 }
             }
             else
             {
                 if (series.Text == "")
                 {
                     a4.Visibility = Visibility.Visible;
                     p.Visibility  = Visibility.Visible;
                     if (number.Text == "")
                     {
                         a5.Visibility = Visibility.Visible;
                     }
                     if (group.Text == "")
                     {
                         a6.Visibility = Visibility.Visible;
                     }
                     if (phone.Text == "")
                     {
                         a8.Visibility = Visibility.Visible;
                     }
                     if (year.Text == "")
                     {
                         a9.Visibility = Visibility.Visible;
                     }
                     if (city.Text == "")
                     {
                         a10.Visibility = Visibility.Visible;
                     }
                     if (street.Text == "")
                     {
                         a11.Visibility = Visibility.Visible;
                     }
                     if (home.Text == "")
                     {
                         a12.Visibility = Visibility.Visible;
                     }
                     if (male.IsChecked == false && female.IsChecked == false)
                     {
                         a14.Visibility = Visibility.Visible;
                     }
                 }
                 else
                 {
                     if (number.Text == "")
                     {
                         a5.Visibility = Visibility.Visible;
                         p.Visibility  = Visibility.Visible;
                         if (group.Text == "")
                         {
                             a6.Visibility = Visibility.Visible;
                         }
                         if (phone.Text == "")
                         {
                             a8.Visibility = Visibility.Visible;
                         }
                         if (year.Text == "")
                         {
                             a9.Visibility = Visibility.Visible;
                         }
                         if (city.Text == "")
                         {
                             a10.Visibility = Visibility.Visible;
                         }
                         if (street.Text == "")
                         {
                             a11.Visibility = Visibility.Visible;
                         }
                         if (home.Text == "")
                         {
                             a12.Visibility = Visibility.Visible;
                         }
                         if (male.IsChecked == false && female.IsChecked == false)
                         {
                             a14.Visibility = Visibility.Visible;
                         }
                     }
                     else
                     {
                         if (group.Text == "")
                         {
                             a6.Visibility = Visibility.Visible;
                             p.Visibility  = Visibility.Visible;
                             if (phone.Text == "")
                             {
                                 a8.Visibility = Visibility.Visible;
                             }
                             if (year.Text == "")
                             {
                                 a9.Visibility = Visibility.Visible;
                             }
                             if (city.Text == "")
                             {
                                 a10.Visibility = Visibility.Visible;
                             }
                             if (street.Text == "")
                             {
                                 a11.Visibility = Visibility.Visible;
                             }
                             if (home.Text == "")
                             {
                                 a12.Visibility = Visibility.Visible;
                             }
                             if (male.IsChecked == false && female.IsChecked == false)
                             {
                                 a14.Visibility = Visibility.Visible;
                             }
                         }
                         else
                         {
                             if (phone.Text == "")
                             {
                                 a8.Visibility = Visibility.Visible;
                                 p.Visibility  = Visibility.Visible;
                                 if (year.Text == "")
                                 {
                                     a9.Visibility = Visibility.Visible;
                                 }
                                 if (city.Text == "")
                                 {
                                     a10.Visibility = Visibility.Visible;
                                 }
                                 if (street.Text == "")
                                 {
                                     a11.Visibility = Visibility.Visible;
                                 }
                                 if (home.Text == "")
                                 {
                                     a12.Visibility = Visibility.Visible;
                                 }
                                 if (male.IsChecked == false && female.IsChecked == false)
                                 {
                                     a14.Visibility = Visibility.Visible;
                                 }
                             }
                             else
                             {
                                 if (year.Text == "")
                                 {
                                     a9.Visibility = Visibility.Visible;
                                     p.Visibility  = Visibility.Visible;
                                     if (city.Text == "")
                                     {
                                         a10.Visibility = Visibility.Visible;
                                     }
                                     if (street.Text == "")
                                     {
                                         a11.Visibility = Visibility.Visible;
                                     }
                                     if (home.Text == "")
                                     {
                                         a12.Visibility = Visibility.Visible;
                                     }
                                     if (male.IsChecked == false && female.IsChecked == false)
                                     {
                                         a14.Visibility = Visibility.Visible;
                                     }
                                 }
                                 else
                                 {
                                     if (city.Text == "")
                                     {
                                         a10.Visibility = Visibility.Visible;
                                         p.Visibility   = Visibility.Visible;
                                         if (street.Text == "")
                                         {
                                             a11.Visibility = Visibility.Visible;
                                         }
                                         if (home.Text == "")
                                         {
                                             a12.Visibility = Visibility.Visible;
                                         }
                                         if (male.IsChecked == false && female.IsChecked == false)
                                         {
                                             a14.Visibility = Visibility.Visible;
                                         }
                                     }
                                     else
                                     {
                                         if (street.Text == "")
                                         {
                                             a11.Visibility = Visibility.Visible;
                                             p.Visibility   = Visibility.Visible;
                                             if (home.Text == "")
                                             {
                                                 a12.Visibility = Visibility.Visible;
                                             }
                                             if (male.IsChecked == false && female.IsChecked == false)
                                             {
                                                 a14.Visibility = Visibility.Visible;
                                             }
                                         }
                                         else
                                         {
                                             if (home.Text == "")
                                             {
                                                 a12.Visibility = Visibility.Visible;
                                                 p.Visibility   = Visibility.Visible;
                                                 if (male.IsChecked == false && female.IsChecked == false)
                                                 {
                                                     a14.Visibility = Visibility.Visible;
                                                 }
                                             }
                                             else
                                             {
                                                 if (male.IsChecked == false && female.IsChecked == false)
                                                 {
                                                     a14.Visibility = Visibility.Visible;
                                                     p.Visibility   = Visibility.Visible;
                                                 }
                                                 else
                                                 {
                                                     string sex = "";
                                                     if (male.IsChecked == true)
                                                     {
                                                         sex = male.Content.ToString();
                                                     }
                                                     else
                                                     {
                                                         sex = female.Content.ToString();
                                                     }
                                                     StudentInterface a = new ClassStudent();
                                                     a.Insert(series, number, sex, city, street, home, flat, phone, surname, name, middle_name, group, year);
                                                     Cleanning();
                                                 }
                                             }
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
 }
 public static ClassStudentDTO GetClassStudentDTOFromClassStudent(ClassStudent s)
 {
     return(Copy <ClassStudentDTO, ClassStudent>(s));
 }