private void buttonReLoan_Click(object sender, EventArgs e) { LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities(); List<int> books = new List<int>(); foreach (DataGridViewRow row in dataGridViewLoaned.SelectedRows) { if (row.Cells[0].Value != null) { books.Add(Convert.ToInt32(row.Cells[0].Value)); } } if (books.Count > 0) { var client = (from c in context.Clients where c.ClientID == id select c).SingleOrDefault(); foreach (LibraryReader.ClientsBook cBook in client.ClientsBooks) { if (books.Contains(cBook.BookID)) { cBook.DateLoaned = DateTime.Now; cBook.DateReturned = DateTime.Now.AddMonths(1); MessageBox.Show("Презаписването е успешно!"); } } context.SaveChanges(); } }
private void buttonReLoan_Click(object sender, EventArgs e) { LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities(); List <int> books = new List <int>(); foreach (DataGridViewRow row in dataGridViewLoaned.SelectedRows) { if (row.Cells[0].Value != null) { books.Add(Convert.ToInt32(row.Cells[0].Value)); } } if (books.Count > 0) { var client = (from c in context.Clients where c.ClientID == id select c).SingleOrDefault(); foreach (LibraryReader.ClientsBook cBook in client.ClientsBooks) { if (books.Contains(cBook.BookID)) { cBook.DateLoaned = DateTime.Now; cBook.DateReturned = DateTime.Now.AddMonths(1); MessageBox.Show("Презаписването е успешно!"); } } context.SaveChanges(); } }
private void buttonReserve_Click(object sender, EventArgs e) { LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities(); List<int> books = new List<int>(); foreach (DataGridViewRow row in dataGridViewBooks.SelectedRows) { if (row.Cells[0].Value != null) { books.Add(Convert.ToInt32(row.Cells[0].Value)); } } if (books.Count > 0) { var client = (from c in context.Clients where c.ClientID == id select c).SingleOrDefault(); foreach (LibraryReader.ClientsBook cBook in client.ClientsBooks) { if (books.Contains(cBook.BookID)) { cBook.Reservation = true; MessageBox.Show("Резервирането е успешно!"); } } context.SaveChanges(); } }
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; } }
private void buttonReserve_Click(object sender, EventArgs e) { LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities(); List <int> books = new List <int>(); foreach (DataGridViewRow row in dataGridViewBooks.SelectedRows) { if (row.Cells[0].Value != null) { books.Add(Convert.ToInt32(row.Cells[0].Value)); } } if (books.Count > 0) { var client = (from c in context.Clients where c.ClientID == id select c).SingleOrDefault(); foreach (LibraryReader.ClientsBook cBook in client.ClientsBooks) { if (books.Contains(cBook.BookID)) { cBook.Reservation = true; MessageBox.Show("Резервирането е успешно!"); } } context.SaveChanges(); } }
private void buttonRefresh_Click(object sender, EventArgs e) { LibraryReader.LibraryEntities context = new LibraryReader.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 == false) && (cl.Reservation == false) select book; if (books!=null ) { dataGridViewLoaned.AutoGenerateColumns = false; dataGridViewLoaned.DataSource = books; } }
private void buttonRefresh_Click(object sender, EventArgs e) { LibraryReader.LibraryEntities context = new LibraryReader.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 == false) && (cl.Reservation == false) select book; if (books != null) { dataGridViewLoaned.AutoGenerateColumns = false; dataGridViewLoaned.DataSource = books; } }
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; } }
private void buttonSearch_Click(object sender, EventArgs e) { if (id == 0) buttonReserve.Visible = false; if (al == 0) { LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities(); if (comboBoxSearch.SelectedItem.ToString().Trim() == "Автор") { string authorLName = textBoxSearch.Text.Trim(); LibraryReader.Author author = context.Authors.FirstOrDefault(p => p.LName == authorLName); if (author != null) { var books = context.Books.ToList(); var datasource = (from b in books where b.Authors.Contains(author) select b).ToList(); dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = datasource; } else { MessageBox.Show("Грешка! Няма автор с това име!"); } } else if (comboBoxSearch.SelectedItem.ToString().Trim() == "Заглавие") { var books = from book in context.Books where book.Title.Trim() == textBoxSearch.Text.Trim() select book; if (books != null) { dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = books; } else { MessageBox.Show("Грешка! Няма книга с това заглавие!"); } } else if (comboBoxSearch.SelectedItem.ToString().Trim() == "Инвентарен номер") { var books = from book in context.Books where book.InvNum.Trim() == textBoxSearch.Text.Trim() select book; if (books != null) { dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = books; } else { MessageBox.Show("Грешка! Няма книга с този инвентарен номер!"); } } else if (comboBoxSearch.SelectedItem.ToString().Trim() == "ISBN") { var books = from book in context.Books where book.ISBN.Trim() == textBoxSearch.Text.Trim() select book; if (books != null) { dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = books; } else { MessageBox.Show("Грешка! Няма книга с този ISBN!"); } } } }
static LibraryReader.Client GetClientByID(LibraryReader.LibraryEntities context, int clientID) { LibraryReader.Client cl = context.Clients.FirstOrDefault( p => p.ClientID == clientID); return(cl); }
private void buttonSearch_Click(object sender, EventArgs e) { if (id == 0) { buttonReserve.Visible = false; } if (al == 0) { LibraryReader.LibraryEntities context = new LibraryReader.LibraryEntities(); if (comboBoxSearch.SelectedItem.ToString().Trim() == "Автор") { string authorLName = textBoxSearch.Text.Trim(); LibraryReader.Author author = context.Authors.FirstOrDefault(p => p.LName == authorLName); if (author != null) { var books = context.Books.ToList(); var datasource = (from b in books where b.Authors.Contains(author) select b).ToList(); dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = datasource; } else { MessageBox.Show("Грешка! Няма автор с това име!"); } } else if (comboBoxSearch.SelectedItem.ToString().Trim() == "Заглавие") { var books = from book in context.Books where book.Title.Trim() == textBoxSearch.Text.Trim() select book; if (books != null) { dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = books; } else { MessageBox.Show("Грешка! Няма книга с това заглавие!"); } } else if (comboBoxSearch.SelectedItem.ToString().Trim() == "Инвентарен номер") { var books = from book in context.Books where book.InvNum.Trim() == textBoxSearch.Text.Trim() select book; if (books != null) { dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = books; } else { MessageBox.Show("Грешка! Няма книга с този инвентарен номер!"); } } else if (comboBoxSearch.SelectedItem.ToString().Trim() == "ISBN") { var books = from book in context.Books where book.ISBN.Trim() == textBoxSearch.Text.Trim() select book; if (books != null) { dataGridViewBooks.AutoGenerateColumns = false; dataGridViewBooks.DataSource = books; } else { MessageBox.Show("Грешка! Няма книга с този ISBN!"); } } } }