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