static Accaunt GetAccauntID(LibraryEntities1 context, int accauntID) { Accaunt accaunt = context.Accaunts.FirstOrDefault( p => p.AccauntID == accauntID); return(accaunt); }
private void buttonLogin_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var accaunts = context.Accaunts; bool flag = false; foreach (var item in accaunts) { if (textBoxLogin.Text.Trim() == item.Login.Trim() && CalculateSHA1(textBoxPassword.Text).Trim() == item.PasswordSHA1.Trim()) { flag = true; Menu formMenu = new Menu(0); formMenu.Show(); } if (textBoxLogin.Text.Trim() == "administrator".Trim() && CalculateSHA1(textBoxPassword.Text).Trim() == item.PasswordSHA1.Trim()) { flag = true; Menu formMenu = new Menu(1); formMenu.Show(); } } if (!flag) { MessageBox.Show("Грешка! Невалидна парола!"); InitializeMyControl(); Clear(); } Clear(); }
static void DeleteAccaunt(int accauntID) { LibraryEntities1 context = new LibraryEntities1(); Accaunt accaunt = GetAccauntID(context, accauntID); context.Accaunts .DeleteObject(accaunt); context.SaveChanges(); }
private void FormNewBook_Load(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); dataGridViewAuthors.AutoGenerateColumns = false; dataGridViewAuthors.DataSource = from a in context.Authors orderby a.LName select a; foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows) { row.Selected = false; } //категории - зареждане на комбото var categories = context.Categories; comboBoxCategory.DataSource = categories; comboBoxCategory.ValueMember = "CategoryID"; comboBoxCategory.DisplayMember = "CategoryName"; //зареждане на комбото с език var languages = context.Languages; comboBoxLanguage.DataSource = languages; comboBoxLanguage.ValueMember = "LanguageID"; comboBoxLanguage.DisplayMember = "LanguageName"; }
private void buttonRefresh_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var clients = context.Clients; dataGridViewClients.AutoGenerateColumns = false; dataGridViewClients.DataSource = clients; }
private void buttonSearch_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); if (textBoxAuthor.Text != "") { string lastName = textBoxAuthor.Text; bool flag = false; foreach (DataGridViewRow row in dataGridViewAuthors.Rows) { row.Selected = false; if (row.Cells[2].Value != null && row.Cells[2].Value.ToString() == lastName) { row.Selected = true; flag = true; break; } } if (!flag) { MessageBox.Show("Този автор не съществува в базата!"); } } else { MessageBox.Show("Грешка! Не сте въвели данни за автара!"); } }
static void ModifyBookRejection(int bookID, bool newRejection) { LibraryEntities1 context = new LibraryEntities1(); Book book = GetBookID(context, bookID); book.Rejection = newRejection; context.SaveChanges(); }
private void radioButtonAll_CheckedChanged(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var clients = context.Clients; dataGridViewClients.AutoGenerateColumns = false; dataGridViewClients.DataSource = clients; }
static Book GetBookByInvNumber(LibraryEntities1 context, string invNum) { Book book = context.Books.FirstOrDefault( p => p.InvNum == invNum); return(book); }
private void CurrentClient_Load(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); 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 buttonReturn_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); 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 (ClientsBook cBook in client.ClientsBooks) { if (books.Contains(cBook.BookID)) { cBook.Returned = true; MessageBox.Show("Връщане - успешно!"); } } context.SaveChanges(); } }
private void buttonSearchEGN_Click(object sender, EventArgs e) { string egn = textBox1EGN.Text; LibraryEntities1 context = new LibraryEntities1(); if (egn != "") { Client client = context.Clients.FirstOrDefault( p => p.EGN == egn); textBoxClient.Text = client.ClientID.ToString(); textBoxFName.Text = client.FName.ToString(); textBoxSName.Text = client.SName.ToString(); textBoxLName.Text = client.LName.ToString(); textBoxEGN.Text = client.EGN.ToString(); textBoxAdress.Text = client.Adress.ToString(); textBoxPhone.Text = client.Phone.ToString(); textBoxEmail.Text = client.Email.ToString(); textBoxLeaving.Text = client.Leaving.ToString(); //int genderID= client.GenderID; //comboBoxGender.SelectedValue=genderID } else { MessageBox.Show("Несте въвели ЕГН!"); } }
private void buttonReLoan_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); 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 (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 buttonSearchID_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); if (textBoxClient.Text != "") { int clientID = Int32.Parse(textBoxClient.Text); if (clientID != 0) { Client client = context.Clients.FirstOrDefault( p => p.ClientID == clientID); textBoxFName.Text = client.FName.ToString(); textBoxSName.Text = client.SName.ToString(); textBoxLName.Text = client.LName.ToString(); textBoxEGN.Text = client.EGN.ToString(); textBoxAdress.Text = client.Adress.ToString(); textBoxPhone.Text = client.Phone.ToString(); textBoxEmail.Text = client.Email.ToString(); textBoxLeaving.Text = client.Leaving.ToString(); } } else { MessageBox.Show("Несте въвели читателски номер!"); } }
static Client GetClientByEGN(LibraryEntities1 context, string egn) { Client client = context.Clients.FirstOrDefault( c => c.EGN == egn); return(client); }
static Client GetClientByID(LibraryEntities1 context, int clientID) { Client client = context.Clients.FirstOrDefault( c => c.ClientID == clientID); return(client); }
static Book GetBookByID(LibraryEntities1 context, int bookID) { Book book = context.Books.FirstOrDefault( p => p.BookID == bookID); return(book); }
private void buttonLogin_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var accaunts = context.Accaunts; bool flag = false; foreach (var item in accaunts) { if (textBoxLogin.Text.Trim() == item.Login.Trim() && CalculateSHA1(textBoxPassword.Text).Trim()== item.PasswordSHA1.Trim()) { flag = true; Menu formMenu = new Menu(0); formMenu.Show(); } if (textBoxLogin.Text.Trim() == "administrator".Trim () && CalculateSHA1(textBoxPassword.Text).Trim() == item.PasswordSHA1.Trim()) { flag = true; Menu formMenu = new Menu(1); formMenu.Show(); } } if (!flag) { MessageBox.Show("Грешка! Невалидна парола!"); InitializeMyControl(); Clear(); } Clear(); }
static void DeleteAccaunt(int accauntID) { LibraryEntities1 context = new LibraryEntities1(); Accaunt accaunt = GetAccauntID(context, accauntID); context.Accaunts.DeleteObject(accaunt); context.SaveChanges(); }
private void tabPage2_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var accaunts = context.Accaunts; dataGridViewAccaunt.AutoGenerateColumns = false; dataGridViewAccaunt.DataSource = accaunts; }
private void FormCategories_Load(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var categories = context.Categories ; dataGridViewCategories.AutoGenerateColumns = false; dataGridViewCategories.DataSource = categories; buttonAdd.Enabled = false; }
private void buttonNew_Click(object sender, EventArgs e) { NewClient cl = new NewClient(); cl.Show(); LibraryEntities1 context = new LibraryEntities1(); var clients = context.Clients; dataGridViewClients.AutoGenerateColumns = false; dataGridViewClients.DataSource = clients; }
private void FormCategories_Load(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var categories = context.Categories; dataGridViewCategories.AutoGenerateColumns = false; dataGridViewCategories.DataSource = categories; buttonAdd.Enabled = false; }
private void tabControl1_Selecting(object sender, TabControlCancelEventArgs e) { textBoxLogin.Focus(); LibraryEntities1 context = new LibraryEntities1(); var accaunts = context.Accaunts; dataGridViewAccaunt.AutoGenerateColumns = false; dataGridViewAccaunt.DataSource = accaunts; }
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { string egn = textBoxEGN.Text; LibraryEntities1 context = new LibraryEntities1(); Client cl = context.Clients.FirstOrDefault( p => p.EGN == egn); string s = "Училищна библиотека\nЧитателска карта\n\n" + "Име: " + cl.FName + " " + cl.LName + "\n" + "Читателски номер: " + cl.ClientID; e.Graphics.DrawString(s, textBoxFName.Font, new SolidBrush(Color.Black), new Point(50, 50)); }
private void radioButtonLate_CheckedChanged(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var cBooks = context.ClientsBooks.ToList().FindAll(c => c.DateLoaned.AddMonths(1) < DateTime.Now); var clients = context.Clients.ToList(); var dataSource = clients.FindAll(c => cBooks.Exists(cb => cb.ClientID == c.ClientID)); dataGridViewClients.AutoGenerateColumns = false; dataGridViewClients.DataSource = dataSource; }
private void radioButtonRejected_CheckedChanged(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); 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) { LibraryEntities1 context = new LibraryEntities1(); 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 radioButtonReserved_CheckedChanged(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var clients = from clientbook in context.ClientsBooks join client in context.Clients on clientbook.ClientID equals client.ClientID where clientbook.Reservation == true select client; dataGridViewClients.AutoGenerateColumns = false; dataGridViewClients.DataSource = clients; }
private void buttonAdd_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); //създаваме нова книга чрез конструктора Books() try { if (textBoxInvNum.Text != "" && textBoxTitle.Text != "") { Book newBook = new Book(); //на съответните полета присвояваме стойностите от текстовите кутии newBook.InvNum = textBoxInvNum.Text; newBook.ISBN = textBoxISBN.Text; newBook.Title = textBoxTitle.Text; newBook.Description = textBoxDescription.Text; newBook.YearPub = Int32.Parse(textBoxYearPubl.Text); newBook.Price = Decimal.Parse(textBoxPrice.Text); newBook.Rejection = false; newBook.CategoryID = Int32.Parse(comboBoxCategory.SelectedValue.ToString()); newBook.LanguageID = Int32.Parse(comboBoxLanguage.SelectedValue.ToString()); // обработка на селектираните редове от DataGridViewAuthors - това са авторите на новата книга int authorID;//локална променлива foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows) { authorID = Convert.ToInt32(row.Cells[0].Value);//вземаме стойността Value на ID на автора от текущо селектирания ред - row.Cells[0].Value //добавяне на данните за автора към свойството Authors на книгата, която обработваме //свойството не е просто свойство, а е списък (List) от автори newBook.Authors.Add(context.Authors.ToList().Find(a => a.AuthorID == authorID)); } //добавяне на новата книга в базата и записване на промените context.Books.AddObject(newBook); context.SaveChanges(); MessageBox.Show("Книгата е добавена!"); } else { MessageBox.Show("Грешка! Не сте въвели данни."); } } catch (FormatException) { MessageBox.Show("Вие не сте въвели данни! " + "Книгата не е добавена!"); } if (MessageBox.Show("Ще въвеждате ли други книги?", "Добавяне на книга", MessageBoxButtons.YesNo) == DialogResult.No) { this.Close(); } else { Clear(); } }
private void radioButtonNotReturned_CheckedChanged(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var clients = (from client in context.Clients join clientbook in context.ClientsBooks on client.ClientID equals clientbook.ClientID join book in context.Books on clientbook.BookID equals book.BookID where clientbook.Returned == false select client).Distinct(); dataGridViewClients.AutoGenerateColumns = false; dataGridViewClients.DataSource = clients; }
private void buttonRefresh_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); dataGridViewAuthors.AutoGenerateColumns = false; dataGridViewAuthors.DataSource = from a in context.Authors orderby a.LName select a; foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows) { row.Selected = false; } }
private void buttonRefresh_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); 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 FormEditClient_Load(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); var status = context.Statys; comboBoxStatus.DataSource = status; comboBoxStatus.ValueMember = "StatusID"; comboBoxStatus.DisplayMember = "Status"; var gender = context.Genders; comboBoxGender.DataSource = gender; comboBoxGender.ValueMember = "GenderID"; comboBoxGender.DisplayMember = "Gender1"; }
private void buttonRefresh_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); 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 buttonAdd_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); Accaunt newAccaunt = new Accaunt() { Login = textBoxLogin.Text.Trim(), PasswordSHA1 =CalculateSHA1(textBoxLogin.Text).Trim(), FirstName = textBoxFName.Text.Trim(), LastName = textBoxLName.Text.Trim() }; context.Accaunts.AddObject(newAccaunt); context.SaveChanges(); MessageBox.Show("Добавянето е успешно."); Clear(); }
private void buttonAdd_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); if (textBoxLName.Text!="") { Author newAuthor = new Author() { FName = textBoxFName.Text, LName = textBoxLName.Text }; context.Authors.AddObject(newAuthor); context.SaveChanges(); MessageBox.Show("Авторът е добавен."); } else MessageBox.Show("Грешка! Няма въведени данни."); }
private void buttonRejection_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); bool вooksRejection = false; foreach (DataGridViewRow item in dataGridViewBooks.Rows) { if (item.Cells[3].Value != null) { int bookID = Convert.ToInt32(item.Cells[3].Value); ModifyBookRejection(bookID, true); вooksRejection = true; } } if (вooksRejection) { MessageBox.Show("Отчисляването е успешно!"); } else MessageBox.Show("Грешка! Няма въведени данни!"); }
private void dataGridViewBooks_RowLeave(object sender, DataGridViewCellEventArgs e) { LibraryEntities1 context = new LibraryEntities1(); //взема инв.№, въведен в клетката if (dataGridViewBooks.CurrentRow.Cells[0].Value != null) { string bookInvNumber = dataGridViewBooks.CurrentRow.Cells[0].Value.ToString(); //намираме книга по този инв.№ Book book = GetBookByInvNumber(context, bookInvNumber); if (book != null) { dataGridViewBooks.CurrentRow.Cells[1].Value = book.Title.ToString(); dataGridViewBooks.CurrentRow.Cells[2].Value = book.Rejection; dataGridViewBooks.CurrentRow.Cells[3].Value = book.BookID; } else { MessageBox.Show("Грешен инвентарен номер! Книгата не е намерена."); } } }
private void buttonAdd_Click(object sender, EventArgs e) { int i = dataGridViewLanguages.CurrentRow.Index; int LanguageID = (int)dataGridViewLanguages.Rows[i].Cells[0].Value; string lang = dataGridViewLanguages.Rows[i].Cells[1].Value.ToString(); LibraryEntities1 context = new LibraryEntities1(); if(LanguageID!=0) { Language newLanguage = new Language() { LanguageName = lang }; context.Languages.AddObject(newLanguage); context.SaveChanges(); MessageBox.Show("Добавен е език!"); buttonAdd.Enabled = false; } else { MessageBox.Show("Грешка! Не сте въвели език."); this.Close(); } }
private void buttonAdd_Click(object sender, EventArgs e) { int i = dataGridViewCategories.CurrentRow.Index; int categoryID = (int)dataGridViewCategories.Rows[i].Cells[0].Value; string category = dataGridViewCategories.Rows[i].Cells[1].Value.ToString(); LibraryEntities1 context = new LibraryEntities1(); if (categoryID != 0) { Category newCategory = new Category() { CategoryName = category }; context.Categories.AddObject(newCategory); context.SaveChanges(); MessageBox.Show("Категорията е добавена!"); buttonAdd.Enabled = false; } else { MessageBox.Show("Грешка! Не сте въвели категория."); this.Close(); } }
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("Грешка! Няма въведени данни!"); }
private void buttonFind_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); if (radioButtonID.Checked) { if (textBoxFind.Text != "") { int find = int.Parse(textBoxFind.Text); Client cl = context.Clients.FirstOrDefault( p => p.ClientID == find); if (cl != null) { FormReturn fR = new FormReturn(cl.ClientID); fR.Show(); this.Close(); } else MessageBox.Show("Няма читател с този читателски номер!"); } else MessageBox.Show("Грешка!Няма въведени данни."); } else { if (textBoxFind.Text == "") { MessageBox.Show("Грешка!Няма въведени данни."); } else { string egn = textBoxFind.Text; decimal idValue; int[] digits = null; bool flag = true; if (!string.IsNullOrEmpty(egn)) { if (decimal.TryParse(egn, out idValue)) { digits = (from d in egn.ToCharArray() select Convert.ToInt32(d.ToString())).ToArray(); if (digits.Length != 10 || !ValidateEGN(egn, digits)) flag = false; } else flag = false; } if (!flag) { MessageBox.Show("Грешно ЕГН!!!"); textBoxFind.Clear(); textBoxFind.Focus(); } else { Client cl = context.Clients.FirstOrDefault( p => p.EGN == egn); FormReturn fR = new FormReturn(cl.ClientID); fR.Show(); this.Close(); } } } }
static Accaunt GetAccauntID(LibraryEntities1 context, int accauntID) { Accaunt accaunt = context.Accaunts.FirstOrDefault( p => p.AccauntID == accauntID); return accaunt; }
private void buttonSearch_Click(object sender, EventArgs e) { LibraryEntities1 context = new LibraryEntities1(); if (textBoxAuthor.Text != "") { string lastName = textBoxAuthor.Text; bool flag = false; foreach (DataGridViewRow row in dataGridViewAuthors.Rows) { row.Selected = false; if (row.Cells[2].Value != null && row.Cells[2].Value.ToString() == lastName) { row.Selected = true; flag = true; break; } } if (!flag) { MessageBox.Show("Този автор не съществува в базата!"); } } else MessageBox.Show("Грешка! Не сте въвели данни за автара!"); }
static Book GetBookByID(LibraryEntities1 context, int bookID) { Book book = context.Books.FirstOrDefault( p => p.BookID == bookID); return book; }