//Возвращает адрес прописки абитуриента")]
private AddressInfo GetSignAddress(int ncode)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
try
{
AddressInfo res = ctx.PersonAddresses.Where(p => (p.nCode == ncode) && ((p.ik_AddressType == 2) || (p.ik_AddressType == 3))).Select(x => new AddressInfo()
{
ID = (int)x.ik_personAddress,
StreetKey = x.Address.Ik_street,
StreetName = x.Address.Street.CStreet,
Building = x.Address.BuildingNumber,
Struct = x.Address.StructNumber,
FlatNum = x.Address.FlatNumber,
PostIndex = x.Address.fIndex
}).First();
return res;
}
catch
{
return null;
}
}
}
public void DelAbitExam(int ExamID)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ctx.ABIT_Del_vstup_ekz(ExamID);
}
}
public EnterInfo GetApplicationStatistic(int IDApp)
{
// нужно: учесть ЦКП (они занимают места первыми)
EnterInfo res = new EnterInfo();
res.Application = GetAppData(IDApp);
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
res.AvgBall = ctx.GetAbitAverageBall(IDApp);
int?[] AVGBalls = ctx.AbitAverageBalls.Where(p => (p.ik_type_kat == res.Application.CatEntryTypeKey)&&(p.NNrecord == res.Application.NumRecord)).Select(x => x.AVGBall).OrderByDescending(p => p.Value).ToArray();
int? PassCount = null;
if (res.Application.CatEntryTypeKey == 1)
PassCount = ctx.ABIT_Diapazon_spec_facs.Where(p => p.NNrecord == res.Application.NumRecord).Select(x => x.MestBudjet).Single();
if (PassCount != null)
{
if ((PassCount > AVGBalls.Length) || (PassCount == 0) && (res.Application.CatEntryTypeKey == 3))
res.PassBall = ctx.ABIT_proh_balls.Where(p => (p.NNrecord == res.Application.NumRecord) && (p.ik_kat_zach == res.Application.CatEntryKey)).Select(x => x.Ball).Single();
res.PassBall = AVGBalls[(int)PassCount - 1];
}
else
res.PassBall = ctx.ABIT_proh_balls.Where(p => (p.NNrecord == res.Application.NumRecord) && (p.ik_kat_zach == res.Application.CatEntryKey)).Select(x => x.Ball).Single();
return res;
}
}
//Возвращает документ абитуриента, удостоверяющий личность")]
private DocInfo GetIDDocumentData(int ncode)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
try
{
DocInfo res = ctx.Doc_studs.Where(p => (p.nCode == ncode) && (p.document.IsIdentity)).Select(x => new DocInfo()
{
ID = (int)x.Ik_doc,
DocTypeKey = x.Ik_vid_doc,
DocTypeName = x.document.cvid_doc,
Given = x.Dd_vidan,
GivenBy = x.Cd_kem_vidan,
Serie = x.Cd_seria,
Number = x.Np_number
}).First();
return res;
}
catch
{
return null;
}
}
}
public AppInfo GetAppData(int AppKey)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
AppInfo res = ctx.ABIT_postups.Where(p => p.NN_abit == AppKey).Select(x => new AppInfo()
{
ID = (int)x.NN_abit,
AppDate = x.dd_pod_zayav,
AppOnlineDate = x.dd_online,
AppEntryDate = x.dd_vvoda_zayav,
AppReturnDate = x.dd_vozvr_zayav,
CatEntryKey = x.ik_kat_zach,
CatEntryTypeKey = x.Kat_zach.ik_type_kat,
CatEntryName = x.Kat_zach.Cname_kat_zach,
EntryStateKey = x.ik_zach,
EntryStateName = x.ABIT_sost_zach.cname_zach,
NumRecord = x.NNrecord,
RegNumber = x.RegNomer,
IsPrimary = x.IsMain,
IsReal = x.Realy_postup
}).Single();
res.Exams = GetAbitExams(AppKey);
return res;
}
}
public int EditAbitExam(int? ExamID, int? DiscID, int? ExTypeID, string VedNum, int? Ball)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
return ctx.ABIT_Edit_vstup_exam_online(Ball, DiscID, ExTypeID, VedNum, ExamID);
}
}
public int AddAbitExam(int AppID, int DiscID, int ExTypeID, string VedNum, int? Ball)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
return ctx.ABIT_add_vstup_exam(Ball, AppID, DiscID, ExTypeID, VedNum);
}
}
public FamStateInfo[] GetFamStates()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
FamStateInfo[] siArray = ctx.sem_pols.Select(x => new FamStateInfo() { ID = x.ik_sem_pol, Name = x.csem_pol }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public ExamTypeInfo[] GetExamTypes()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ExamTypeInfo[] siArray = ctx.ABIT_VidSdachis.Select(x => new ExamTypeInfo() { ID = x.ik_sdach, Name = x.cname_sdach}).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public ExamDiscInfo[] GetExamDisciplines()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ExamDiscInfo[] siArray = ctx.ABIT_Discs.Select(x => new ExamDiscInfo() { ID = x.ik_disc, Name = x.сname_disc }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public void AddAbitDoc(int ncode, int DocTypeID, string Serie, string Number, string GivenBy, DateTime Given)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ctx.AppendDoc(ncode, DocTypeID, Serie,Number, Given, GivenBy);
return;
}
}
public void EditAbitAddress(int AddressID, int StreetKey, string Building, string flat, string index)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
int AddressTypeKey = ctx.PersonAddresses.Where(p => p.ik_personAddress == AddressID).Select(x => x.ik_AddressType).Single();
ctx.UpdatePersonAddress(AddressTypeKey, StreetKey, Building, "", flat, index, null, null, AddressID);
}
}
private int AddAbitAddress(int ncode, int AddressTypeKey, int StreetKey, string Building, string flat, string index)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
int code = Convert.ToInt16(ctx.AppendPersonAddress(ncode, AddressTypeKey, StreetKey, Building, "", flat, index, null, null).ReturnValue);
return code;
}
}
public void RemoveAbitAppl(int AppID)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ctx.ABIT_del_postup_online(AppID);
return;
}
}
public void EditAbitAppl(int AppID, int ncode, int RecruitID, int CatID, bool isMain)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ctx.ABIT_edit_postup_online(AppID, ncode, RecruitID, CatID, isMain);
return;
}
}
public void AddAbitLang(int ncode, int LangID, int? MasteryID)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ctx.AppendLang(MasteryID, ncode , 1, LangID, null);
return;
}
}
public void EditAbitDoc(int id_doc, int DocTypeID, string Serie, string Number, string GivenBy, DateTime Given)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
ctx.EditDoc(id_doc, DocTypeID, Given, GivenBy, Number, Serie);
return;
}
}
public TownInfo[] GetTowns(int ikCounty)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
TownInfo[] siArray = ctx.Gorods.Where(p => p.Ik_raion == ikCounty).Select(x => new TownInfo() { ID = x.Ik_gorod, Name = x.Cgorod}).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public StreetInfo[] GetStreets(int ikTown)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
StreetInfo[] siArray = ctx.Streets.Where(p => p.ik_gorod == ikTown).Select(x => new StreetInfo() { ID = x.Ik_street, Name = x.CStreet}).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public SCountInfo[] GetSpecCounts()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
SCountInfo[] siArray = ctx.Special_uchets.Select(x => new SCountInfo() { ID = x.Ik_special_uchet, Name = x.Cspecial_uchet}).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public SchoolInfo[] GetSchools(int ikTown)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
SchoolInfo[] siArray = ctx.Zaved_studs.Where(p => p.Ik_gorod == ikTown).Select(x => new SchoolInfo() { ID = x.ik_zaved, Name = x.cName_zaved }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public RegionInfo[] GetRegions(int ikStrana)
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
RegionInfo[] siArray = ctx.Regions.Where(p => p.Ik_strana == ikStrana).Select(x => new RegionInfo() { ID = x.Ik_region, Name = x.Cregion }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public PrepInfo[] GetPreps()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
PrepInfo[] siArray = ctx.Abit_podgs.Select(x => new PrepInfo() { ID = x.Ik_podg, Name = x.Cname_podg }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public OrgInfo[] GetOrganizations()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
OrgInfo[] siArray = ctx.Predprs.Select(x => new OrgInfo() { ID = x.Ik_pred, Name = x.Cname_pred}).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public MilInfo[] GetMilStates()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
MilInfo[] siArray = ctx.Voen_zvanies.Select(x => new MilInfo() { ID = x.Ik_voen_zvanie, Name = x.Cvoen_zvanie }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public EntTypeInfo[] GetEntranceTypes()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
EntTypeInfo[] siArray = ctx.Kat_zaches.Select(x => new EntTypeInfo() { ID = x.Ik_kat_zach, Name = x.Cname_kat_zach }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public LangInfo[] GetLanguages()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
LangInfo[] siArray = ctx.Langs.Select(x => new LangInfo() { ID = x.Ik_lang, Name = x.Cname_lang }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public DocTypeInfo[] GetIdentityDocTypes()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
DocTypeInfo[] siArray = ctx.documents.Where(p => p.IsIdentity).Select(x => new DocTypeInfo() { ID = x.ik_vid_doc, Name = x.cvid_doc }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public MastInfo[] GetMasteries()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
MastInfo[] siArray = ctx.Step_vlads.Select(x => new MastInfo() { ID = x.Ik_step_vlad, Name = x.Cname_step_vlad }).OrderBy(k => k.Name).ToArray();
return siArray;
}
}
public MedalInfo[] GetMedalTypes()
{
using (DataLayer.AbitDataContext ctx = new DataLayer.AbitDataContext(conn))
{
MedalInfo[] siArray = ctx.medal_abits.Select(x => new MedalInfo() { ID = x.ik_medal, Name = x.cmedal}).OrderBy(k => k.ID).ToArray();
return siArray;
}
}
