private void buttonNew_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var client = (from c in context.Clients
where c.ClientID == clientId
select c).SingleOrDefault();
bool hasBooks = false;
foreach (DataGridViewRow item in dataGridViewLoaned.Rows)
{
if (item.Cells[4].Value != null)
{
int bookID = Convert.ToInt32(item.Cells[4].Value);
DateTime dateL = Convert.ToDateTime(item.Cells[2].Value);
DateTime dateR = Convert.ToDateTime(item.Cells[3].Value);
ClientsBook cBook = new ClientsBook();
cBook.BookID = bookID;
cBook.ClientID = client.ClientID;
cBook.DateLoaned = dateL;
cBook.DateReturned = dateR;
client.ClientsBooks.Add(cBook);
hasBooks = true;
}
}
if (hasBooks)
{
context.SaveChanges();
MessageBox.Show("Книгите са записани - заети!");
}
else MessageBox.Show("Грешка! Няма въведени данни!");
}
/// <summary>
/// Deprecated Method for adding a new object to the ClientsBooks EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToClientsBooks(ClientsBook clientsBook)
{
base.AddObject("ClientsBooks", clientsBook);
}
/// <summary>
/// Create a new ClientsBook object.
/// </summary>
/// <param name="clientID">Initial value of the ClientID property.</param>
/// <param name="bookID">Initial value of the BookID property.</param>
/// <param name="dateLoaned">Initial value of the DateLoaned property.</param>
/// <param name="dateReturned">Initial value of the DateReturned property.</param>
/// <param name="returned">Initial value of the Returned property.</param>
/// <param name="reservation">Initial value of the Reservation property.</param>
public static ClientsBook CreateClientsBook(global::System.Int32 clientID, global::System.Int32 bookID, global::System.DateTime dateLoaned, global::System.DateTime dateReturned, global::System.Boolean returned, global::System.Boolean reservation)
{
ClientsBook clientsBook = new ClientsBook();
clientsBook.ClientID = clientID;
clientsBook.BookID = bookID;
clientsBook.DateLoaned = dateLoaned;
clientsBook.DateReturned = dateReturned;
clientsBook.Returned = returned;
clientsBook.Reservation = reservation;
return clientsBook;
}
