private void btn_search_Click(object sender, EventArgs e) //Klicka på sökknappen
{
BibliotechController bc = new BibliotechController();
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");
}
}
private void btn_edituser_Click(object sender, EventArgs e) // Button edit user
{
int i = grid_results_adm.CurrentRow.Index;
string id = grid_results_adm["UserID", i].Value.ToString(); //TODO update
BibliotechController bc = new BibliotechController();
EditUserView aForm = new EditUserView(id);
aForm.Show();
}
private void btn_loan_Click(object sender, EventArgs e) //Button loan 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;
BibliotechController bc = new BibliotechController();
bc.LoanBook(isbn, copy, us.UserId);
FillViewBooks();
}
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";
}
private void btn_AddBook_Click(object sender, EventArgs e)
{
BibliotechController bc = new BibliotechController();
if (txt_addtitle.Text != "" && txt_addisbn.Text != "")
{
bc.AddBook(txt_addtitle.Text, Convert.ToInt32(cmb_authors.SelectedValue.ToString()), txt_addisbn.Text);
}
else
{
MessageBox.Show("Fyll i ISBN och boktitel");
}
}
public EditUserView(string id)
{
InitializeComponent();
thisUser = id;
BibliotechController bc = new BibliotechController();
User u = bc.UserInfo(id);
txt_editfname.Text = u.UserFirstName;
txt_editlname.Text = u.UserLastName;
txt_editdebt.Text = u.Debt.ToString();
txt_editpw.Text = u.UserPassword;
cmb_admin.Text = u.Admin;
}
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_Login_Click(object sender, EventArgs e)
{
if (txt_UserName.Text == "" || txt_Password.Text == "")
{
MessageBox.Show("Skriv in både användarnamn och lösenord");
return;
}
try
{
BibliotechController bc = new BibliotechController();
User u = bc.DoLogin(txt_UserName.Text, txt_Password.Text);
if (u != null)
{
if (u.UserPassword == txt_Password.Text)
{
if (u.Admin == "TRUE")
{
BibliotechAdminView aForm = new BibliotechAdminView(txt_UserName.Text);
aForm.Show();
this.Hide();
}
else
{
BibliotechCustView fm = new BibliotechCustView(txt_UserName.Text);
fm.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Fel personnummer eller lösenord");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_register_Click(object sender, EventArgs e) // Click add user
{
BibliotechController bc = new BibliotechController();
bc.AddUser(txt_pnr.Text, txt_fname.Text, txt_lname.Text, txt_pword.Text, box_admin.Text.ToString());
}
