public void addMember(Member obj)
{
try
{
database = new OleDbConnection(connectionString);
database.Open();
string queryString = "INSERT INTO Member (FirstName, LastName, Street, City, State, ZipCode, PhoneNumber, CreditCardNumber, CreditCardExpDate, CreditCardType) " +
"VALUES ('" + obj.FirstName + "', '" + obj.LastName + "', '" + obj.StreetAddress + "', '" + obj.City + "', '" + obj.State + "', '" + obj.ZipCode +
"', '" + obj.Telephone + "', '" + obj.CreditCard + "', '" + obj.ExpirationDate + "', '" + obj.CardType + "')";
OleDbCommand cmd = new OleDbCommand(queryString, database);
count = cmd.ExecuteNonQuery();
if (count >= 1)
MessageBox.Show(obj.FirstName + " " + obj.LastName + " has been added!");
else
MessageBox.Show("Error: Could not add member!");
database.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
database.Close();
}
}
private void okButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Member newMember = new Member(0,firstNameTextBox.Text,lastNameTextBox.Text,streetAddressTextbox.Text,cityTextbox.Text,stateMaskedTextBox.Text,zipCodeMaskedTextBox.Text,telephoneMaskedTextBox.Text,creditCardMaskedTextBox.Text,expMaskedTextbox.Text,companyTextbox.Text);
dataHandler.addMember(newMember);
firstNameTextBox.Text = "";
lastNameTextBox.Text = "";
streetAddressTextbox.Text = "";
cityTextbox.Text = "";
stateMaskedTextBox.Text = "";
zipCodeMaskedTextBox.Text = "";
telephoneMaskedTextBox.Text = "";
expMaskedTextbox.Text = "";
companyTextbox.Text = "";
}
private void okButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Member newMember = new Member(Int32.Parse(idTextBox.Text), firstNameTextbox.Text, textBox3.Text, textBox4.Text, textBox5.Text, maskedTextBox5.Text, maskedTextBox1.Text, maskedTextBox2.Text, maskedTextBox3.Text, maskedTextBox4.Text, textBox1.Text);
dataHandler.updateMember(newMember);
idTextBox.Text = "";
firstNameTextbox.Text="";
textBox3.Text="";
textBox4.Text="";
textBox5.Text="";
maskedTextBox5.Text="";
maskedTextBox1.Text="";
maskedTextBox2.Text="";
maskedTextBox3.Text="";
maskedTextBox4.Text="";
textBox1.Text = "";
}
public void updateMember(Member obj)
{
try
{
database = new OleDbConnection(connectionString);
database.Open();
string queryString = "UPDATE Member " +
"SET FirstName = '" + obj.FirstName + "', LastName = '" + obj.LastName +
"', Street = '" + obj.StreetAddress + "', City = '" + obj.City +
"', ZipCode = '" + obj.ZipCode + "', PhoneNumber = '" + obj.Telephone +
"', CreditCardNumber = '" + obj.CreditCard + "', CreditCardExpDate = '" + obj.ExpirationDate +
"', CreditCardType = '" + obj.CardType +
"' WHERE ID = " + obj.Id.ToString();
OleDbCommand cmd = new OleDbCommand(queryString, database);
count = cmd.ExecuteNonQuery();
if (count >= 1)
MessageBox.Show(obj.FirstName + " " + obj.LastName + "'s record has been updated!");
else
MessageBox.Show("Error: No member with that ID!");
database.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
database.Close();
}
}
public List<Member> getMembers()
{
memberList.Clear();
try
{
database = new OleDbConnection(connectionString);
database.Open();
string queryString = "SELECT * FROM Member";
OleDbCommand cmd = new OleDbCommand(queryString, database);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Member temp = new Member();
temp.Id = Int32.Parse(reader["ID"].ToString());
temp.FirstName = reader["FirstName"].ToString();
temp.LastName = reader["LastName"].ToString();
temp.StreetAddress = reader["Street"].ToString();
temp.City = reader["City"].ToString();
temp.State = reader["State"].ToString();
temp.ZipCode = reader["ZipCode"].ToString();
temp.Telephone = reader["PhoneNumber"].ToString();
temp.ExpirationDate = reader["CreditCardNumber"].ToString();
temp.CreditCard = reader["CreditCardExpDate"].ToString();
temp.CardType = reader["CreditCardType"].ToString();
memberList.Add(temp);
}
reader.Close();
database.Close();
return memberList;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
reader.Close();
database.Close();
return memberList;
}
}
public Member findMember(int id)
{
Member temp = new Member();
try
{
database = new OleDbConnection(connectionString);
database.Open();
string queryString = "SELECT * FROM Member Where ID = " +id.ToString();
OleDbCommand cmd = new OleDbCommand(queryString, database);
reader = cmd.ExecuteReader();
while (reader.Read())
{
temp.Id = Int32.Parse(reader["ID"].ToString());
temp.FirstName = reader["FirstName"].ToString();
temp.LastName = reader["LastName"].ToString();
temp.StreetAddress = reader["Street"].ToString();
temp.City = reader["City"].ToString();
temp.State = reader["State"].ToString();
temp.ZipCode =reader["ZipCode"].ToString();
temp.Telephone = reader["PhoneNumber"].ToString();
temp.ExpirationDate = reader["CreditCardNumber"].ToString();
temp.CreditCard = reader["CreditCardExpDate"].ToString();
temp.CardType = reader["CreditCardType"].ToString();
reader.Close();
database.Close();
return temp;
}
MessageBox.Show("No member with that ID was found!");
reader.Close();
database.Close();
return temp;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
reader.Close();
database.Close();
return temp;
}
}
private void validateButton_Click(object sender, EventArgs e)
{
dbIO dataHandler = new dbIO();
Member foundMember = new Member();
foundMember = dataHandler.findMember(Int32.Parse(memberTextBox.Text));
nameTextBox.Text = foundMember.FirstName + foundMember.LastName;
rentDateTextBox.Text = System.DateTime.Today.Date.ToShortDateString();
dueDateTextBox.Text = System.DateTime.Today.Date.AddDays(5).ToShortDateString();
}
