private void CurrentClient_Load(object sender, EventArgs e)
{
LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities();
LibraryReader.Client clients = GetClientByID(context, id);
textBoxFName.Text = clients.FName;
textBoxSName.Text = clients.SName;
textBoxLName.Text = clients.LName;
textBoxEGN.Text = clients.EGN;
textBoxAdress.Text = clients.Adress;
textBoxPhone.Text = clients.Phone;
textBoxEmail.Text = clients.Email;
textBoxLeaving.Text = clients.Leaving.ToString();;
var books =
from cl in context.ClientsBooks
join book in context.Books on cl.BookID equals book.BookID
where (cl.ClientID == id) && (cl.Returned == false) && (cl.Reservation == false)
select book;
if (books != null)
{
dataGridViewLoaned.AutoGenerateColumns = false;
dataGridViewLoaned.DataSource = books;
}
}
static LibraryReader.Client GetClientByID(LibraryReader.LibraryEntities context, int clientID)
{
LibraryReader.Client cl = context.Clients.FirstOrDefault(
p => p.ClientID == clientID);
return(cl);
}
