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