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