private void login_BTN_Click(object sender, EventArgs e) { this.Hide(); if (loginUserBox.Text.ToString() != "admin") { MemberHome form = new MemberHome(); form.ShowDialog(); this.Close(); } else { AdminHome aForm = new AdminHome(); aForm.ShowDialog(); this.Close(); } }
private void returnTo_BOX_SelectedIndexChanged(object sender, EventArgs e) { if (returnTo_BOX.SelectedIndex == 0) { this.Hide(); MemberHome frm = new MemberHome(profile); frm.Show(); } if (returnTo_BOX.SelectedIndex == 1) { this.Hide(); MovieList frm = new MovieList(profile); frm.Show(); } if (returnTo_BOX.SelectedIndex == 2) { this.Hide(); AccountInfo frm = new AccountInfo(profile); frm.Show(); } }
private void submitButt_Click(object sender, EventArgs e) { profile.Balance -= Convert.ToDouble(paymentUpDown.Text); //SQL Statement for processing an account payment string sqlProfileCreate = "update Account " + "set Balance = (Balance - @paymentAmount) " + "where AccountID = '"+ profile.AccId +"';"; //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); try { //non-query SqlCommand cmdIns = new SqlCommand(sqlProfileCreate, dbCon); cmdIns.Parameters.AddWithValue("@paymentAmount", paymentUpDown.Value); dbCon.Open(); cmdIns.ExecuteNonQuery(); cmdIns.Parameters.Clear(); cmdIns.Dispose(); cmdIns = null; } //catch(Exception ex)//need to write exceptions finally { dbCon.Close(); MessageBox.Show("Your payment has been confirmed! Thank you for your business!"); this.Hide(); MemberHome form = new MemberHome(profile); } }
private void backToHome_BTN_Click(object sender, EventArgs e) { this.Hide(); MemberHome form = new MemberHome(profile); }