示例#1
0
        void cbStudyLevelGroup_SelectedIndexChanged(object sender, EventArgs e)
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context);

                if (StudyLevelGroupId.HasValue)
                {
                    ent = ent.Where(x => x.StudyLevelGroupId == StudyLevelGroupId.Value);
                }

                ent = ent.Where(c => c.IsSecond == IsSecond && c.IsReduced == IsReduced && c.IsParallel == IsParallel);

                if (StudyBasisId != null)
                {
                    ent = ent.Where(c => c.StudyBasisId == StudyBasisId);
                }
                if (StudyFormId != null)
                {
                    ent = ent.Where(c => c.StudyFormId == StudyFormId);
                }

                List <KeyValuePair <string, string> > lst = ent.ToList()
                                                            .Select(u => new KeyValuePair <string, string>(u.FacultyId.ToString(), u.FacultyName)).Distinct().ToList();

                ComboServ.FillCombo(cbFaculty, lst, false, false);
            }
        }
示例#2
0
        private void FillProfile()
        {
            using (PriemEntities context = new PriemEntities())
            {
                List <KeyValuePair <string, string> > lst = ((from ent in MainClass.GetEntry(context)
                                                              where ent.FacultyId == FacultyId &&
                                                              ent.StudyLevelId == StudyLevelId &&
                                                              (LicenseProgramId.HasValue ? ent.LicenseProgramId == LicenseProgramId : true) &&
                                                              (ObrazProgramId.HasValue ? ent.ObrazProgramId == ObrazProgramId : true) &&
                                                              ent.ProfileId != null
                                                              select new
                {
                    Id = ent.ProfileId,
                    Name = ent.ProfileName
                }).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(), u.Name)).ToList();

                if (lst.Count() > 0)
                {
                    ComboServ.FillCombo(cbProfile, lst, false, true);
                    cbProfile.Enabled = true;
                }
                else
                {
                    ComboServ.FillCombo(cbProfile, new List <KeyValuePair <string, string> >(), true, false);
                    cbProfile.Enabled = false;
                }
            }
        }
示例#3
0
        private void FillLicenseProgram()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context)
                          .Where(c => c.FacultyId == FacultyId);

                if (StudyLevelGroupId.HasValue)
                {
                    ent = ent.Where(x => x.StudyLevelGroupId == StudyLevelGroupId.Value);
                }

                ent = ent.Where(c => c.IsSecond == IsSecond && c.IsReduced == IsReduced && c.IsParallel == IsParallel);

                if (StudyBasisId != null)
                {
                    ent = ent.Where(c => c.StudyBasisId == StudyBasisId);
                }
                if (StudyFormId != null)
                {
                    ent = ent.Where(c => c.StudyFormId == StudyFormId);
                }

                List <KeyValuePair <string, string> > lst = ent.ToList()
                                                            .Select(u => new KeyValuePair <string, string>(u.LicenseProgramId.ToString(), u.LicenseProgramName)).Distinct().ToList();

                ComboServ.FillCombo(cbLicenseProgram, lst, false, true);
            }
        }
        private IEnumerable <Entry> GetEntry(PriemEntities context)
        {
            IEnumerable <Entry> entry = MainClass.GetEntry(context);

            entry = entry.Where(c => c.IsSecond == IsSecond);

            return(entry);
        }
示例#5
0
        //void cbFaculty_SelectedIndexChanged(object sender, EventArgs e)
        //{
        //    FillStudyForm();
        //}

        //void cbStudyBasis_SelectedIndexChanged(object sender, EventArgs e)
        //{
        //    FillStudyForm();
        //}
        //void cbStudyForm_SelectedIndexChanged(object sender, EventArgs e)
        //{
        //    FillLicenseProgram();
        //}
        //void cbLicenseProgram_SelectedIndexChanged(object sender, EventArgs e)
        //{
        //    UpdateDataGrid();
        //}

        //public int? FacultyId
        //{
        //    get { return ComboServ.GetComboIdInt(cbFaculty); }
        //    set { ComboServ.SetComboId(cbFaculty, value); }
        //}
        //public int? LicenseProgramId
        //{
        //    get { return ComboServ.GetComboIdInt(cbLicenseProgram); }
        //    set { ComboServ.SetComboId(cbLicenseProgram, value); }
        //}
        //public int? StudyBasisId
        //{
        //    get { return ComboServ.GetComboIdInt(cbStudyBasis); }
        //    set { ComboServ.SetComboId(cbStudyBasis, value); }
        //}
        //public int? StudyFormId
        //{
        //    get { return ComboServ.GetComboIdInt(cbStudyForm); }
        //    set { ComboServ.SetComboId(cbStudyForm, value); }
        //}
        //public int StudyLevelGroupId
        //{
        //    get { return ComboServ.GetComboIdInt(cbStudyLevelGroup).Value; }
        //    set { ComboServ.SetComboId(cbStudyLevelGroup, value); }
        //}

        //public bool IsSecond
        //{
        //    get { return chbIsSecond.Checked; }
        //    set { chbIsSecond.Checked = value; }
        //}
        //public bool IsReduced
        //{
        //    get { return chbIsReduced.Checked; }
        //    set { chbIsReduced.Checked = value; }
        //}
        //public bool IsParallel
        //{
        //    get { return chbIsParallel.Checked; }
        //    set { chbIsParallel.Checked = value; }
        //}
        //public bool IsListener
        //{
        //    get { return chbIsListener.Checked; }
        //    set { chbIsListener.Checked = value; }
        //}

        private void FillFaculty()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context).Where(c => c.StudyLevelGroupId == StudyLevelGroupId);
                List <KeyValuePair <string, string> > lst = ent.Select(x => new { x.FacultyName, x.FacultyId }).Distinct().ToList()
                                                            .Select(u => new KeyValuePair <string, string>(u.FacultyId.ToString(), u.FacultyName)).OrderBy(x => x.Value).Distinct().ToList();

                ComboServ.FillCombo(cbFaculty, lst, false, false);
            }
        }
