protected override void GetSource()
{
using (PriemEntities context = new PriemEntities())
{
var query = from ob in context.extOlympBook
orderby ob.Number, ob.OlympNameName, ob.OlympLevelId
select new
{
ob.Id,
ob.OlympTypeId,
ob.Number,
ob.OlympTypeName,
ob.OlympNameName,
ob.OlympSubjectName,
ob.OlympLevelName
};
int?olTypeId = ComboServ.GetComboIdInt(cbOlympType);
if (olTypeId != null)
{
query = query.Where(c => c.OlympTypeId == olTypeId);
}
Dgv.DataSource = query;
SetVisibleColumnsAndNameColumns();
}
}
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);
}
}
//обновление списка
public void UpdateVedList()
{
try
{
using (PriemEntities context = new PriemEntities())
{
List <KeyValuePair <string, string> > lst = ((from ent in context.extExamsVed
where ent.StudyLevelGroupId == StudyLevelGroupId &&
ent.FacultyId == FacultyId &&
(StudyBasisId != null ? ent.StudyBasisId == StudyBasisId : true == true)
select new
{
ent.Id,
ent.ExamName,
ent.Date,
StBasis = ent.StudyBasisId == null ? "" : ent.StudyBasisAcr,
AddVed = ent.IsAddVed ? " дополнительная" : "",
ent.AddCount
}).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(),
u.ExamName + ' ' + u.Date.ToShortDateString() + ' ' + u.StBasis + u.AddVed +
(u.AddCount > 1 ? "(" + Convert.ToString(u.AddCount) + ")" : ""))).ToList();
ComboServ.FillCombo(cbExamVed, lst, true, false);
}
}
catch (Exception ex)
{
WinFormsServ.Error("Ошибка при обновлении списка ведомостей: " + ex.Message);
}
}
//дополнительная инициализация контролов
private void InitControls()
{
try
{
InitFocusHandlers();
this.CenterToScreen();
this.MdiParent = MainClass.mainform;
_bdc = MainClass.Bdc;
_drh = new DataRefreshHandler(UpdateDataGrid);
MainClass.AddHandler(_drh);
Dgv = dgvAbitList;
lblCount.Text = dgvAbitList.RowCount.ToString();
if (!MainClass.IsOwner())
{
btnRemove.Visible = false;
}
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, true);
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
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;
}
}
}
private void FillComboOtherObrazProgram()
{
using (PriemEntities context = new PriemEntities())
{
var src = (from x in context.extEntry
join y in context.StudyLevel
on x.StudyLevelId equals y.Id
where y.LevelGroupId == MainClass.studyLevelGroupId && x.FacultyId == OtherFacultyId
orderby x.ObrazProgramNumber
select new
{
x.LicenseProgramId,
x.ObrazProgramId,
ObrazProgramName = x.ObrazProgramName,
ObrazProgramCrypt = x.ObrazProgramCrypt
}).Distinct();
if (OtherLicenseProgramId.HasValue)
{
src = src.Where(x => x.LicenseProgramId == OtherLicenseProgramId);
}
var bind = src.ToList()
.Select(x => new KeyValuePair <string, string>(x.ObrazProgramId.ToString(), x.ObrazProgramCrypt + " " + x.ObrazProgramName)).ToList();
ComboServ.FillCombo(cbOtherObrazProgram, bind, false, true);
}
}
private void FillComboOtherStudyBasis()
{
using (PriemEntities context = new PriemEntities())
{
var src = (from x in context.Entry
join y in context.StudyLevel
on x.StudyLevelId equals y.Id
join sb in context.StudyBasis
on x.StudyBasisId equals sb.Id
where y.LevelGroupId == MainClass.studyLevelGroupId && x.FacultyId == OtherFacultyId && x.StudyFormId == OtherStudyFormId
orderby sb.Id
select new
{
x.LicenseProgramId,
x.ObrazProgramId,
sb.Id,
sb.Name
}).Distinct();
if (OtherLicenseProgramId.HasValue)
{
src = src.Where(x => x.LicenseProgramId == OtherLicenseProgramId);
}
if (OtherObrazProgramId.HasValue)
{
src = src.Where(x => x.ObrazProgramId == OtherObrazProgramId);
}
var bind = src.Distinct().ToList()
.Select(x => new KeyValuePair <string, string>(x.Id.ToString(), x.Name)).Distinct().ToList();
ComboServ.FillCombo(cbOtherStudyBasis, bind, false, false);
}
}
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 void InitControls()
{
InitFocusHandlers();
_bdc = MainClass.Bdc;
//ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyBasis, HelpClass.GetComboListByTable("ed.StudyBasis", "ORDER BY Name"), false, false);
cbStudyBasis.SelectedIndex = 0;
FillStudyLevelGroup();
FillStudyForm();
cbStudyLevelGroup_SelectedIndexChanged(null, null);
FillLicenseProgram();
UpdateDataGrid();
cbStudyLevelGroup.SelectedIndexChanged += cbStudyLevelGroup_SelectedIndexChanged;
cbFaculty.SelectedIndexChanged += new EventHandler(cbFaculty_SelectedIndexChanged);
cbStudyForm.SelectedIndexChanged += new EventHandler(cbStudyForm_SelectedIndexChanged);
cbStudyBasis.SelectedIndexChanged += new EventHandler(cbStudyBasis_SelectedIndexChanged);
cbLicenseProgram.SelectedIndexChanged += new EventHandler(cbLicenseProgram_SelectedIndexChanged);
prh = new ProtocolRefreshHandler(UpdateDataGrid);
MainClass.AddProtocolHandler(prh);
}
protected override void ExtraInit()
{
base.ExtraInit();
btnFixieren.Visible = btnFixieren.Enabled = false;
gbPasha.Visible = gbPasha.Enabled = false;
chbFix.Visible = false;
if (MainClass.RightsFacMain() || MainClass.IsPasha())
{
btnFixieren.Visible = btnFixieren.Enabled = true;
}
if (MainClass.IsPasha())
{
gbPasha.Visible = gbPasha.Enabled = true;
chbFix.Visible = true;
}
if (!chbFix.Checked)
{
gbPasha.Visible = gbPasha.Enabled = false;
}
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyBasis, HelpClass.GetComboListByTable("ed.StudyBasis", "ORDER BY Name"), false, false);
cbStudyBasis.SelectedIndex = 0;
FillStudyLevelGroup();
FillStudyForm();
FillLicenseProgram();
FillObrazProgram();
FillProfile();
}
protected override void ExtraInit()
{
base.ExtraInit();
Dgv.ReadOnly = false;
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyBasis, HelpClass.GetComboListByTable("ed.StudyBasis", "ORDER BY Name"), false, true);
cbStudyBasis.SelectedIndex = 0;
ComboServ.FillCombo(cbStudyForm, HelpClass.GetComboListByTable("ed.StudyForm", "ORDER BY Id"), false, true);
cbStudyForm.SelectedIndex = 0;
FillLicenseProgram();
ComboServ.FillCombo(cbCompetition, HelpClass.GetComboListByTable("ed.Competition"), false, true);
UpdateDataGrid();
if (MainClass.IsFacMain() || MainClass.IsOwner())
{
btnLists.Enabled = true;
}
else
{
btnLists.Enabled = false;
}
}
}
private void FillComboStudyForm()
{
using (PriemEntities context = new PriemEntities())
{
var SF = from x in context.qEntry
where x.StudyLevelGroupId == 1 && x.FacultyId == FacultyId
select new { x.LicenseProgramId, x.ObrazProgramId, x.ProfileId, x.StudyFormId, x.StudyFormName };
if (LicenseProgramId != null)
{
SF = SF.Where(x => x.LicenseProgramId == LicenseProgramId);
}
if (ObrazProgramId != null)
{
SF = SF.Where(x => x.ObrazProgramId == ObrazProgramId);
}
if (ProfileId != null)
{
SF = SF.Where(x => x.ProfileId == ProfileId);
}
List <KeyValuePair <string, string> > lst = SF.Distinct().ToList().
Select(x => new KeyValuePair <string, string>(x.StudyFormId.ToString(), x.StudyFormName)).Distinct().ToList();
ComboServ.FillCombo(cbStudyForm, lst, false, true);
}
}
public void UpdateVedRoomList()
{
try
{
if (ExamVedId == null)
{
ComboServ.FillCombo(cbExamVedRoom, new List <KeyValuePair <string, string> >(), false, false);
cbExamVedRoom.Enabled = false;
}
else
{
using (PriemEntities context = new PriemEntities())
{
List <KeyValuePair <string, string> > lst = ((from ent in context.ExamsVedRoom
where ent.ExamsVedId == ExamVedId
orderby ent.Number, ent.RoomNumber
select new
{
ent.Id,
ent.Number,
ent.RoomNumber
}).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(),
u.Number + ": " + u.RoomNumber)).ToList();
ComboServ.FillCombo(cbExamVedRoom, lst, true, false);
cbExamVedRoom.Enabled = true;
}
}
}
catch (Exception ex)
{
WinFormsServ.Error("Ошибка при обновлении списка ведомостей: " + ex.Message);
}
}
protected override void ExtraInit()
{
base.ExtraInit();
Dgv.ReadOnly = false;
btnRemove.Visible = btnAdd.Visible = false;
//this.Width = 774;
try
{
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyLevelGroup, HelpClass.GetComboListByTable("ed.StudyLevelGroup", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyBasis, HelpClass.GetComboListByTable("ed.StudyBasis", "ORDER BY Name"), false, true);
cbStudyBasis.SelectedIndex = 0;
FillStudyForm();
FillLicenseProgram();
FillObrazProgram();
FillExams();
ComboServ.FillCombo(cbOlympType, HelpClass.GetComboListByTable("ed.OlympType", " ORDER BY Id"), false, true);
ComboServ.FillCombo(cbOlympName, HelpClass.GetComboListByTable("ed.OlympName"), false, true);
ComboServ.FillCombo(cbOlympSubject, HelpClass.GetComboListByTable("ed.OlympSubject"), false, true);
ComboServ.FillCombo(cbOlympValue, HelpClass.GetComboListByTable("ed.OlympValue"), false, true);
ComboServ.FillCombo(cbOlympLevel, HelpClass.GetComboListByTable("ed.OlympLevel"), false, true);
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
protected override void ExtraInit()
{
base.ExtraInit();
loadClass = new LoadFromInet();
_bdcInet = loadClass.BDCInet;
if (MainClass.IsReadOnly())
{
btnLoad.Enabled = false;
}
btnAdd.Visible = btnCard.Visible = btnRemove.Visible = false;
try
{
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbChangeType, HelpClass.GetComboListByTable("ed.ChangeType", "ORDER BY Id"), false, false);
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyBasis, HelpClass.GetComboListByTable("ed.StudyBasis", "ORDER BY Name"), false, true);
cbStudyBasis.SelectedIndex = 0;
FillLicenseProgram();
FillObrazProgram();
FillProfile();
UpdateDataGrid();
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
private void FillProfile()
{
try
{
using (PriemEntities context = new PriemEntities())
{
List <KeyValuePair <string, string> > lst = ((from ent in GetEntry(context)
where ent.LicenseProgramId == LicenseProgramId && ent.ObrazProgramId == ObrazProgramId && 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, false);
cbProfile.Enabled = true;
}
else
{
ComboServ.FillCombo(cbProfile, new List <KeyValuePair <string, string> >(), true, false);
cbProfile.Enabled = false;
}
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы FillProfile" + exc.Message);
}
}
private void FillComboStudyForm()
{
using (PriemEntities context = new PriemEntities())
{
var src = (from x in context.qEntry
where x.StudyLevelGroupId == MainClass.studyLevelGroupId && x.FacultyId == FacultyId
select new
{
x.LicenseProgramId,
x.ObrazProgramId,
x.ProfileId,
x.StudyFormId,
x.StudyFormName
}).Distinct();
if (LicenseProgramId.HasValue)
{
src = src.Where(x => x.LicenseProgramId == LicenseProgramId);
}
if (ObrazProgramId.HasValue)
{
src = src.Where(x => x.ObrazProgramId == ObrazProgramId);
}
if (ProfileId.HasValue)
{
src = src.Where(x => x.ProfileId == ProfileId);
}
var bind = src.Distinct().ToList()
.Select(x => new KeyValuePair <string, string>(x.StudyFormId.ToString(), x.StudyFormName)).ToList();
ComboServ.FillCombo(cbStudyForm, bind, false, true);
}
}
protected override void ExtraInit()
{
base.ExtraInit();
_title = "Данные по договору";
_tableName = "ed.PaidData";
this.MdiParent = null;
try
{
using (PriemEntities context = new PriemEntities())
{
_Id = (from pd in context.PaidData
where pd.AbiturientId == _abitId
orderby pd.DogovorDate descending
select pd.Id).FirstOrDefault().ToString();
if (string.IsNullOrEmpty(_Id) || _Id == Guid.Empty.ToString())
{
_Id = null;
}
ComboServ.FillCombo(cbDogovorType, HelpClass.GetComboListByTable("ed.DogovorType", "ORDER BY Id"), false, false);
UpdateAfterDogovorType();
ComboServ.FillCombo(cbProrektor, HelpClass.GetComboListByTable("ed.Prorektor"), false, false);
ComboServ.FillCombo(cbPayPeriod, HelpClass.GetComboListByTable("ed.PayPeriod"), false, false);
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
private void FillStudyBasis()
{
try
{
using (PriemEntities context = new PriemEntities())
{
List <KeyValuePair <string, string> > lst = ((from ent in GetEntry(context)
where ent.LicenseProgramId == LicenseProgramId &&
ent.ObrazProgramId == ObrazProgramId &&
(ProfileId == null ? ent.ProfileId == null : ent.ProfileId == ProfileId) &&
ent.FacultyId == FacultyId &&
ent.StudyFormId == StudyFormId
select new
{
Id = ent.StudyBasisId,
Name = ent.StudyBasis.Name
}).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(), u.Name)).ToList();
ComboServ.FillCombo(cbStudyBasis, lst, false, false);
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы FillStudyBasis" + exc.Message);
}
}
private void LoadFaculties()
{
using (PriemEntities context = new PriemEntities())
{
var facs = (from ent in context.qEntry
join sl in context.StudyLevel
on ent.StudyLevelId equals sl.Id
where sl.LevelGroupId == MainClass.studyLevelGroupId
select new
{
ent.StudyBasisId,
ent.StudyFormId,
Id = ent.FacultyId,
Name = ent.FacultyName
});
int?iStudyFormId = GetStudyFormId();
int?iStudyBasisId = GetStudyBasisId();
if (iStudyFormId != null)
{
facs = facs.Where(x => x.StudyFormId == iStudyFormId.Value);
}
//if (iStudyBasisId != null)
// facs = facs.Where(x => x.StudyBasisId == iStudyBasisId.Value);
var lKVP = facs.OrderBy(x => x.Id).ToList().Select(x => new KeyValuePair <string, string>(x.Id.ToString(), x.Name)).Distinct().ToList();
ComboServ.FillCombo(cbFaculty, lKVP, false, true);
}
}
private void LoadStudyForms()
{
using (PriemEntities context = new PriemEntities())
{
var sforms = (from ent in context.qEntry
join sl in context.StudyLevel
on ent.StudyLevelId equals sl.Id
where sl.LevelGroupId == (MainClass.dbType == PriemType.Priem ? 1 : 2)
select new
{
ent.StudyBasisId,
ent.FacultyId,
Id = ent.StudyFormId,
Name = ent.StudyFormName
});
int?iFacultyId = GetFacultyId();
int?iStudyBasisId = GetStudyBasisId();
if (iFacultyId != null)
{
sforms = sforms.Where(x => x.FacultyId == iFacultyId.Value);
}
//if (iStudyBasisId != null)
// sforms = sforms.Where(x => x.StudyBasisId == iStudyBasisId.Value);
var lKVP = sforms.ToList().Select(x => new KeyValuePair <string, string>(x.Id.ToString(), x.Name)).Distinct().OrderBy(x => x.Value).ToList();
ComboServ.FillCombo(cbStudyForm, lKVP, false, false);
}
}
public void UpdateProtocolList(object sender, EventArgs e)
{
try
{
_currentProtocolIndex = cbProtocolNum.SelectedIndex;
using (PriemEntities context = new PriemEntities())
{
int protType = TypeToInt(_protocolType);
var protocols = (from p in context.qProtocol
where !p.IsOld && p.ProtocolTypeId == protType &&
p.FacultyId == FacultyId && p.StudyFormId == StudyFormId && p.StudyBasisId == StudyBasisId
orderby p.Number
select new
{
p.Id,
p.Number
}).ToList().Select(x => new KeyValuePair <string, string>(x.Id.ToString(), x.Number)).ToList();
ComboServ.FillCombo(cbProtocolNum, protocols, true, false);
}
}
catch (Exception ex)
{
WinFormsServ.Error("Ошибка при обновлении списка протоколов: " + ex.Message);
}
}
protected override void ExtraInit()
{
base.ExtraInit();
btnAdd.Visible = btnRemove.Visible = false;
try
{
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyForm, HelpClass.GetComboListByTable("ed.StudyForm", "ORDER BY Id"), false, false);
FillLicenseProgram();
FillObrazProgram();
ComboServ.FillCombo(cbLanguage, HelpClass.GetComboListByTable("ed.Language"), false, true);
ComboServ.FillCombo(cbOlympType, HelpClass.GetComboListByTable("ed.OlympType", " ORDER BY Id"), false, true);
ComboServ.FillCombo(cbOlympName, HelpClass.GetComboListByTable("ed.OlympName"), false, true);
ComboServ.FillCombo(cbOlympSubject, HelpClass.GetComboListByTable("ed.OlympSubject"), false, true);
ComboServ.FillCombo(cbOlympValue, HelpClass.GetComboListByTable("ed.OlympValue"), false, true);
ComboServ.FillCombo(cbOlympLevel, HelpClass.GetComboListByTable("ed.OlympLevel"), false, true);
UpdateDataGrid();
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
protected override void ExtraInit()
{
base.ExtraInit();
_title = "Экзамен";
_tableName = "ed.[ExamInEntry]";
try
{
if (_Id != null)
{
chbToAllStudyBasis.Visible = false;
}
chbToAllStudyBasis.Checked = true;
using (PriemEntities context = new PriemEntities())
{
List <KeyValuePair <string, string> > lst = ((from f in context.Exam
join en in context.ExamName
on f.ExamNameId equals en.Id
select new
{
Id = f.Id,
Name = en.Name,
IsAdd = f.IsAdditional
}).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(), u.Name + (u.IsAdd ? " (доп)" : ""))).ToList();
ComboServ.FillCombo(cbExam, lst, false, false);
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
private void FillComboRegion()
{
string query = @"
SELECT DISTINCT Region.Id, Region.Name
FROM ed.Abiturient
INNER JOIN ed.Person ON Person.Id = Abiturient.PersonId
INNER JOIN ed.Region ON Region.Id = Person.RegionId
INNER JOIN ed.Entry ON Entry.Id = Abiturient.EntryId
INNER JOIN ed.StudyLevel ON StudyLevel.Id = Entry.StudyLevelId
WHERE StudyLevel.LevelGroupId = @LevelGroupId";
SortedList <string, object> sl = new SortedList <string, object>();
sl.Add("@LevelGroupId", MainClass.studyLevelGroupId);
if (FacultyId.HasValue)
{
query += " AND Entry.FacultyId=@FacultyId ";
sl.Add("@FacultyId", FacultyId);
}
if (LicenseProgramId.HasValue)
{
query += " AND Entry.LicenseProgramId=@LicenseProgramId ";
sl.Add("@LicenseProgramId", LicenseProgramId);
}
if (ObrazProgramId.HasValue)
{
query += " AND Entry.ObrazProgramId=@ObrazProgramId ";
sl.Add("@ObrazProgramId", ObrazProgramId);
}
if (StudyFormId.HasValue)
{
query += " AND Entry.StudyFormId=@StudyFormId ";
sl.Add("@StudyFormId", StudyFormId);
}
if (StudyBasisId.HasValue)
{
query += " AND Entry.StudyBasisId=@StudyBasisId ";
sl.Add("@StudyBasisId", StudyBasisId);
}
string tail = " ORDER BY Region.Id";
DataTable tbl = MainClass.Bdc.GetDataSet(query + tail, sl).Tables[0];
List <KeyValuePair <string, string> > bind =
(from DataRow rw in tbl.Rows
select new
KeyValuePair <string, string>(rw.Field <int>("Id").ToString(), rw.Field <string>("Name"))
).Distinct().ToList();
//EgeExams =
// (from DataRow rw in tbl.Rows
// select new
// {
// Id = rw.Field<int>("Id"),
// Name = rw.Field<string>("Name")
// }).ToDictionary(x => x.Id, x => x.Name);
ComboServ.FillCombo(cbRegion, bind, false, false);
}
protected override void ExtraInit()
{
base.ExtraInit();
_title = "Экзамен";
_tableName = "ed.[Exam]";
try
{
using (PriemEntities context = new PriemEntities())
{
List <KeyValuePair <string, string> > lst = ((from f in context.ExamName
select new
{
Id = f.Id,
Name = f.Name
}).Distinct()).ToList().Select(u => new KeyValuePair <string, string>(u.Id.ToString(), u.Name)).ToList();
ComboServ.FillCombo(cbExamName, lst, false, false);
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
//дополнительная инициализация контролов
protected override void ExtraInit()
{
base.ExtraInit();
this.Width = 840;
muchExams = false;
btnRemove.Visible = btnAdd.Visible = false;
try
{
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbStudyLevelGroup, HelpClass.GetComboListByTable("ed.StudyLevelGroup", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyBasis, HelpClass.GetComboListByTable("ed.StudyBasis", "ORDER BY Name"), false, true);
cbStudyBasis.SelectedIndex = 0;
FillStudyForm();
FillLicenseProgram();
FillObrazProgram();
FillProfile();
ComboServ.FillCombo(cbCompetition, HelpClass.GetComboListByTable("ed.Competition", "ORDER BY Name"), false, true);
FillExams();
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
private void FillComboEgeExam()
{
string query = @"
SELECT DISTINCT EgeExamName.Id, EgeExamName.Name
FROM ed.Abiturient
INNER JOIN ed.ExamInEntry ON ExamInEntry.EntryId = Abiturient.EntryId
INNER JOIN ed.EgeToExam ON EgeToExam.ExamId = ExamInEntry.ExamId
INNER JOIN ed.EgeExamName ON EgeExamName.Id = EgeToExam.EgeExamNameId
INNER JOIN ed.Entry ON Entry.Id = Abiturient.EntryId
INNER JOIN ed.StudyLevel ON StudyLevel.Id = Entry.StudyLevelId
WHERE StudyLevel.LevelGroupId = @LevelGroupId";
SortedList <string, object> sl = new SortedList <string, object>();
sl.Add("@LevelGroupId", MainClass.studyLevelGroupId);
if (FacultyId.HasValue)
{
query += " AND Entry.FacultyId=@FacultyId ";
sl.Add("@FacultyId", FacultyId);
}
if (LicenseProgramId.HasValue)
{
query += " AND Entry.LicenseProgramId=@LicenseProgramId ";
sl.Add("@LicenseProgramId", LicenseProgramId);
}
if (ObrazProgramId.HasValue)
{
query += " AND Entry.ObrazProgramId=@ObrazProgramId ";
sl.Add("@ObrazProgramId", ObrazProgramId);
}
if (StudyFormId.HasValue)
{
query += " AND Entry.StudyFormId=@StudyFormId ";
sl.Add("@StudyFormId", StudyFormId);
}
if (StudyBasisId.HasValue)
{
query += " AND Entry.StudyBasisId=@StudyBasisId ";
sl.Add("@StudyBasisId", StudyBasisId);
}
DataTable tbl = MainClass.Bdc.GetDataSet(query, sl).Tables[0];
List <KeyValuePair <string, string> > bind =
(from DataRow rw in tbl.Rows
select new
KeyValuePair <string, string>(rw.Field <int>("Id").ToString(), rw.Field <string>("Name"))
).Distinct().ToList();
EgeExams =
(from DataRow rw in tbl.Rows
select new
{
Id = rw.Field <int>("Id"),
Name = rw.Field <string>("Name")
}).ToDictionary(x => x.Id, x => x.Name);
ComboServ.FillCombo(cbEgeExamName, bind, false, false);
}
protected override void ExtraInit()
{
base.ExtraInit();
_tableName = "ed.Person";
Dgv = dgvApplications;
personBarc = 0;
rbMale.Checked = true;
gbAtt.Visible = true;
gbDipl.Visible = false;
chbIsEqual.Visible = false;
chbHostelAbitYes.Checked = false;
chbHostelAbitNo.Checked = false;
lblHasAssignToHostel.Visible = false;
lblHasExamPass.Visible = false;
btnPrintHostel.Enabled = false;
btnPrintExamPass.Enabled = false;
btnGetAssignToHostel.Enabled = false;
btnGetExamPass.Enabled = false;
tbNum.Enabled = false;
btnAddAbit.Enabled = false;
try
{
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbPassportType, HelpClass.GetComboListByTable("ed.PassportType"), false, false);
ComboServ.FillCombo(cbCountry, HelpClass.GetComboListByTable("ed.ForeignCountry", "ORDER BY Distance, Name"), false, false);
ComboServ.FillCombo(cbNationality, HelpClass.GetComboListByTable("ed.ForeignCountry", "ORDER BY Distance, Name"), false, false);
ComboServ.FillCombo(cbRegion, HelpClass.GetComboListByTable("ed.Region", "ORDER BY Distance, Name"), true, false);
ComboServ.FillCombo(cbLanguage, HelpClass.GetComboListByTable("ed.Language"), false, false);
ComboServ.FillCombo(cbCountryEduc, HelpClass.GetComboListByTable("ed.ForeignCountry", "ORDER BY Distance, Name"), false, false);
ComboServ.FillCombo(cbHEStudyForm, HelpClass.GetComboListByTable("ed.StudyForm"), true, false);
ComboServ.FillCombo(cbSchoolType, HelpClass.GetComboListByTable("ed.SchoolType"), false, false);
cbSchoolCity.DataSource = context.ExecuteStoreQuery <string>("SELECT DISTINCT ed.Person_EducationInfo.SchoolCity AS Name FROM ed.Person_EducationInfo WHERE ed.Person_EducationInfo.SchoolCity > '' ORDER BY 1");
cbAttestatSeries.DataSource = context.ExecuteStoreQuery <string>("SELECT DISTINCT ed.Person_EducationInfo.AttestatSeries AS Name FROM ed.Person_EducationInfo WHERE ed.Person_EducationInfo.AttestatSeries > '' ORDER BY 1");
cbHEQualification.DataSource = context.ExecuteStoreQuery <string>("SELECT DISTINCT ed.Person_EducationInfo.HEQualification AS Name FROM ed.Person_EducationInfo WHERE NOT ed.Person_EducationInfo.HEQualification IS NULL /*AND ed.Person_EducationInfo.HEQualification > ''*/ ORDER BY 1");
cbAttestatSeries.SelectedIndex = -1;
cbSchoolCity.SelectedIndex = -1;
cbHEQualification.SelectedIndex = -1;
}
btnDocs.Visible = true;
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка при инициализации формы " + exc.Message);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
WordDoc wd = new WordDoc(string.Format(@"{0}\ListPerson.dot", MainClass.dirTemplates));
int k = dgvAbiturients.Columns.Count;
wd.AddNewTable(dgvAbiturients.Rows.Count + 1, k);
TableDoc td = wd.Tables[0];
int? facId = ComboServ.GetComboIdInt(cbFaculty);
string sFac = cbFaculty.Text.ToLower();
if (sFac.CompareTo("все") == 0)
{
sFac = "";
}
else
{
sFac = "получивших направления на послеление от ";
if (facId == 3)
{
sFac += "высшей школы менеджмента ";
}
else
{
sFac += sFac.Replace("кий", "кого ").Replace("ый", "ого ") + " факультета ";
}
}
wd.Fields["Faculty"].Text = sFac;
wd.Fields["Info"].Text = "для общежитий";
int i = 0;
td[0, 0] = "№ п/п";
for (int j = 0; j < k - 1; j++)
{
td[j + 1, 0] = dgvAbiturients.Columns[j + 1].HeaderText;
}
// печать из грида
foreach (DataGridViewRow dgvr in dgvAbiturients.Rows)
{
td[0, i + 1] = (i + 1).ToString();
for (int j = 0; j < k - 1; j++)
{
td[j + 1, i + 1] = dgvAbiturients.Rows[i].Cells[j + 1].Value.ToString();
}
i++;
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message);
}
}
