private void buttonEnter_Click(object sender, EventArgs e)
{
LibraryEntities context = new LibraryEntities();
var clients = context.Clients;
bool flag = false;
foreach (var item in clients)
{
if (int.Parse(textBoxID.Text) == item.ClientID && textBoxEGN.Text.Trim() == item.EGN.Trim())
{
flag = true;
}
}
if (flag == true)
{
Menu menu = new Menu(int.Parse(textBoxID.Text));
menu.Show();
InitializeMyControl();
Clear();
}
else
{
MessageBox.Show("Грешка! Невалидна парола!");
InitializeMyControl();
Clear();
}
}
private void radioButtonRejected_CheckedChanged(object sender, EventArgs e)
{
LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities();
var books =
from book in context.Books
where book.Rejection == true
select book;
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}
private void radioButtonBooked_CheckedChanged(object sender, EventArgs e)
{
LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities();
var books =
from clientbook in context.ClientsBooks
join book in context.Books on clientbook.BookID equals book.BookID
where (clientbook.Reservation == true) && (book.Rejection == false)
select book;
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}
private void FormReturned_Load(object sender, EventArgs e)
{
LibraryEntities context = new LibraryEntities();
var books =
from cl in context.ClientsBooks
join book in context.Books on cl.BookID equals book.BookID
where (cl.ClientID == id) && (cl.Returned == true) && (cl.Reservation == false)
select book;
if (books != null)
{
dataGridViewReturned.AutoGenerateColumns = false;
dataGridViewReturned.DataSource = books;
}
}
private void radioButtonAvailable_CheckedChanged(object sender, EventArgs e)
{
LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities();
var booksTaken =
from clientbook in context.ClientsBooks
join book in context.Books on clientbook.BookID equals book.BookID
where (clientbook.Returned == false) && (book.Rejection == false)
select book;
var books = context.Books.Except(booksTaken);
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}
private void radioButtonAll_CheckedChanged(object sender, EventArgs e)
{
LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities();
var books =
from book in context.Books
where book.Rejection == false
select book;
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}