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();
}
}
