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();
}
}