示例#6
0
        private void FillStudyLevelGroup()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context).Select(x => new { x.StudyLevelGroupId, x.StudyLevelGroupName }).ToList();

                List <KeyValuePair <string, string> > lst = ent.Select(u => new KeyValuePair <string, string>(u.StudyLevelGroupId.ToString(), u.StudyLevelGroupName)).Distinct().ToList();

                ComboServ.FillCombo(cbStudyLevelGroup, lst, false, false);
            }
        }
示例#7
0
        private void FillStudyForm()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context).Where(c => c.FacultyId == FacultyId);

                List <KeyValuePair <string, string> > lst = ent.ToList().Select(u => new KeyValuePair <string, string>(u.StudyFormId.ToString(), u.StudyForm.Name)).Distinct().ToList();

                ComboServ.FillCombo(cbStudyForm, lst, false, true);
                cbStudyForm.SelectedIndex = 0;
            }
        }
示例#8
0
        private void FillStudyForm()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context).Where(c => c.FacultyId == FacultyId).Where(c => c.StudyBasisId == StudyBasisId);

                ent = ent.Where(c => c.IsSecond == IsSecond && c.IsReduced == IsReduced && c.IsParallel == IsParallel);

                List <KeyValuePair <string, string> > lst = ent.ToList().Select(u => new KeyValuePair <string, string>(u.StudyFormId.ToString(), u.StudyFormName)).Distinct().ToList();

                ComboServ.FillCombo(cbStudyForm, lst, false, false);
            }
        }
示例#9
0
        private void FillComboStudyForm()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var lst = ((from ent in MainClass.GetEntry(context)
                            where ent.FacultyId == FacultyId
                            select new
                {
                    ent.StudyFormId,
                    ent.StudyFormName
                }).Distinct()).ToList().Select(x => new KeyValuePair <string, string>(x.StudyFormId.ToString(), x.StudyFormName)).ToList();

                ComboServ.FillCombo(cbStudyForm, lst, false, false);
            }
        }
示例#10
0
        private void FillObrazProgram()
        {
            using (PriemEntities context = new PriemEntities())
            {
                List <KeyValuePair <string, string> > lst = ((from ent in MainClass.GetEntry(context)
                                                              where ent.FacultyId == FacultyId && ent.LicenseProgramId == LicenseProgramId
                                                              select new
                {
                    Id = ent.ObrazProgramId,
                    Name = ent.ObrazProgramName,
                    Crypt = ent.ObrazProgramCrypt
                }).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(), u.Name + ' ' + u.Crypt)).ToList();

                ComboServ.FillCombo(cbObrazProgram, lst, false, false);
            }
        }
示例#11
0
        private void FillLicenseProgram()
        {
            using (PriemEntities context = new PriemEntities())
            {
                List <KeyValuePair <string, string> > lst = ((from ent in MainClass.GetEntry(context)
                                                              where ent.FacultyId == FacultyId
                                                              select new
                {
                    Id = ent.LicenseProgramId,
                    Name = ent.LicenseProgramName
                }).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(), u.Name)).ToList();

                ComboServ.FillCombo(cbLicenseProgram, lst, false, false);
                cbLicenseProgram.SelectedIndex = 0;
            }
        }
