private LibrarianAccount FindRecord() { var cmd = DbConnection.CreateCommand(); cmd.CommandText = "select id, fname, lname, startdate, isadmin, street, city, state, zipcode, passwordhash from Librarian where id = @id and PasswordHash = @hash"; cmd.Parameters.AddWithValue("id", txtAccountId.Text); cmd.Parameters.AddWithValue("hash", PasswordHasher.ToHash(txtPassword.Text)); LibrarianAccount info = null; using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { info = new LibrarianAccount() { ID = reader.GetInt32(0), Firstname = reader.GetString(1), Lastname = reader.GetString(2), StartDate = reader.GetDateTime(3), IsAdmin = reader.GetBoolean(4), Street = reader.GetString(5), City = reader.GetString(6), State = reader.GetString(7), ZipCode = reader.GetString(8), PasswordHash = reader.GetString(9) }; } } return(info); }
public RegisterMemberView(SqlConnection connection, LibrarianAccount account) { DbConnection = connection; Account = account; InitializeComponent(); }
private void btnLogin_Click(object sender, EventArgs e) { ResetErrorMessages(); if (txtAccountId.Text.Length == 0) { setAccountIdError("value required"); } else if (txtPassword.Text.Length == 0) { setPasswordError("value required"); } else { var record = FindRecord(); if (record == null) { setAccountIdError("Record not found, please verify your credentials"); } else { LibrarianAccount = record; DialogResult = DialogResult.OK; Close(); } } }
public ManageLibrariansView(SqlConnection connection, LibrarianAccount account) { DbConnection = connection; Account = account; InitializeComponent(); }
private void Librarianbutton_Click(object sender, EventArgs e) { //this will be the librarian that successfully logged in LibrarianAccount librarian = null; //create the login form using (LibrarianLogin form = new LibrarianLogin()) { //ensure it has a DB connection form.DbConnection = DbConnection; //display the login form as a modal var result = form.ShowDialog(); //if the user login was successful if (result == DialogResult.OK) { //pull the user object librarian = form.LibrarianAccount; //do something with the data } } if (librarian != null) { using (LibrarianView form = new LibrarianView()) { form.DbConnection = DbConnection; form.Account = librarian; form.ShowDialog(); } } }
public PastDueReportView(SqlConnection connection, LibrarianAccount account) { DbConnection = connection; Account = account; InitializeComponent(); }
public HistoricalCheckoutsView(SqlConnection connection, LibrarianAccount account) { DbConnection = connection; Account = account; InitializeComponent(); }
public AddInventoryView(SqlConnection connection, LibrarianAccount account) { DbConnection = connection; Account = account; InitializeComponent(); }
public CurrentCheckoutsReportView(SqlConnection connection, LibrarianAccount account) { DbConnection = connection; Account = account; InitializeComponent(); }
private void EditInventoryView_Load(object sender, EventArgs e) { authorTable = new DataTable(); authorTable.Columns.Add("Firstname"); authorTable.Columns.Add("Middle Initial"); authorTable.Columns.Add("Lastname"); foreach (var author in Item.Authors) { authorTable.Rows.Add(author.Firstname, author.MiddleInitial, author.Lastname); } gridAuthors.DataSource = authorTable; Librarian = GetAssociatedLibrarian(); PopulateFields(); SetInitialBookInputFocus(); }