public static void fieldOfStudyInfo(Document doc, FieldOfStudy fieldOfStudy) { // Wydział if (fieldOfStudy.Faculty != null) { faculty(fieldOfStudy.Faculty, doc); } // kierunek if (fieldOfStudy.Name != null) { fieldofstudy(fieldOfStudy.Name, doc); } // dyscyplina if (fieldOfStudy.Discipline != null) { dyscipline(doc, fieldOfStudy.Discipline); } // stopien i stacjonarnosc fieldOfStudyLevel(doc, fieldOfStudy.Level); // Forma fieldOfStudyType(doc, fieldOfStudy.Type); // Profil fieldOfStudyProfile(doc, fieldOfStudy.Profile); // Język fieldOfStudyLanguage(doc, fieldOfStudy.Language); }
/// <summary> /// Funkcja aktualizująca studenta o zadanym Id /// </summary> /// <param name="index"></param> /// <param name="fieldOfStudyName"></param> /// <param name="studyVintageYear"></param> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="birthDate"></param> /// <param name="pesel"></param> /// <param name="addressId"></param> /// <param name="deficit"></param> /// <param name="phoneNumber"></param> /// <param name="eMail"></param> /// <returns></returns> public bool UpdateStudent(int index, string fieldOfStudyName, int studyVintageYear, string firstName, string lastName, DateTime birthDate, string pesel, int addressId, short deficit, string phoneNumber, string eMail) { Student student = DbContext.Students.SingleOrDefault(s => s.Sindex == index); StudyVintage studyVintage = DbContext.StudyVintages.SingleOrDefault(s => s.Year == studyVintageYear); FieldOfStudy fieldOfStudy = DbContext.FieldsOfStudies.SingleOrDefault(f => f.Name == fieldOfStudyName); if (studyVintage == null || fieldOfStudy == null) { return(false); } student.FieldOfStudy = fieldOfStudy; student.StudyVintage = studyVintage; student.FirstName = firstName; student.LastName = lastName; student.BirthDate = birthDate; student.Pesel = pesel; student.AddressId = addressId; student.ECTSDeficit = deficit; student.PhoneNumber = phoneNumber; student.EMail = eMail; return(DbContext.SaveChanges() > 0); }
/// <summary> /// Funkcja dodająca nowego studenta do tabeli Students /// </summary> /// <param name="index"></param> /// <param name="fieldOfStudyName"></param> /// <param name="studyVintageYear"></param> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="birthDate"></param> /// <param name="pesel"></param> /// <param name="addressId"></param> /// <param name="deficit"></param> /// <param name="phoneNumber"></param> /// <param name="eMail"></param> /// <returns></returns> public bool AddStudent(int index, string fieldOfStudyName, int studyVintageYear, string firstName, string lastName, DateTime birthDate, string pesel, int addressId, short deficit, string phoneNumber, string eMail) { StudyVintage studyVintage = DbContext.StudyVintages.SingleOrDefault(s => s.Year == studyVintageYear); FieldOfStudy fieldOfStudy = DbContext.FieldsOfStudies.SingleOrDefault(f => f.Name == fieldOfStudyName); if (studyVintage == null || fieldOfStudy == null) { return(false); } Student student = new Student() { Sindex = index, FieldOfStudy = fieldOfStudy, StudyVintage = studyVintage, FirstName = firstName, LastName = lastName, BirthDate = birthDate, Pesel = pesel, AddressId = addressId, ECTSDeficit = deficit, PhoneNumber = phoneNumber, EMail = eMail }; DbContext.Students.Add(student); return(DbContext.SaveChanges() > 0); }
public async Task <IActionResult> Edit(int id, [Bind("FieldOfStudyId,Name")] FieldOfStudy fieldOfStudy) { if (id != fieldOfStudy.FieldOfStudyId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(fieldOfStudy); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FieldOfStudyExists(fieldOfStudy.FieldOfStudyId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(fieldOfStudy)); }
public void AddVak(string vakcode, string titel, int studiepunten) { var cInUse = from c in db.Course where c.Vakcode == vakcode select c; if (cInUse.Any()) { throw new ArgumentException("Vak met deze vakcode bestaat reeds."); } Course course = new Course { Vakcode = vakcode.ToUpper(), Titel = titel, Studiepunten = studiepunten }; FieldOfStudy FOS = db.FieldOfStudy.Where(fos => fos.RichtingCode == vakcode.Substring(0, 3)).FirstOrDefault(); if (FOS != null) { course.FieldOfStudyId = FOS.Id; FOS.RichtingStudiepunten += course.Studiepunten; } db.Course.Add(course); db.SaveChanges(); }
private static void subjectTitle(FieldOfStudy fieldOfStudy, Document doc) { doc.Add(new Paragraph("Wydział ".ToUpper() + fieldOfStudy.Faculty)); // Karta przedmiotu doc.Add(new Paragraph("Karta Przedmiotu".ToUpper()) .SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER)); }
public async Task GetAllFieldOfStudyTest() { // ARRANGE FieldOfStudyService service = new FieldOfStudyService(ctxDb); FieldOfStudy FOS1 = new FieldOfStudy { RichtingCode = "MGP", RichtingTitel = "Model graduaat programmeren", Type = "Graduaat", RichtingStudiepunten = 60 }; FieldOfStudy FOS2 = new FieldOfStudy { RichtingCode = "MBI", RichtingTitel = "Model bachelor informatica", Type = "bachelor", RichtingStudiepunten = 90 }; FieldOfStudy FOS3 = new FieldOfStudy { RichtingCode = "MBC", RichtingTitel = "Model bachelor chemie", Type = "bachelor", RichtingStudiepunten = 120 }; ctxDb.FieldOfStudy.Add(FOS1); ctxDb.FieldOfStudy.Add(FOS2); ctxDb.FieldOfStudy.Add(FOS3); ctxDb.SaveChanges(); // ACT var fosList = service.GetAllFieldOfStudy(); // ASSERT Assert.IsTrue((await fosList.FirstOrDefaultAsync()).RichtingCode == "MBC"); }
public void EditRichting(int richtindId, string richtingCode, string richtingTitel, string type) { FieldOfStudy field = db.FieldOfStudy.Find(richtindId); if (field == null) { throw new ArgumentException("Deze richting werd niet gevonden in het systeem."); } try { FieldOfStudy newfield = new FieldOfStudy { Id = richtindId, RichtingCode = richtingCode, RichtingTitel = richtingTitel, Type = type, RichtingStudiepunten = 0 }; field.Id = newfield.Id; field.RichtingCode = newfield.RichtingCode; field.RichtingTitel = newfield.RichtingTitel; field.Type = newfield.Type; db.SaveChanges(); } catch (Exception e) { throw new ArgumentException("Er liep iets mis met het updaten van de data: " + e.Message); } }
private static void info(Subject subject, FieldOfStudy fieldOfStudy, Document doc) { // Wydział subjectTitle(fieldOfStudy, doc); // Prowadzacy regularParagraph("Prowadzący: ", subject.Supervisor.Name, doc); // nazwa pl italicParagraph("Nazwa w języku polskim ", subject.NamePl, doc); // nazwa en italicParagraph("Nazwa w języku angielskim ", subject.NameEng, doc); // kierunek italicParagraph("Kierunek studiów: ", fieldOfStudy.Name, doc); // specjalnosc italicParagraph("Specjalność: ", subject.Specialization.Name, doc); // stopien i stacjonarnosc regularParagraph("Stopień studiów i forma: ", EnumTranslator.Translate(fieldOfStudy.Level.ToString()) + ", " + EnumTranslator.Translate(fieldOfStudy.Type.ToString()) , doc); // rodzaj regularParagraph("Rodzaj przedmiotu: ", EnumTranslator.Translate(subject.TypeOfSubject.ToString()), doc); // kod regularParagraph("Kod przedmiotu: ", subject.Code.ToUpper(), doc); // grupa bool isGroup = subject.Lessons.Any(l => l.IsGroup); regularParagraph("Grupa kursów: ", isGroup ? "TAK" : "NIE", doc); }
public async Task GetLatestTest(FieldOfStudy fos, LearningOutcomeDocument input, LearningOutcomeDocument expectedOutcome) { // Arrange var dbContext = SyllabusTestRepository.GetInMemorySyllabusContext(); dbContext.FieldsOfStudies.Add(fos); if (input != null) { dbContext.LearningOutcomeDocuments.Add(input); } dbContext.SaveChanges(); var manager = new LearningOutcomeService(dbContext, null, null); // Act var actualResult = await manager.Latest("TEST001", "2020/2021"); // Assert Assert.Equal(expectedOutcome.Id, actualResult.Id); Assert.Equal(expectedOutcome.Version, actualResult.Version); Assert.Equal(expectedOutcome.AcademicYear, actualResult.AcademicYear); Assert.Equal(expectedOutcome.FieldOfStudy.Code, actualResult.FieldOfStudy.Code); Assert.Equal(expectedOutcome.LearningOutcomes.Count, actualResult.LearningOutcomes.Count); Assert.Equal(expectedOutcome.IsDeleted, actualResult.IsDeleted); }
public static FieldOfStudyNode Create(FieldOfStudy fos) { if (fos == null) { throw new ArgumentNullException(nameof(fos)); } return(new FieldOfStudyNode(fos.Id, fos.Name)); }
private static void fieldOfStudyInfo(FieldOfStudy fieldOfStudy, Document doc) { foreach (var prop in typeof(FieldOfStudy).GetProperties().Where(prop => Attribute.IsDefined(prop, typeof(PdfNameAttribute)))) { string propName = ((PdfNameAttribute)prop.GetCustomAttribute(typeof(PdfNameAttribute), true)).name; string value = prop.GetValue(fieldOfStudy)?.ToString() ?? ""; doc.Add(new Paragraph(EnumTranslator.Translate(propName) + " - " + EnumTranslator.Translate(value))); } }
private void HelloWorld_Executed(object sender, ExecutedRoutedEventArgs e) { MessageBox.Show("Hello world!"); /** inicijalizacija softvera */ Software soft1 = new Software("1", "s1", OS.WINDOWS, "pro1", "a.com", "1997", 51, "o1"); Software soft2 = new Software("2", "s2", OS.WINDOWS, "pro2", "b.com", "1998", 52, "o2"); Software soft3 = new Software("3", "s3", OS.WINDOWS, "pro3", "c.com", "1999", 53, "o3"); /** inicijalizacija ucionice id|opis|mijesta|proj|tabla|pametna| OS */ Classroom c1 = new Classroom("1", "o1", 20, false, true, false, OS.C_BOTH); c1.InstalledSoftware = new List <string>() { "1", "2", "3" }; FieldOfStudy fos1 = new FieldOfStudy("fos1", "SIIT", DateTime.Parse("25/05/2014"), "opisFOS1"); /** inicijalizacija predmeta */ Subject subj1 = new Subject("1", "prd1", fos1, "subjO1", 20, 1, 2, false, false, false, OS.SUBJ_WHATEVER); subj1.NeedsSoftware = new List <string>() { "1", "2" }; Subject subj2 = new Subject("2", "prd2", fos1, "subjO2", 16, 1, 3, false, false, false, OS.SUBJ_WHATEVER); subj2.NeedsSoftware = new List <string>() { "2", "4" }; Subject subj3 = new Subject("3", "prd3", fos1, "subjO3", 22, 2, 2, false, false, false, OS.SUBJ_WHATEVER); subj3.NeedsSoftware = new List <string>() { "1", "2" }; List <Subject> subjects = new List <Subject>() { subj1, subj2, subj3 }; List <Subject> retVal = new List <Subject>(); List <string> tuFajnd = c1.InstalledSoftware; HashSet <string> hesSet = new HashSet <string>(tuFajnd); bool sadrzi = subj1.NeedsSoftware.All(i => hesSet.Contains(i)); foreach (Subject s in subjects) { //if (s.NeedsSoftware.Except(toFind).Any()) if (s.NeedsSoftware.All(i => hesSet.Contains(i))) { Console.WriteLine("sadrzi predmet: " + s.Name); retVal.Add(s); } } }
public void GetStudAlreadySubscribedTest() { // ARRANGE /*the commented area is to check if functions returns -1 when there isn't a fos*/ FieldOfStudyService service = new FieldOfStudyService(ctxDb); ApplicationUser user = new ApplicationUser { UserName = "******", Email = "*****@*****.**", GeboorteDatum = new DateTime(1998, 09, 21), Naam = "Claes", VoorNaam = "Thomas", EmailConfirmed = true }; ctxDb.Users.Add(user); ctxDb.SaveChanges(); string userId = ctxDb.Users.Where(u => u.UserName == "r0664186").FirstOrDefault().Id; FieldOfStudy fos = new FieldOfStudy { RichtingCode = "MGP", RichtingTitel = "model graduaat programmeren", Type = "graduaat" }; ctxDb.FieldOfStudy.Add(fos); ctxDb.SaveChanges(); int fosId = ctxDb.FieldOfStudy.Where(fos => fos.RichtingCode == "MGP").FirstOrDefault().Id; Course course = new Course { Vakcode = "MGP01A", Titel = "front end", Studiepunten = 6, FieldOfStudyId = fosId }; ctxDb.Course.Add(course); //Course course1 = new Course { Vakcode = "MBP01A", Titel = "front end", Studiepunten = 8}; //ctxDb.Course.Add(course1); ctxDb.SaveChanges(); int courseId = ctxDb.Course.Where(c => c.Vakcode == "MGP01A").FirstOrDefault().Id; //int course1Id = ctxDb.Course.Where(c => c.Vakcode == "MBP01A").FirstOrDefault().Id; CourseUser cu = new CourseUser { ApplicationUserId = userId, CourseId = courseId }; ctxDb.CourseUser.Add(cu); //CourseUser cu1 = new CourseUser { ApplicationUserId = userId, CourseId = course1Id}; //ctxDb.CourseUser.Add(cu1); ctxDb.SaveChanges(); // ACT int reqFosId = service.GetStudAlreadySubscribed(ctxDb.Users.Find(userId)); // ASSERT Assert.AreEqual(fosId, reqFosId); }
public async Task <IActionResult> Create([Bind("FieldOfStudyId,Name")] FieldOfStudy fieldOfStudy) { if (ModelState.IsValid) { _context.Add(fieldOfStudy); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(fieldOfStudy)); }
public override int GetHashCode() { unchecked { int hashCode = (Title != null ? Title.GetHashCode() : 0); hashCode = (hashCode * 397) ^ (FieldOfStudy != null ? FieldOfStudy.GetHashCode() : 0); hashCode = (hashCode * 397) ^ (YearAwarded.HasValue ? YearAwarded.Value : 0); hashCode = (hashCode * 397) ^ (InstitutionId.HasValue ? InstitutionId.Value : 0); return(hashCode); } }
public void DeleteRichting(int richtindId) { FieldOfStudy field = db.FieldOfStudy.Find(richtindId); if (field == null) { throw new ArgumentException("Deze richting werd niet in de databank gevonden."); } else { db.FieldOfStudy.Remove(field); db.SaveChanges(); } }
public void GetRichtingTest() { // ARRANGE FieldOfStudyService service = new FieldOfStudyService(ctxDb); service.AddRichting("MGP", "Model graduaat programmeren", "Graduaat"); int fosId = ctxDb.FieldOfStudy.Where(fos => fos.RichtingCode == "MGP").FirstOrDefault().Id; // ACT FieldOfStudy fos = service.GetRichting(fosId); // ASSERT Assert.AreEqual("MGP", fos.RichtingCode); Assert.AreEqual("model graduaat programmeren", fos.RichtingTitel); Assert.AreEqual("graduaat", fos.Type); }
public void AddRichting(string code, string titel, string type) { var rInUse = from r in db.FieldOfStudy where r.RichtingCode == code.ToUpper() select r; if (rInUse.Any()) { throw new ArgumentException("Richting met deze code bestaat reeds."); } FieldOfStudy fos = new FieldOfStudy { RichtingCode = code.ToUpper(), RichtingTitel = titel.ToLower(), Type = type.ToLower(), RichtingStudiepunten = 0 }; db.FieldOfStudy.Add(fos); db.SaveChanges(); }
public void Create(LearningOutcomeDocument lod) { FieldOfStudy fieldOfStudy = lod.FieldOfStudy; List <LearningOutcome> learningOutcomes = lod.LearningOutcomes; using (Document doc = PdfHelper.Document(true)) { learningOutcomeTitle(lod, doc); if (fieldOfStudy != null) { fieldOfStudyInfo(fieldOfStudy, doc); } if (learningOutcomes != null) { addLearningOutcomes(learningOutcomes, doc); } } PdfHelper.AddPages(); }
public void TestCreateGetParticipantExchangeVisitorsDTOQuery_CheckProperties() { var project = new Project { ProjectId = 100 }; var participant = new Participant { ParticipantId = 2, ProjectId = project.ProjectId, Project = project }; var fieldOfStudy = new FieldOfStudy { FieldOfStudyId = 3, Description = "field of study", }; var programCategory = new ProgramCategory { ProgramCategoryId = 3, Description = "program category", ProgramCategoryCode = "pccode" }; var position = new Position { PositionId = 4, Description = "position", PositionCode = "positioncode" }; var usGovAgency1 = new USGovernmentAgency { AgencyCode = "usgovcode1", AgencyId = 5, Description = "us gov agency1", }; var usGovAgency2 = new USGovernmentAgency { AgencyCode = "usgovcode2", AgencyId = 6, Description = "us gov agency2", }; var internationalOrg1 = new InternationalOrganization { Description = "int org 1", OrganizationCode = "int org 1 code", OrganizationId = 7, }; var internationalOrg2 = new InternationalOrganization { Description = "int org 2", OrganizationCode = "int org 2 code", OrganizationId = 8, }; var visitor = new ParticipantExchangeVisitor { ParticipantId = participant.ParticipantId, Participant = participant, FieldOfStudy = fieldOfStudy, FieldOfStudyId = fieldOfStudy.FieldOfStudyId, FundingGovtAgency1 = 2.0m, FundingGovtAgency2 = 3.0m, FundingIntlOrg1 = 4.0m, FundingIntlOrg2 = 5.0m, FundingOther = 6.0m, FundingPersonal = 7.0m, FundingSponsor = 8.0m, FundingTotal = 9.0m, FundingVisBNC = 10.0m, FundingVisGovt = 11.0m, GovtAgency1 = usGovAgency1, GovtAgency1Id = usGovAgency1.AgencyId, GovtAgency1OtherName = "other name", GovtAgency2 = usGovAgency2, GovtAgency2Id = usGovAgency2.AgencyId, GovtAgency2OtherName = "other other name", IntlOrg1 = internationalOrg1, IntlOrg1Id = internationalOrg1.OrganizationId, IntlOrg1OtherName = "other other other name", IntlOrg2 = internationalOrg2, IntlOrg2Id = internationalOrg2.OrganizationId, IntlOrg2OtherName = "other name 2", OtherName = "other name again", ProgramCategory = programCategory, ProgramCategoryId = programCategory.ProgramCategoryId, Position = position, PositionId = position.PositionId }; context.Projects.Add(project); context.Participants.Add(participant); context.FieldOfStudies.Add(fieldOfStudy); context.ProgramCategories.Add(programCategory); context.Positions.Add(position); context.ParticipantExchangeVisitors.Add(visitor); context.USGovernmentAgencies.Add(usGovAgency1); context.USGovernmentAgencies.Add(usGovAgency2); context.InternationalOrganizations.Add(internationalOrg1); context.InternationalOrganizations.Add(internationalOrg2); Action <ParticipantExchangeVisitorDTO> tester = (result) => { Assert.AreEqual(project.ProjectId, result.ProjectId); Assert.AreEqual(participant.ParticipantId, result.ParticipantId); Assert.AreEqual(visitor.FundingGovtAgency1, result.FundingGovtAgency1); Assert.AreEqual(visitor.FundingGovtAgency2, result.FundingGovtAgency2); Assert.AreEqual(visitor.FundingIntlOrg1, result.FundingIntlOrg1); Assert.AreEqual(visitor.FundingIntlOrg2, result.FundingIntlOrg2); Assert.AreEqual(visitor.FundingOther, result.FundingOther); Assert.AreEqual(visitor.FundingPersonal, result.FundingPersonal); Assert.AreEqual(visitor.FundingSponsor, result.FundingSponsor); Assert.AreEqual(visitor.FundingTotal, result.FundingTotal); Assert.AreEqual(visitor.FundingVisBNC, result.FundingVisBNC); Assert.AreEqual(visitor.FundingVisGovt, result.FundingVisGovt); Assert.AreEqual(visitor.GovtAgency1OtherName, result.GovtAgency1OtherName); Assert.AreEqual(visitor.GovtAgency2OtherName, result.GovtAgency2OtherName); Assert.AreEqual(visitor.IntlOrg1OtherName, result.IntlOrg1OtherName); Assert.AreEqual(visitor.IntlOrg2OtherName, result.IntlOrg2OtherName); Assert.AreEqual(visitor.OtherName, result.OtherName); Assert.AreEqual(visitor.FieldOfStudyId, result.FieldOfStudyId); Assert.AreEqual(fieldOfStudy.Description, result.FieldOfStudy); Assert.AreEqual(visitor.GovtAgency1Id, result.GovtAgency1Id); Assert.AreEqual(usGovAgency1.Description, result.GovtAgency1Name); Assert.AreEqual(visitor.GovtAgency2Id, result.GovtAgency2Id); Assert.AreEqual(usGovAgency2.Description, result.GovtAgency2Name); Assert.AreEqual(visitor.ProgramCategoryId, result.ProgramCategoryId); Assert.AreEqual(programCategory.Description, result.ProgramCategory); Assert.AreEqual(programCategory.ProgramCategoryCode, result.ProgramCategoryCode); Assert.AreEqual(visitor.IntlOrg1Id, result.IntlOrg1Id); Assert.AreEqual(internationalOrg1.Description, result.IntlOrg1Name); Assert.AreEqual(visitor.IntlOrg2Id, result.IntlOrg2Id); Assert.AreEqual(internationalOrg2.Description, result.IntlOrg2Name); Assert.AreEqual(visitor.PositionId, result.PositionId); Assert.AreEqual(visitor.Position.Description, result.Position); Assert.AreEqual(position.PositionCode, result.PositionCode); }; var queryResult = ParticipantExchangeVisitorQueries.CreateGetParticipantExchangeVisitorsDTOQuery(context).ToList(); Assert.AreEqual(1, queryResult.Count()); tester(queryResult.First()); }
private static void wku(Dictionary <LearningOutcomeCategory, int> lods, Document doc, FieldOfStudy fieldOfStudy) { int w = lods[LearningOutcomeCategory.Knowledge]; int u = lods[LearningOutcomeCategory.Skills]; int k = lods[LearningOutcomeCategory.SocialCompetences]; doc.Add(new Paragraph("2. Opis szczegółowy")); doc.Add(new Paragraph($"2.1 Całkowita liczba efektów uczenia się w programie studiów: W(wiedza)= {w}, U (umiejętności) = {u}, K (kompetencje) = {k}, W + U + K = {w + u + k}")); doc.Add(new Paragraph($"2.2 Dla kierunku studiów przyporządkowanego do więcej niż jednej dyscypliny - liczba efektów uczenia się przypisana do dyscypliny \n\t D1(wiodąca){fieldOfStudy.Discipline}: {w + u + k}")); doc.Add(new Paragraph($"2.3 Dla kierunku studiów przyporządkowanego do więcej niż jednej dyscypliny - procentowy udział liczby punktów ECTS dla każdej z dyscyplin: \n\t D1 100% punktów ECTS")); }
private void InstallApp() { StudyType Ochnaja = new StudyType { Name = "очная" }; StudyType Zaochnaja = new StudyType { Name = "заочная" }; StudyType unnamed3 = new StudyType { Name = "unnamed3" }; StudyType unnamed4 = new StudyType { Name = "unnamed4" }; Faculty IiVT = new Faculty { Name = "Информатика и вычислительная техника", Abbreviation = "ИиВТ", }; FieldOfStudy Specialist = new FieldOfStudy { Name = "специалист" }; FieldOfStudy Bakalavr = new FieldOfStudy { Name = "бакалавр" }; FieldOfStudy Magistr = new FieldOfStudy { Name = "магистр" }; LessonsType Lections = new LessonsType { Id = 1, Name = "лекция" }; LessonsType Practics = new LessonsType { Id = 2, Name = "практика" }; LessonsType Labs = new LessonsType { Id = 3, Name = "лабораторные" }; LessonsSubType Comp = new LessonsSubType { Name = "компьютеры", LessonsTypeId = Labs.Id }; LessonsSubType Stanki = new LessonsSubType { Name = "станки", LessonsTypeId = Labs.Id }; Title prepod = new Title { Name = "преподаватель" }; Faculty fac = new Faculty { Name = "факультет", Abbreviation = "фак" }; Ring first = new Ring { Begin = "8:30", End = "9:50" }; Ring second = new Ring { Begin = "10:00", End = "11:20" }; Ring third = new Ring { Begin = "11:20", End = "12:50" }; Ring fourth = new Ring { Begin = "13:30", End = "14:50" }; Ring fifth = new Ring { Begin = "15:00", End = "16:20" }; Ring sixth = new Ring { Begin = "16:30", End = "17:50" }; Ring seventh = new Ring { Begin = "18:10", End = "19:30" }; Auditorium a = new Auditorium { Building = 1, Number = "1-490", Seats = 50, OpeningDate = "", ClosingDate = "", DepartmentId = 1, }; Degree d = new Degree { Name = "degree", }; using (UniversitySheduleContainer cnt = new UniversitySheduleContainer("name=UniversitySheduleContainer")) { cnt.StudyTypes.AddObject(Ochnaja); cnt.StudyTypes.AddObject(Zaochnaja); cnt.StudyTypes.AddObject(unnamed3); cnt.StudyTypes.AddObject(unnamed4); cnt.Faculties.AddObject(IiVT); cnt.FieldsOfStudy.AddObject(Specialist); cnt.FieldsOfStudy.AddObject(Bakalavr); cnt.FieldsOfStudy.AddObject(Magistr); cnt.LessonsTypes.AddObject(Lections); cnt.LessonsTypes.AddObject(Practics); cnt.LessonsTypes.AddObject(Labs); cnt.LessonsSubTypes.AddObject(Comp); cnt.LessonsSubTypes.AddObject(Stanki); cnt.Titles.AddObject(prepod); cnt.Faculties.AddObject(fac); cnt.Rings.AddObject(first); cnt.Rings.AddObject(second); cnt.Rings.AddObject(third); cnt.Rings.AddObject(fourth); cnt.Rings.AddObject(fifth); cnt.Rings.AddObject(sixth); cnt.Rings.AddObject(seventh); cnt.Degrees.AddObject(d); //cnt.Auditoriums.AddObject(a); // И финальный аккорд - сохраняем все изменения в БД cnt.SaveChanges(); } }