private void button2_Click(object sender, EventArgs e) { using (var db = new BibliotecaEntities()) { var book = new Book(); book.Titlu = titluBox.Text; book.ISBN = isbnBox.Text; book.Exemplare = Int32.Parse(exemBox.Text); book.Descriere = descriereBox.Text; var domeniu_text = domain_combo.SelectedItem.ToString(); var autor_text = autor_combo.SelectedItem.ToString(); var editura_text = publisher_combo.SelectedItem.ToString(); var domeniu = (from d in db.Domains where d.Nume == domeniu_text select d).FirstOrDefault(); book.Domain = domeniu; var autor = (from a in db.Authors where a.Nume == autor_text select a).FirstOrDefault(); book.Author = autor; var editura = (from p in db.Publishers where p.Nume == editura_text select p).FirstOrDefault(); book.Publisher = editura; db.Books.Add(book); db.SaveChanges(); this.Close(); MessageBox.Show("Carte creata cu success!"); } }
private void button2_Click(object sender, EventArgs e) { using (var db = new BibliotecaEntities()) { var imprumut = new Lend(); var titlu = carte_combo.SelectedItem.ToString(); var nume = membru_combo.SelectedItem.ToString().Split().FirstOrDefault(); var result = (from b in db.Books where b.Titlu == titlu select b).SingleOrDefault(); if (result.Exemplare == 0) { MessageBox.Show("Nu mai sunt carti disponibile "); return; } result.Exemplare = result.Exemplare - 1; imprumut.Book = result; var result2 = (from d in db.People where d.Nume == nume select d).SingleOrDefault(); imprumut.Person = result2; imprumut.Data_Imprumut = DateTime.Now; imprumut.Data_Retur = DateTime.Now.AddDays(30); imprumut.Stare_Imprumut = 1; db.Lends.Add(imprumut); db.SaveChanges(); MessageBox.Show("Imprumut adaugat cu success!"); } }
private void button1_Click(object sender, EventArgs e) { try { using (var db = new BibliotecaEntities()) { var user = new Person(); user.Utilizator = username.Text; user.Parola = PasswordHash.GetHashString(password.Text); // aici pentru securitate user.Nume = name.Text; user.Prenume = last_name.Text; user.CNP = cnp.Text; user.Telefon = phone.Text; user.Email = email.Text; user.Rol = 1; user.Role = db.Roles.Where(r => r.ID == 1).First(); db.People.Add(user); db.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } this.Close(); var login = new Form1(); login.Show(); }
private void button1_Click(object sender, EventArgs e) { try { using (var db = new BibliotecaEntities()) { if (String.IsNullOrEmpty(username.Text) || String.IsNullOrEmpty(password.Text) || String.IsNullOrEmpty(cnp.Text) || String.IsNullOrEmpty(name.Text) || String.IsNullOrEmpty(last_name.Text)) { MessageBox.Show("Va rugam completati campurile marcate cu (*)."); } else { String checked_username = (from b in db.People where b.Utilizator == username.Text select b.Utilizator).FirstOrDefault(); if (String.IsNullOrEmpty(checked_username) == false) { MessageBox.Show("Username existent in baza de date. Va rugam incercati din nou."); } else { var user = new Person(); user.Utilizator = username.Text; user.Parola = PasswordHash.GetHashString(password.Text); // aici pentru securitate user.Nume = name.Text; user.Prenume = last_name.Text; user.CNP = cnp.Text; user.Telefon = phone.Text; user.Email = email.Text; user.Role = db.Roles.Where(r => r.ID == 1).First(); db.People.Add(user); db.SaveChanges(); MessageBox.Show("Cont creat cu succes."); this.Close(); var login = new Form1(); login.Show(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button_update_Click(object sender, EventArgs e) { try { using (var db = new BibliotecaEntities()) { if (String.IsNullOrEmpty(textBox2.Text) || String.IsNullOrEmpty(textBox1.Text) || String.IsNullOrEmpty(textBox_nume_membru.Text)) { MessageBox.Show("Un camp este necompletat. Va rugam sa introduceti toate datele necesare si sa incercati din nou."); } else { String titlu = textBox1.Text; String member_name = textBox_nume_membru.Text; DateTime enteredDate = DateTime.Parse(textBox2.Text); int book_id = (from b in db.Books where b.Titlu == titlu select b.ID).SingleOrDefault(); String[] nume = member_name.Split(' '); String nume0 = nume[0]; String nume1 = nume[1]; int member_id = (from b in db.People where b.Nume == nume0 && b.Prenume == nume1 && b.Rol == 1 select b.ID).SingleOrDefault(); var rowToUpdate = db.Lends.Where(o => (o.Book_ID == book_id)).Where(o => (o.Person_ID == member_id)).Where(o => o.Stare_Imprumut == 1); if (rowToUpdate.Any()) { foreach (var item in rowToUpdate) { item.Data_Retur = enteredDate; } MessageBox.Show("Data de returnare a fost schimbata."); } else { MessageBox.Show("Cartea nu se afla la membrul selectat."); } db.SaveChanges(); } } } catch (Exception ex) { MessageBox.Show("A avut loc o eroare. Vă rugăm să încercaţi din nou."); } }
private void button1_Click(object sender, EventArgs e) { using (var db = new BibliotecaEntities()) { var publisher = new Publisher(); publisher.Nume = publisher_text.Text; db.Publishers.Add(publisher); db.SaveChanges(); publisher_text.Text = ""; MessageBox.Show("Editura creata cu success!"); } }
private void add_author_Click(object sender, EventArgs e) { using (var db = new BibliotecaEntities()) { var autor = new Author(); autor.Nume = author_text.Text; db.Authors.Add(autor); db.SaveChanges(); author_text.Text = ""; MessageBox.Show("Autor creat cu success!"); } }
private void add_domain_Click(object sender, EventArgs e) { using (var db = new BibliotecaEntities()) { var domain = new Domain(); domain.Nume = domain_text.Text; db.Domains.Add(domain); db.SaveChanges(); domain_text.Text = ""; MessageBox.Show("Domeniu creat cu success!"); } }
private void button_retur_Click(object sender, EventArgs e) { using (var db = new BibliotecaEntities()) { var titlu = carte_combo.SelectedItem.ToString(); var nume = membru_combo.SelectedItem.ToString(); int book_id = (from b in db.Books where b.Titlu == titlu select b.ID).SingleOrDefault(); String[] member_name = nume.Split(' '); String nume0 = member_name[0]; String nume1 = member_name[1]; int member_id = (from b in db.People where b.Nume == nume0 && b.Prenume == nume1 && b.Rol == 1 select b.ID).SingleOrDefault(); var rowToUpdate = db.Lends.Where(o => (o.Book_ID == book_id)).Where(o => (o.Person_ID == member_id)); if (rowToUpdate.Any()) { foreach (var item in rowToUpdate) { item.Stare_Imprumut = 0; } MessageBox.Show("Actiune realizata cu succes."); var result = (from b in db.Books where b.Titlu == titlu select b).SingleOrDefault(); result.Exemplare++; } else { MessageBox.Show("Va rugam, introduceti date pentru o inregistrare valida."); } db.SaveChanges(); } }