public void Add()
{
var le = new LibraryEntities();
var ath = new Author();
var lib = new Librar();
var name = MediatorLoadBook.GetName();
var surname = MediatorLoadBook.GetSurname();
var bk = new Books
{
NameBook = Mediator.MediatorAddBook.GetNameBook(),
Gener = Mediator.MediatorAddBook.GetGenre(),
Year = Mediator.MediatorAddBook.GetDate()
};
var NomberShelf = Mediator.MediatorAddBook.GetShelf();
var NomberCupboard = Mediator.MediatorAddBook.GetCupboatd();
ath = le.Author.FirstOrDefault(x => x.Name == name && x.Surname == surname);
bk.id_Author = ath.id;
var c = le.Librar.FirstOrDefault(x => x.NomberCupboard == lib.NomberCupboard && x.NomberShelf == lib.NomberShelf);
if (c == null)
{
le.Librar.Add(lib);
lib = le.Librar.FirstOrDefault(x => x.NomberCupboard == NomberCupboard && x.NomberShelf == NomberShelf);
bk.id_Librar = lib.id;
le.SaveChanges();
}
else
{
bk.id_Librar = c.id;
le.SaveChanges();
}
le.Books.Add(bk);
le.SaveChanges();
}
private void AddAuth_Click(object sender, EventArgs e)
{
try
{
LibraryEntities le = new LibraryEntities();
var ath = new Author
{
Name = this.textBox1.Text.ToString(),
Surname = this.textBox2.Text.ToString()
};
le.Author.Add(ath);
le.SaveChanges();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
