public static void ImportMagAbits() { List <string> lstPersons = new List <string>(); List <string> lstAbits = new List <string>(); LoadFromInet loadClass = new LoadFromInet(); DBPriem _bdcInet = loadClass.BDCInet; using (PriemEntities context = new PriemEntities()) { string _sQuery = @"SELECT DISTINCT qAbiturient.Id, qAbiturient.PersonId, qAbiturient.Barcode AS AbitBarcode, extPerson.Barcode AS PersonBarcode FROM qAbiturient INNER JOIN extPerson ON qAbiturient.PersonId = extPerson.Id WHERE StudyLevelId = 17 AND Enabled = 1 AND IsApprovedByComission = 1 AND IsImported = 0"; DataSet ds = _bdcInet.GetDataSet(_sQuery); Guid?personId; foreach (DataRow dr in ds.Tables[0].Rows) { int?abitBarcode = (int?)dr["AbitBarcode"]; if (!MainClass.CheckAbitBarcode(abitBarcode)) { continue; } int?persBarcode = (int?)dr["PersonBarcode"]; if (!MainClass.CheckPersonBarcode(persBarcode)) { personId = (from pers in context.extForeignPerson where pers.Barcode == persBarcode select pers.Id).FirstOrDefault(); } else { extPersonAll person = loadClass.GetPersonByBarcode(persBarcode.Value); if (!CheckIdent(person)) { lstPersons.Add(persBarcode.ToString()); continue; } ObjectParameter entId = new ObjectParameter("id", typeof(Guid)); context.Person_Foreign_insert(person.Barcode, person.Name, person.SecondName, person.Surname, person.BirthDate, person.BirthPlace, person.PassportTypeId, person.PassportSeries, person.PassportNumber, person.PassportAuthor, person.PassportDate, person.Sex, person.CountryId, person.NationalityId, person.RegionId, person.Phone, person.Mobiles, person.Email, person.Code, person.City, person.Street, person.House, person.Korpus, person.Flat, person.CodeReal, person.CityReal, person.StreetReal, person.HouseReal, person.KorpusReal, person.FlatReal, person.HostelAbit, false, null, false, null, person.IsExcellent, person.LanguageId, person.SchoolCity, person.SchoolTypeId, person.SchoolName, person.SchoolNum, person.SchoolExitYear, person.SchoolAVG, person.ForeignCountryEducId, person.RegionEducId, person.IsEqual, person.EqualDocumentNumber, person.HasTRKI, person.TRKICertificateNumber, person.AttestatRegion, person.AttestatSeries, person.AttestatNum, person.DiplomSeries, person.DiplomNum, person.HighEducation, person.HEProfession, person.HEQualification, person.HEEntryYear, person.HEExitYear, person.HEStudyFormId, person.HEWork, person.Stag, person.WorkPlace, person.Privileges, person.PassportCode, person.PersonalCode, person.PersonInfo, person.ExtraInfo, person.ScienceWork, person.StartEnglish, person.EnglishMark, entId); //_bdcInet.ExecuteQuery("UPDATE Person SET IsImported = 1 WHERE Person.Barcode = " + persBarcode); personId = (Guid)entId.Value; } qAbiturient abit = loadClass.GetAbitByBarcode(abitBarcode.Value); int cnt = (from en in context.qEntry where en.Id == abit.EntryId && !en.IsClosed select en).Count(); if (cnt == 0) { lstAbits.Add(abitBarcode.ToString()); continue; } ObjectParameter abEntId = new ObjectParameter("id", typeof(Guid)); int competitionId; if (abit.StudyBasisId == 1) { competitionId = 4; } else { competitionId = 3; } context.Abiturient_Insert(personId, abit.EntryId, competitionId, false, false, false, false, null, abit.DocDate, DateTime.Now, false, false, null, null, null, null, abit.LanguageId, false, abit.Priority, abit.Barcode, abit.CommitId, abit.CommitNumber, abit.IsGosLine, abEntId); // _bdcInet.ExecuteQuery("UPDATE Application SET IsImported = 1 WHERE Application.Barcode = " + abitBarcode); } } }