public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
        {
            View root = inflater.Inflate(Resource.Layout.leader_fragment_students, container, false);

            lvStudents = root.FindViewById <ListView>(Resource.Id.lv_leader_students);

            if (Arguments != null && Arguments.ContainsKey("UserID"))
            {
                UserID = Arguments.GetInt("UserID");
                user   = DataBaseHelper.GetStudentByUserID(UserID);
            }

            StudentsList = new List <Students>();
            //todo change to user group id
            StudentsList = DataBaseHelper.GetListOfStudentsByGroupID(2);
            //StudentsList.Add(new Students { Group = 0, Name = "Студент 1", Phone = 380666, Head=false });
            //StudentsList.Add(new Students { Group = 0, Name = "Студент 2", Phone = 380111, Head = false });

            stAdapter = new LeadStudentsAdapter(root.Context, StudentsList);

            lvStudents.Adapter = stAdapter;

            return(root);
        }
        private void ButtonAddGroup(object sender, EventArgs e)
        {
            int course      = int.Parse(FindViewById <EditText>(Resource.Id.dean_addGroup_Course).Text);
            int groupNumber = int.Parse(FindViewById <EditText>(Resource.Id.dean_addGroup_GroupNumber).Text);
            int year        = int.Parse(FindViewById <EditText>(Resource.Id.dean_addGroup_EntryYear).Text);

            if (DataBaseHelper.IsServerAlive())
            {
                if (DataBaseHelper.GetGroupIDByNumberAndYear(groupNumber, year) == -1)
                {
                    DataBaseHelper.AddNewGroup(course, groupNumber, year);
                    Toast.MakeText(this, "New group is added!", ToastLength.Long).Show();
                }
                else
                {
                    Toast.MakeText(this, "That group is exist already", ToastLength.Long).Show();
                }
            }
            else
            {
                Toast.MakeText(this, "Server isn't alive", ToastLength.Long).Show();
            }
            Finish();
        }
        public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
        {
            View root = inflater.Inflate(Resource.Layout.leader_fragment_add_entry, container, false);

            lvEntry        = root.FindViewById <ListView>(Resource.Id.lv_leader_add_entry);
            tvDate         = root.FindViewById <TextView>(Resource.Id.tv_leader_add_entry_date);
            etNumbOfLesson = root.FindViewById <EditText>(Resource.Id.et_leader_add_entry_lesson);
            etRoom         = root.FindViewById <EditText>(Resource.Id.et_leader_add_entry_room);
            spSubject      = root.FindViewById <Spinner>(Resource.Id.sp_leader_add_entry_subject);
            spProfessor    = root.FindViewById <Spinner>(Resource.Id.sp_leader_add_entry_professor);
            context        = root.Context;

            if (Arguments != null)
            {
                if (Arguments.ContainsKey("UserID"))
                {
                    UserID = Arguments.GetInt("UserID");
                    user   = DataBaseHelper.GetStudentByUserID(UserID);
                }
                if (Arguments.ContainsKey("Date"))
                {
                    date = DateTime.Parse(Arguments.GetString("Date"));
                }
            }

            //userGroupID = user.Group.ID;
            userGroupID = 2;

            tvDate.Text   = date.ToShortDateString();
            tvDate.Click += (sender, e) => {
                DatePickerDialog dialog = new DatePickerDialog(root.Context, OnDateSet, date.Year, date.Month - 1, date.Day);
                //dialog.DatePicker.MaxDate = DateTime.Today.Millisecond;
                dialog.Show();
            };

            entries = new List <Entry>();
            //todo change to user group id

            students = new List <Students>();
            students = DataBaseHelper.GetListOfStudentsByGroupID(userGroupID);
            List <String> studentNames = new List <String>();

            //students.Add(new Students { ID = 1, Name = "Студент 1", Phone = 380666, Head = false });
            //students.Add(new Students { ID = 2,  Name = "Студент 2", Phone = 380111, Head = false });
            //students.Add(new Students { ID = 2,  Name = "Студент 3", Phone = 380111, Head = false });
            foreach (Students s in students)
            {
                entries.Add(new Entry {
                    Student = s
                });
            }
            foreach (Students s in students)
            {
                studentNames.Add(s.Name);
            }

            lvEntry.ChoiceMode = Android.Widget.ChoiceMode.Multiple;
            adapter            = new ArrayAdapter <String>(root.Context, Android.Resource.Layout.SimpleListItemMultipleChoice, studentNames);
            lvEntry.Adapter    = adapter;


            //subjects = DataBaseHelper.GetListOfSubject();
            subjects = new List <Subject>();
            subjects = DataBaseHelper.GetListOfSubject();
            //subjects.Add(new Subject { nameofSubject = "Физика", ID=0 });
            //subjects.Add(new Subject { nameofSubject = "Математика", ID = 1 });
            subjectsNames = new List <String>();
            foreach (Subject s in subjects)
            {
                subjectsNames.Add(s.nameofSubject);
            }

            //professors = DataBaseHelper.GetListOfProfessors();
            professors = new List <Professor>();
            professors = DataBaseHelper.GetListOfProfessors();
            //professors.Add(new Professor { ID=0, room = 510, nameOfProfessor = "Преподаватель 1", phone = 380666 });
            //professors.Add(new Professor { ID=1, room = 310, nameOfProfessor = "Преподаватель 2", phone = 380556 });
            professorsNames = new List <String>();
            foreach (Professor p in professors)
            {
                professorsNames.Add(p.nameOfProfessor);
            }

            ArrayAdapter subjectAdapter = new ArrayAdapter <String>(root.Context, Android.Resource.Layout.SimpleSpinnerItem, subjectsNames);

            subjectAdapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem);
            spSubject.Adapter = subjectAdapter;
            ArrayAdapter professorAdapter = new ArrayAdapter <String>(root.Context, Android.Resource.Layout.SimpleSpinnerItem, professorsNames);

            professorAdapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem);
            spProfessor.Adapter = professorAdapter;


            return(root);
        }