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