示例#12
0
        private void FillProfile()
        {
            using (PriemEntities context = new PriemEntities())
            {
                if (ObrazProgramId == null)
                {
                    ComboServ.FillCombo(cbProfile, new List <KeyValuePair <string, string> >(), false, false);
                    cbProfile.Enabled = false;
                    return;
                }

                var ent = MainClass.GetEntry(context).Where(c => c.FacultyId == FacultyId).Where(c => c.ProfileId != null);

                ent = ent.Where(c => c.IsSecond == IsSecond && c.IsReduced == IsReduced && c.IsParallel == IsParallel);

                if (StudyBasisId != null)
                {
                    ent = ent.Where(c => c.StudyBasisId == StudyBasisId);
                }
                if (StudyFormId != null)
                {
                    ent = ent.Where(c => c.StudyFormId == StudyFormId);
                }
                if (LicenseProgramId != null)
                {
                    ent = ent.Where(c => c.LicenseProgramId == LicenseProgramId);
                }
                if (ObrazProgramId != null)
                {
                    ent = ent.Where(c => c.ObrazProgramId == ObrazProgramId);
                }

                List <KeyValuePair <string, string> > lst = ent.ToList().Select(u => new KeyValuePair <string, string>(u.ProfileId.ToString(), u.ProfileName)).Distinct().ToList();

                if (lst.Count() > 0)
                {
                    ComboServ.FillCombo(cbProfile, lst, false, false);
                    cbProfile.Enabled = true;
                }
                else
                {
                    ComboServ.FillCombo(cbProfile, new List <KeyValuePair <string, string> >(), false, false);
                    cbProfile.Enabled = false;
                }
            }
        }
示例#13
0
        private void FillLicenseProgram()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context).Where(c => c.FacultyId == FacultyId && c.StudyLevel.LevelGroupId == StudyLevelGroupId);

                if (StudyFormId != null)
                {
                    ent = ent.Where(c => c.StudyFormId == StudyFormId);
                }

                List <KeyValuePair <string, string> > lst = ent.ToList().Select(u => new KeyValuePair <string, string>(u.LicenseProgramId.ToString(), u.SP_LicenseProgram.Name)).Distinct().ToList();

                ComboServ.FillCombo(cbLicenseProgram, lst, false, true);
                cbLicenseProgram.SelectedIndex = 0;
            }
        }
示例#14
0
        private void FillObrazProgram()
        {
            using (PriemEntities context = new PriemEntities())
            {
                List <KeyValuePair <string, string> > lst = ((from ent in MainClass.GetEntry(context)
                                                              where ent.FacultyId == facultyId &&
                                                              (cbStudyBasisId != null ? ent.StudyBasisId == cbStudyBasisId : true == true) &&
                                                              (cbStudyFormId != null ? ent.StudyBasisId == cbStudyFormId : true == true)
                                                              select new
                {
                    Id = ent.ObrazProgramId,
                    Name = ent.ObrazProgramName,
                    Crypt = ent.ObrazProgramCrypt
                }).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(), u.Name + ' ' + u.Crypt)).ToList();

                ComboServ.FillCombo(cbObrazProgram, lst, false, true);
            }
        }
示例#15
0
        int GetPlanValueAndCheckLock()
        {
            using (PriemEntities context = new PriemEntities())
            {
                int plan = 0, planCel = 0, entered = 0, enteredCel = 0;

                qEntry entry = (from ent in MainClass.GetEntry(context)
                                where ent.IsReduced == IsReduced && ent.IsParallel == IsParallel && ent.IsSecond == IsSecond &&
                                ent.FacultyId == FacultyId && ent.LicenseProgramId == LicenseProgramId &&
                                ent.ObrazProgramId == ObrazProgramId &&
                                (ProfileId == null ? ent.ProfileId == 0 : ent.ProfileId == ProfileId) &&
                                ent.StudyFormId == StudyFormId &&
                                ent.StudyBasisId == StudyBasisId
                                select ent).FirstOrDefault();

                if (entry == null)
                {
                    return(0);
                }

                plan    = entry.KCP ?? 0;
                planCel = entry.KCPCel ?? 0;

                Guid?entryId = entry.Id;

                entered = (from ab in context.qAbitAll
                           join ev in context.extEntryView
                           on ab.Id equals ev.AbiturientId
                           where ab.CompetitionId != 6 && ab.EntryId == entryId
                           select ab).Count();

                enteredCel = (from ab in context.qAbitAll
                              join ev in context.extEntryView
                              on ab.Id equals ev.AbiturientId
                              where ab.CompetitionId == 6 && ab.EntryId == entryId
                              select ab).Count();

                CheckLockAndPasha(context);

                return(plan - planCel - entered);
            }
        }
示例#16
0
        private void FillObrazProgram()
        {
            using (PriemEntities context = new PriemEntities())
            {
                var ent = MainClass.GetEntry(context).Where(c => c.FacultyId == FacultyId);

                if (StudyFormId != null)
                {
                    ent = ent.Where(c => c.StudyFormId == StudyFormId);
                }
                if (LicenseProgramId != null)
                {
                    ent = ent.Where(c => c.LicenseProgramId == LicenseProgramId);
                }

                List <KeyValuePair <string, string> > lst = ent.ToList().Select(u => new KeyValuePair <string, string>(u.ObrazProgramId.ToString(), u.SP_ObrazProgram.Name + ' ' + u.StudyLevel.Acronym + "." + u.SP_ObrazProgram.Number + "." + MainClass.PriemYear)).Distinct().ToList();

                ComboServ.FillCombo(cbObrazProgram, lst, false, true);
            }
        }