private void btn_search_Click(object sender, EventArgs e) // Click search button
{
if (txt_title.Text.Length > 0)
{
BibliotechDAL bd = new BibliotechDAL();
DataTable d = bd.SearchTitle(txt_title.Text);
DrawBookResults(d);
}
else if (txt_isbn.Text.Length > 0)
{
BibliotechDAL bd = new BibliotechDAL();
DataTable d = bd.SearchIsbn(txt_isbn.Text);
DrawBookResults(d);
}
else if (txt_author.Text.Length > 0)
{
BibliotechDAL bd = new BibliotechDAL();
DataTable d = bd.SearchAuthor(txt_author.Text);
DrawBookResults(d);
}
else
{
MessageBox.Show("Fyll i ett av sökfälten");
}
}
public BibliotechAdminView(string userId)
{
InitializeComponent();
BibliotechDAL dbUser = new BibliotechDAL();
FillViewBooks();
thisUser = userId;
DataTable a = dbUser.AllAuthors();
cmb_authors.DataSource = a;
cmb_authors.DisplayMember = "AuthorName";
cmb_authors.ValueMember = "AuthorID";
DataTable dt = dbUser.GetUserInfo(userId);
foreach (DataRow row in dt.Rows)
{
string id = row["UserId"].ToString();
string fname = row["UserFirstName"].ToString();
string lname = row["UserLastName"].ToString();
string passw = row["UserPassword"].ToString();
string admin = row["UserAdmin"].ToString();
int debt = (int)row["UserDebt"];
lbl_username.Text = fname + " " + lname;
us = new User(id, fname, lname, debt, passw, admin);
}
}
public BibliotechCustView(string userId)
{
InitializeComponent();
thisUser = userId;
BibliotechDAL dbUser = new BibliotechDAL();
DataTable dt = dbUser.GetUserInfo(userId);
foreach (DataRow row in dt.Rows)
{
string id = row["UserId"].ToString();
string fname = row["UserFirstName"].ToString();
string lname = row["UserLastName"].ToString();
string passw = row["UserPassword"].ToString();
string admin = row["UserAdmin"].ToString();
int debt = (int)row["UserDebt"];
lbl_username.Text = fname + " " + lname;
us = new User(id, fname, lname, debt, passw, admin);
lbl_username.Text = us.UserFirstName + " " + us.UserLastName;
if (us.Debt > 0)
{
lbl_debt.Text = "OBS! Du har en skuld på " + us.Debt + " kr!";
}
}
ShowLoans();
}
public DataTable SearchIsbn(string searchIsbn) // Search ISBN
{
BibliotechDAL bs = new BibliotechDAL();
DataTable res = bs.SearchIsbn(searchIsbn);
return(res);
}
public DataTable SearchAuthor(string searchAuthor) // Search author by name
{
BibliotechDAL bs = new BibliotechDAL();
DataTable res = bs.SearchAuthor(searchAuthor);
return(res);
}
public EditAuthorView(int id)
{
InitializeComponent();
thisAuthor = id;
BibliotechDAL bd = new BibliotechDAL();
txt_aName.Text = bd.ReturnAuthorName(id);
}
public void AddBook(string title, int author, string isbn) // Lägg till bok
{
BibliotechDAL bd = new BibliotechDAL();
int copy = bd.GetCopyNbr(isbn);
Book b = new Book(title, author, isbn, copy);
bd.AddNewBook(b);
}
private void btn_Update_Click(object sender, EventArgs e)
{
BibliotechDAL bd = new BibliotechDAL();
User u2 = new User(thisUser, txt_editfname.Text, txt_editlname.Text, Convert.ToInt32(txt_editdebt.Text),
txt_editpw.Text, cmb_admin.Text);
bd.EditUser(u2);
}
public void AddAuthor(string aName) // Lägg till författare
{
BibliotechDAL bd = new BibliotechDAL();
DataTable dt = bd.AllAuthors();
int id = new BibliotechDAL().GetNextAuthorId();
Author a = new Author(id, aName);
bd.AddNewAuthor(a);
}
public void AddUser(string pnr, string fName, string lName, string pword, string admin) // Add user
{
int debt = 0;
User u = new User(pnr, fName, lName, debt, pword, admin);
BibliotechDAL bd = new BibliotechDAL();
bd.AddNewUser(u);
}
private void btn_editauthor_Click(object sender, EventArgs e) //Button edit author
{
int i = grid_results_adm.CurrentRow.Index;
int id = (int)grid_results_adm["AuthorID", i].Value;
BibliotechDAL bd = new BibliotechDAL();
EditAuthorView aForm = new EditAuthorView(id);
aForm.Show();
}
private void btn_returnbook_Click(object sender, EventArgs e) // Button return book
{
int i = grid_results_adm.CurrentRow.Index;
string isbn = grid_results_adm["Isbn", i].Value.ToString();
int copy = (int)grid_results_adm["CopyNbr", i].Value;
BibliotechDAL bd = new BibliotechDAL();
bd.EndLoan(isbn, copy);
FillViewBooks();
}
private void btn_userreturn_Click(object sender, EventArgs e)
{
int i = grid_results.CurrentRow.Index;
string isbn = grid_results["BookIsbn", i].Value.ToString();
int copy = (int)grid_results["BookCopy", i].Value;
BibliotechDAL bd = new BibliotechDAL();
bd.EndLoan(isbn, copy);
ShowLoans();
}
private void ShowLoans() //Visa användarens lån
{
BibliotechDAL dbUser = new BibliotechDAL();
DataTable dtLoans = dbUser.GetOutstandingLoans(us.UserId);
grid_results.Columns.Clear();
grid_results.DataSource = dtLoans;
btn_userreturn.Visible = true;
btn_userloan.Visible = false;
grid_results.Show();
}
private void btn_AddAuthor_Click(object sender, EventArgs e)
{
BibliotechController bc = new BibliotechController();
bc.AddAuthor(txt_newAuthorName.Text);
BibliotechDAL dbUser = new BibliotechDAL();
DataTable a = dbUser.AllAuthors();
cmb_authors.DataSource = a;
cmb_authors.DisplayMember = "AuthorName";
cmb_authors.ValueMember = "AuthorID";
}
public void LoanBook(string isbn, int copy, string uId) // Låna en bok
{
BibliotechDAL bd = new BibliotechDAL();
Loan loan = new Loan(isbn, copy, uId);
if (bd.CheckAvailability(isbn, copy) == 0)
{
bd.AddNewLoan(loan);
}
else
{
MessageBox.Show("Boken är redan utlånad");
}
}
private void FillViewUsers() //Fill view with all users
{
BibliotechDAL bd = new BibliotechDAL();
grid_results_adm.Columns.Clear();
grid_results_adm.DataSource = bd.AllUsers();
grid_results_adm.Show();
btn_delbook.Visible = false;
btn_deluser.Visible = true;
btn_loan.Visible = false;
btn_returnbook.Visible = false;
btn_edituser.Visible = true;
btn_deleteauthor.Visible = false;
btn_editauthor.Visible = false;
}
public List <Author> ListAllAuthors() // Lista alla författare
{
List <Author> aList = new List <Author>();
BibliotechDAL bs = new BibliotechDAL();
DataTable res = bs.AllAuthors();
foreach (DataRow row in res.Rows)
{
int id = (int)row["AuthorID"];
string aName = row["AuthorName"].ToString();
aList.Add(new Author(id, aName));
}
return(aList);
}
private void DrawBookResults(DataTable dt) // Fyll grid_view med böcker efter sök
{
BibliotechDAL bd = new BibliotechDAL();
grid_results.Columns.Clear();
grid_results.DataSource = dt;
grid_results.Columns["CopyNbr"].HeaderText = "Exemplar nr";
grid_results.Columns["Title"].HeaderText = "Titel";
grid_results.Columns["AuthorName"].HeaderText = "Författare";
grid_results.Columns["AuthorID"].Visible = false;
grid_results.Columns["AuthorID1"].Visible = false;
grid_results.Columns["BookISBN"].Visible = false;
grid_results.Columns["BookCopy"].Visible = false;
grid_results.Columns["UserID"].Visible = false;
grid_results.Show();
}
private void btn_deluser_Click(object sender, EventArgs e) //Button delete user
{
int i = grid_results_adm.CurrentRow.Index;
string id = grid_results_adm["UserID", i].Value.ToString();
BibliotechDAL bd = new BibliotechDAL();
int s = bd.UserNbrOfLoans(id);
if (s == 0)
{
bd.DeleteUser(id);
FillViewUsers();
}
else
{
MessageBox.Show("Går ej att radera, användaren har lån");
}
}
private void btn_deleteauthor_Click(object sender, EventArgs e) //Button delete author
{
int i = grid_results_adm.CurrentRow.Index;
int id = (int)grid_results_adm["AuthorID", i].Value;
BibliotechDAL bd = new BibliotechDAL();
int s = bd.AuthorNbrOfBooks(id);
if (s == 0)
{
bd.DeleteAuthor(id);
FillViewAuthors();
}
else
{
MessageBox.Show("Går ej att radera, författaren har böcker i biblioteket");
}
}
public List <Book> SearchTitle(string searchTitle) // Search title
{
List <Book> resultList = new List <Book>();
BibliotechDAL bs = new BibliotechDAL();
DataTable res = bs.SearchTitle(searchTitle);
foreach (DataRow row in res.Rows)
{
string title = row["Title"].ToString();
string isbn = row["ISBN"].ToString();
int author = (int)row["AuthorID"];
int copy = (int)row["CopyNbr"];
resultList.Add(new Book(title, author, isbn, copy));
}
return(resultList);
}
public User UserInfo(string uId) // Hämta användaruppgifter
{
BibliotechDAL bd = new BibliotechDAL();
DataTable dt = bd.GetUserInfo(uId);
foreach (DataRow row in dt.Rows)
{
string id = row["UserID"].ToString();
string fn = row["UserFirstName"].ToString();
string ln = row["UserLastName"].ToString();
int debt = (int)row["UserDebt"];
string pw = row["UserPassword"].ToString();
string adm = row["UserAdmin"].ToString();
User user = new User(id, fn, ln, debt, pw, adm);
return(user);
}
return(null);
}
public User DoLogin(string userName, string password) // Logga in
{
BibliotechDAL bd = new BibliotechDAL();
DataTable dt = bd.GetUserInfo(userName);
foreach (DataRow row in dt.Rows)
{
string id = row["UserID"].ToString();
string fn = row["UserFirstName"].ToString();
string ln = row["UserLastName"].ToString();
int debt = (int)row["UserDebt"];
string pw = row["UserPassword"].ToString();
string adm = row["UserAdmin"].ToString();
User user = new User(id, fn, ln, debt, pw, adm);
return(user);
}
return(null);
}
private void btn_userloan_Click(object sender, EventArgs e)
{
int i = grid_results.CurrentRow.Index;
string isbn = grid_results["Isbn", i].Value.ToString();
int copy = (int)grid_results["CopyNbr", i].Value;
BibliotechController bc = new BibliotechController();
BibliotechDAL bd = new BibliotechDAL();
int s = bd.CheckAvailability(isbn, copy);
if (s == 1)
{
MessageBox.Show("Boken är utlånad");
}
else
{
bc.LoanBook(isbn, copy, us.UserId);
ShowLoans();
}
}
private void btn_allbooksuser_Click(object sender, EventArgs e) //Klicka se alla böcker
{
{
BibliotechDAL bd = new BibliotechDAL();
grid_results.Columns.Clear();
grid_results.DataSource = bd.AllBooks();
grid_results.Columns["CopyNbr"].HeaderText = "Exemplar nr";
grid_results.Columns["Title"].HeaderText = "Titel";
grid_results.Columns["AuthorName"].HeaderText = "Författare";
grid_results.Columns["AuthorID"].Visible = false;
grid_results.Columns["AuthorID1"].Visible = false;
grid_results.Columns["BookISBN"].Visible = false;
grid_results.Columns["BookCopy"].Visible = false;
grid_results.Columns["UserID"].Visible = false;
grid_results.Show();
btn_userreturn.Visible = false;
btn_userloan.Visible = true;
}
}
private void FillViewLoans() //Fill view with all loans
{
BibliotechDAL bd = new BibliotechDAL();
grid_results_adm.Columns.Clear();
grid_results_adm.DataSource = bd.AllLoans();
grid_results_adm.Columns["CopyNbr"].HeaderText = "Exemplar nr";
grid_results_adm.Columns["Title"].HeaderText = "Titel";
grid_results_adm.Columns["BookCopy"].Visible = false;
grid_results_adm.Columns["ISBN"].Visible = false;
grid_results_adm.Columns["AuthorID"].Visible = false;
grid_results_adm.Show();
btn_delbook.Visible = false;
btn_deluser.Visible = false;
btn_loan.Visible = false;
btn_returnbook.Visible = true;
btn_edituser.Visible = false;
btn_deleteauthor.Visible = false;
btn_editauthor.Visible = false;
}
private void btn_delbook_Click(object sender, EventArgs e) // Button Delete book
{
int i = grid_results_adm.CurrentRow.Index;
string isbn = grid_results_adm["Isbn", i].Value.ToString();
int copy = (int)grid_results_adm["CopyNbr", i].Value;
BibliotechDAL bd = new BibliotechDAL();
int s = bd.CheckAvailability(isbn, copy);
if (s == 1)
{
MessageBox.Show("Går ej att radera, boken är lånad");
}
else
{
bd.DeleteBook(isbn, copy);
FillViewBooks();
}
}
private void btn_newpwsend_Click(object sender, EventArgs e)
{
BibliotechDAL bd = new BibliotechDAL();
bd.ChangePassword(thisUser, txt_newpw.Text);
}
private void btn_Save_Click(object sender, EventArgs e)
{
BibliotechDAL bd = new BibliotechDAL();
bd.EditAuthor(thisAuthor, txt_aName.Text);
}
