public DbBookLocation(DbReader Reader)
{
this.Reader = Reader;
}
private void Test_OnClick(object sender, RoutedEventArgs e)
{
using (var db = new LibraryDBContainer())
{
for (int i = 0; i < 6; i++)
{
db.DbAuthorSet1.Add(DbAuthor.FillBlanks());
}
for (int i = 0; i < 10; i++)
{
db.DbReaderSet.Add(DbReader.FillBlanks());
}
var courses = new[]
{
new DbCourse {
Id = 1, Course = 1
},
new DbCourse {
Id = 2, Course = 2
},
new DbCourse {
Id = 3, Course = 3
},
new DbCourse {
Id = 4, Course = 4
},
};
foreach (var t in courses)
{
db.DbCourseSet.Add(t);
}
var disciplines = new[]
{
new DbDiscipline
{
Id = 1,
Name = "Программирование",
},
new DbDiscipline
{
Id = 2,
Name = "Конструирование ПО",
},
new DbDiscipline
{
Id = 3,
Name = "НИС",
}
};
foreach (var t in disciplines)
{
db.DbDisciplineSet.Add(t);
}
var publications = new[]
{
new DbPublication("Принципы программирования",
db.DbAuthorSet1.Local[2],
ePublicationType.None,
eBookPublication.Book,
new DateTime(1985, 4, 1),
"Росмэн")
{
Id = 1,
Course = new []
{
courses[0],
courses[1]
},
Discipline = new []
{
disciplines[0]
}
},
new DbPublication("Справочник по C#",
new[]
{
db.DbAuthorSet1.Local[1],
db.DbAuthorSet1.Local[2]
},
ePublicationType.None,
eBookPublication.Book,
new DateTime(2011, 6, 1),
"Справочники")
{
Id = 3,
Course = new []
{
courses[0],
},
Discipline = new []
{
disciplines[0],
}
},
new DbPublication("Pascal.NET programming guide",
new[]
{
db.DbAuthorSet1.Local[2],
db.DbAuthorSet1.Local[3]
},
ePublicationType.Educational,
eBookPublication.Publication,
new DateTime(2001, 8, 1),
"Питер")
{
Id = 2,
Course = new []
{
courses[1],
courses[3]
},
Discipline = new []
{
disciplines[0],
disciplines[1]
}
},
new DbPublication("Как писать божественный код",
db.DbAuthorSet1.Local[5],
ePublicationType.Scientific,
eBookPublication.Publication,
new DateTime(2018, 3, 1),
null)
{
Id = 6,
InternetLocation = "https://youtube.com/",
Course = new []
{
courses[2],
courses[3]
},
Discipline = new []
{
disciplines[0],
}
},
new DbPublication("Почему Perl 6 - лучший язык программирования",
new[]
{
db.DbAuthorSet1.Local[3],
db.DbAuthorSet1.Local[4],
},
ePublicationType.Educational,
eBookPublication.Publication,
new DateTime(2015, 1, 1), null)
{
Id = 4,
InternetLocation = "https://google.com/",
Course = new []
{
courses[1],
courses[2]
},
Discipline = new []
{
disciplines[1],
}
},
new DbPublication("Где учиться на программиста",
db.DbAuthorSet1.Local[5],
ePublicationType.Educational,
eBookPublication.Publication,
new DateTime(2016, 11, 1),
null)
{
Id = 5,
InternetLocation = "https://wikipedia.org/",
Course = new []
{
courses[1],
courses[3],
},
Discipline = new []
{
disciplines[2],
}
},
};
foreach (var t in publications)
{
db.DbPublicationSet1.Add(t);
}
var locations = new[]
{
new DbBookLocation
{
Id = 1,
Room = 307,
Place = "здесь",
IsTaken = true,
Reader = db.DbReaderSet.Local[2],
Publication = db.DbPublicationSet1.Local[2]
},
new DbBookLocation
{
Id = 2,
Room = 321,
Place = "где-то была",
IsTaken = false,
Publication = db.DbPublicationSet1.Local[2]
},
new DbBookLocation
{
Id = 3,
Room = 501,
Place = "в столе",
IsTaken = true,
Reader = db.DbReaderSet.Local[1],
Publication = db.DbPublicationSet1.Local[1]
},
new DbBookLocation
{
Id = 4,
Room = 321,
Place = "на верхней полке шкафа",
IsTaken = false,
Publication = db.DbPublicationSet1.Local[2]
},
new DbBookLocation
{
Id = 5,
Room = 318,
Place = "в правом шкафу слева",
IsTaken = false,
Publication = db.DbPublicationSet1.Local[0]
},
new DbBookLocation
{
Id = 6,
Room = 302,
Place = "на столе",
IsTaken = false,
Publication = db.DbPublicationSet1.Local[1]
},
new DbBookLocation
{
Id = 7,
Room = 323,
Place = "под потолком",
IsTaken = false,
Publication = db.DbPublicationSet1.Local[0]
},
};
foreach (var t in locations)
{
db.DbBookLocationSet.Add(t);
}
var stats = new[]
{
new DbStats {
Id = 1, DateTaken = new DateTime(2016, 01, 09), Publication = db.DbPublicationSet1.Local[2]
},
new DbStats {
Id = 2, DateTaken = new DateTime(2017, 06, 10), Publication = db.DbPublicationSet1.Local[2]
},
new DbStats {
Id = 3, DateTaken = new DateTime(2017, 11, 15), Publication = db.DbPublicationSet1.Local[1]
},
new DbStats {
Id = 4, DateTaken = new DateTime(2018, 08, 20), Publication = db.DbPublicationSet1.Local[1]
},
new DbStats {
Id = 5, DateTaken = new DateTime(2018, 03, 01), Publication = db.DbPublicationSet1.Local[2]
},
};
foreach (var t in stats)
{
db.DbStatsSet.Add(t);
}
db.SaveChanges();
}
pPublications.UpdateLayout();
pUsers.UpdateLayout();
pAuthors.UpdateLayout();
}
