public static DbAuthor FillBlanks(Gender gender)
{
var p = NewPerson.FillBlanks(gender);
var b = new DbAuthor(p.First, p.Last, p.Patronimic, (eWriterType)NewValue.Int(2));
All.Add(b);
return(b);
}
public WindowAddEditUserAuthor(Window Owner, DbAuthor author) : this(Owner, false)
{
GroupBox.Visibility = Visibility.Collapsed;
Author = author;
isReader = false;
Last.Text = Author.Last;
First.Text = Author.First;
Patronimic.Text = Author.Patronimic;
AuthorRole.SelectedIndex = Author.WriterType;
}
private void Accept_OnClick(object sender, RoutedEventArgs e)
{
Hide();
if (Reader == null && Author == null)
{
using (var db = new LibraryDBContainer())
{
if (isReader)
{
Reader = IsStudent
? new DbReader(First.Text, Last.Text, Patronimic.Text, GroupBox.Text)
: new DbReader(First.Text, Last.Text, Patronimic.Text);
db.DbReaderSet.Add(Reader);
}
else
{
Author = new DbAuthor(First.Text, Last.Text, Patronimic.Text,
(eWriterType)AuthorRole.SelectedIndex);
db.DbAuthorSet1.Add(Author);
}
db.SaveChanges();
}
}
else
{
using (var db = new LibraryDBContainer())
{
if (isReader)
{
Reader = db.DbReaderSet.Find(Reader.Id);
Reader.AccessLevel = (byte)UserRole.SelectedIndex;
Reader.Last = Last.Text;
Reader.First = First.Text;
Reader.Patronimic = Patronimic.Text;
Reader.Group = GroupBox.Text;
}
else
{
Author = db.DbAuthorSet1.Find(Author.Id);
Author.Last = Last.Text;
Author.First = First.Text;
Author.Patronimic = Patronimic.Text;
Author.WriterType = (byte)AuthorRole.SelectedIndex;
}
db.SaveChanges();
}
}
Close();
}
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();
}
public DbPublication(string Name, DbAuthor Author, ePublicationType PublicationType, eBookPublication BookPublication, DateTime DatePublished, string Publisher) :
this(Name, PublicationType, BookPublication, DatePublished, Publisher)
{
Authors = new [] { Author };
}
