public FormBookDetail(string info)
{
InitializeComponent();
Connect2DB connect = new Connect2DB();
List <string> bookDetail = new List <string>();
bookDetail = connect.bookDetails(info);
string bookID, bookName, author, lent, categoryID, languageID, description, publisher, category, language;
if (bookDetail.Capacity > 0)
{
bookID = bookDetail.ElementAt(0);
bookName = "Book name: " + bookDetail.ElementAt(1);
author = "Author: " + bookDetail.ElementAt(2);
lent = "Lent status: " + bookDetail.ElementAt(3);
categoryID = bookDetail.ElementAt(4);
languageID = bookDetail.ElementAt(5);
description = "Description: " + bookDetail.ElementAt(6);
publisher = "Publisher :" + bookDetail.ElementAt(7);
language = "Language: " + connect.bookLanguage(languageID);
category = "Category: " + connect.bookCategory(categoryID);
BookName.Text = bookName;
Author.Text = author;
Publisher.Text = publisher;
Category.Text = category;
Language.Text = language;
Lent.Text = lent;
Description.Text = description;
}
}
//button after click save the information to array, then, this information will be send to admin for confirm
private void Confirm_Click(object sender, EventArgs e)
{
Connect2DB register = new Connect2DB();
firstName = FirstName.Text;
lastName = LastName.Text;
dateOfBirth = DateOfBirth.Value;
password = PasswordReg.Text;
email = EmailReg.Text;
telephone = int.Parse(Telephone.Text);
street = Street.Text;
streetNumber = Number.Text;
city = City.Text;
postalCode = int.Parse(PostalCode.Text);
int age;
if (System.DateTime.Today.Month == dateOfBirth.Month && System.DateTime.Today.Day == dateOfBirth.Day)
{
age = System.DateTime.Today.Year - dateOfBirth.Year;
}
else
{
age = System.DateTime.Today.Year - dateOfBirth.Year - 1;
}
if (register.writeUserAsInactive(firstName, lastName, email, password, telephone, age, dateOfBirth, street, streetNumber, city, postalCode))
{
Info.Text = "Your request was send successfully.";
Info.Visible = true;
}
else
{
Info.Text = "Your request wasn't send successfully.\nPlease try again later.";
Info.Visible = true;
}
}
//primary amdin login, that will be changed later
private void Login_Click(object sender, EventArgs e)
{
Connect2DB con = new Connect2DB();
if (con.isUserRegistered(Username.Text, Password.Text))
{
if (con.isUserAdmin(Username.Text) == "a")
{
Admin admin = new Admin();
admin.Show();
this.Hide();
admin.FormClosed += new FormClosedEventHandler(Form1_FormClosed);
}
else if (con.isUserAdmin(Username.Text) == "u")
{
Users userForm = new Users(Username.Text, Password.Text);
userForm.Show();
this.Hide();
userForm.FormClosed += new FormClosedEventHandler(Form1_FormClosed);
}
else
{
ErrorMessage.Text = "Your registration request is treated!";
ErrorMessage.Visible = true;
}
}
else
{
ErrorMessage.Text = "Invalid email or password!";
ErrorMessage.Visible = true;
}
}
public FormUserInterface()
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
connection = new Connect2DB();
SwitchToAdmin.Visible = false;
SwitchToAdmin.Enabled = false;
}
//button after click save the information to array, then, this information will be send to admin for confirm
private void Confirm_Click(object sender, EventArgs e)
{
Connect2DB register = new Connect2DB();
if (FirstName.Text.Trim() != "" && LastName.Text.Trim() != "" && PasswordReg.Text.Trim() != "" &&
EmailReg.Text.Trim() != "" && (Telephone1.Text + Telephone2.Text.Trim()) != "" &&
Street.Text.Trim() != "" && Number.Text.Trim() != "" && City.Text.Trim() != "" &&
PostalCode.Text.Trim() != "" && Country.Text.Trim() != "")
{
firstName = FirstName.Text;
lastName = LastName.Text;
dateOfBirth = DateOfBirth.Value;
password = PasswordReg.Text;
email = EmailReg.Text;
telephone = Telephone1.Text + Telephone2.Text;
street = Street.Text;
streetNumber = Int32.Parse(Number.Text);
city = City.Text;
postalCode = PostalCode.Text;
country = Country.Text;
if (register.isEmailTaken(email) == 0)
{
if (register.writeUserAsInactive(firstName, lastName, email, password, telephone, dateOfBirth, street, streetNumber, city, postalCode, country))
{
Info.Text = "Your request was send successfully.";
Info.Visible = true;
}
else
{
Info.Text = "Your request wasn't send successfully.\nPlease try again later.";
Info.Visible = true;
}
}
else if (register.isEmailTaken(email) == 1)
{
Info.Text = "Email is already taken.";
Info.Visible = true;
}
else
{
Info.Text = "Error! Cannot connect to database.\nPlease try again later.";
Info.Visible = true;
}
}
else
{
Info.Text = "Enter your data!";
Info.Visible = true;
}
}
private void btnAddBookCategory_Click(object sender, EventArgs e)
{
Connect2DB database = new Connect2DB();
CategoryName = this.txtBookCategory.Text;
if (database.addBookCategory(CategoryName))
{
MessageBox.Show("Category successfully added");
}
else
{
MessageBox.Show("ERROR: Category not added!");
}
}
private void btnAddBookLanguage_Click(object sender, EventArgs e)
{
Connect2DB database = new Connect2DB();
LanguageName = this.txtBookLanguage.Text;
if (database.addBookLanguage(LanguageName))
{
MessageBox.Show("Language successfully added");
}
else
{
MessageBox.Show("ERROR: Language not added!");
}
}
public FormUserInterface(string UserID)
{
InitializeComponent();
connection = new Connect2DB();
this.UserID = UserID;
string userRole = connection.getUserRole(UserID);
if (userRole == "admin")
{
SwitchToAdmin.Visible = true;
SwitchToAdmin.Enabled = true;
}
else
{
SwitchToAdmin.Visible = false;
SwitchToAdmin.Enabled = false;
}
}
//primary amdin login, that will be changed later
private void Login_Click(object sender, EventArgs e)
{
Connect2DB con = new Connect2DB();
if (con.isUserRegistered(Username.Text, Password.Text))
{
if (con.isUserBlocked(Username.Text))
{
ErrorMessage.Text = "Your account is blocked.\nPlease contact your library.";
ErrorMessage.Visible = true;
}
else
{
if (con.isUserAdmin(Username.Text) == "admin")
{
FormAdminInterface admin = new FormAdminInterface(Username.Text, Password.Text);
admin.Show();
this.Hide();
admin.FormClosed += new FormClosedEventHandler(Form1_FormClosed);
}
else if (con.isUserAdmin(Username.Text) == "user")
{
FormUserInterface userForm = new FormUserInterface();
userForm.Show();
this.Hide();
userForm.FormClosed += new FormClosedEventHandler(Form1_FormClosed);
}
else
{
ErrorMessage.Text = "Your registration request is treated!";
ErrorMessage.Visible = true;
}
}
}
else
{
ErrorMessage.Text = "Invalid email or password!";
ErrorMessage.Visible = true;
}
}
public FormAdminInterface(string username, string password)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
connection = new Connect2DB();
AdminID = connection.FindUser(username, password);
waitingReg = connection.waitingRegistration();
if (waitingReg > 0)
{
registrationReguestToolStripMenuItem.Text = "Registration Request (" + waitingReg + ")";
}
else if (waitingReg == 0)
{
registrationReguestToolStripMenuItem.Text = "Registration Request";
}
else if (waitingReg == -1)
{
registrationReguestToolStripMenuItem.Text = "Registration Request";
DatabaseInfo.Text = "Cannot connect to database!";
DatabaseInfo.Visible = true;
}
}
public Users(string userID)
{
InitializeComponent();
ErrorMessage.Visible = false;
Connect2DB con = new Connect2DB();
this.userID = userID;
if (userID == null)
{
ErrorMessage.Visible = true;
}
else
{
UserAllName.Text = con.getUserAllName(userID);
if (UserAllName.Text == null)
{
ErrorMessage.Visible = true;
}
else
{
UserAge.Text = "Age: " + con.getUserAge(userID);
}
}
}
