//--------Event Handlers-----------
private void saveAccInfoButton_Click(object sender, EventArgs e)
{
thisMember = new Member();
thisLogin = new Login();
thisMember.FName = firstNameBox.Text;
thisMember.LName = lastNameBox.Text;
thisMember.DateOfBirth = Convert.ToDateTime(DOBDateTimePicker.Text);
thisMember.Address1 = address1Box.Text;
thisMember.Address2 = address2Box.Text;
thisMember.City = cityBox.Text;
thisMember.State = stateBox.Text;
thisMember.Zip = Convert.ToInt32(zipBox.Text);
thisMember.Phone = Convert.ToString(phoneNumBox.Text);
thisLogin.Username = userNameBox.Text;
thisLogin.Password = passwordBox.Text;
string DOBString = Convert.ToString(thisMember.DateOfBirth);
DOBString = DOBString.Substring(0, 10);
int scopeID = thisMember.CreateAccount(thisMember.FName, thisMember.LName, thisMember.Address1, thisMember.Address2, thisMember.Phone, thisMember.City, thisMember.State, thisMember.Zip, DOBString);
thisLogin.CreateLogin(thisLogin.Username, thisLogin.Password, scopeID);
ClearTextBoxes();
MessageBox.Show("You have successfully created an account!");
}
private void button1_Click(object sender, EventArgs e)
{
Member member = new Member();
member.Id = Convert.ToInt32(textBox1.Text);
member = member.Select(member.Id);
MessageBox.Show(member.FName + member.LName + member.Address1 + member.AccId +" Bal: " + member.Balance);
}
private void save_BTN_Click(object sender, EventArgs e)
{
string zipString;
thisMember = new Member();
thisMemberDL = new MemberDL();
thisMember.FName = Convert.ToString(firstName_TXT);
thisMember.LName = Convert.ToString(lastName_TXT);
thisMember.Address1 = Convert.ToString(address1_TXT);
thisMember.Address2 = Convert.ToString(address2_TXT);
thisMember.City = Convert.ToString(city_TXT);
thisMember.State = Convert.ToString(state_TXT);
thisMember.Zip = Convert.ToInt32(zip_TXT);
thisMember.Phone = Convert.ToString(phone_TXT);
zipString = Convert.ToString(thisMember.Zip);
thisMemberDL.CreateAccount(thisMember.FName, thisMember.LName, thisMember.Address1, thisMember.Address2, thisMember.Phone, thisMember.City, thisMember.State, zipString, thisMember.DateOfBirth);
}
private void saveAccInfoButton_Click(object sender, EventArgs e)
{
thisMember = new Member();
thisMember.FName = firstNameBox.Text;
thisMember.LName = lastNameBox.Text;
thisMember.DateOfBirth = Convert.ToDateTime(DOBDateTimePicker.Text);
thisMember.Address1 = address1Box.Text;
thisMember.Address2 = address2Box.Text;
thisMember.City = cityBox.Text;
thisMember.State = stateBox.Text;
thisMember.Zip = Convert.ToInt32(zipBox.Text);
thisMember.Phone = Convert.ToString(phoneNumBox.Text);
string DOBString = Convert.ToString(thisMember.DateOfBirth);
DOBString = DOBString.Substring(0, 10);
thisMember.CreateAccount(thisMember.FName, thisMember.LName, thisMember.Address1, thisMember.Address2, thisMember.Phone, thisMember.City, thisMember.State, thisMember.Zip, DOBString);
ClearTextBoxes();
MessageBox.Show("Thank you! Your member account has been updated");
}
//private MemberDL thisMemberDL;
//-------Constructors------------
public NewMemForm()
{
thisMember = new Member();
InitializeComponent();
}
///////////////
public Member Select(int MemID)
{
string sqlText;
sqlText = "SELECT * FROM Member WHERE MemID = @MemID";
Member member = new Member();
//Establishes connection with SQL DB
string dbStr = "Data Source = mis220.eil-server.cba.ua.edu; Initial Catalog = MovieRental; user id =uamis; password=RollTide";
SqlConnection dbCon = new SqlConnection(dbStr);
SqlCommand command = new SqlCommand(sqlText, dbCon);
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@MemID", MemID);
dbCon.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
if (reader.IsDBNull(0) == false)
member.Id = reader.GetInt32(0);
//if (reader.IsDBNull(1) == false)
// member.AccId = reader.GetInt32(1);
if (reader.IsDBNull(2) == false)
member.FName = reader.GetString(2);
if (reader.IsDBNull(3) == false)
member.LName = reader.GetString(3);
if (reader.IsDBNull(4) == false)
member.DateOfBirth = Convert.ToDateTime(reader.GetDateTime(4));
if (reader.IsDBNull(5) == false)
member.Address1 = reader.GetString(5);
if (reader.IsDBNull(6) == false)
member.Address2 = reader.GetString(6);
if (reader.IsDBNull(7) == false)
member.City = reader.GetString(7);
if (reader.IsDBNull(8) == false)
member.State = reader.GetString(8);
if (reader.IsDBNull(9) == false)
member.Zip = reader.GetInt32(9);
if (reader.IsDBNull(10) == false)
member.Phone = reader.GetString(10);
}
reader.Close();
dbCon.Close();
sqlText = "SELECT * FROM Account as a INNER JOIN Member as m on a.AccountID = m.AccountID";
sqlText = "WHERE a.AccountID = @AccountID";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@AccountID", member.AccId);
dbCon.Open();
reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
if (reader.IsDBNull(0) == false)
member.AccId = reader.GetInt32(0);
if (reader.IsDBNull(1) == false)
member.MemStatus = reader.GetString(1);
if (reader.IsDBNull(2) == false)
member.Balance = reader.GetDouble(2);
if (reader.IsDBNull(3) == false)
member.CardNum = reader.GetInt32(3);
if (reader.IsDBNull(4) == false)
member.PaymentType = reader.GetInt32(4);
}
reader.Close();
command.Dispose();
dbCon.Close();
return member;
}
