//--------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; }