public bool addPreference(String email, String category, String subject, String description, String target_students, String price_info) { try { AccountManager am = new AccountManager(); string insertQuery; int id = am.getID(email); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); conn.Open(); insertQuery = "insert into [T.PREFERENCES] (id, category, subject, description, target_students, price_info) values (@ID, @Category, @Subject, @Description, @TargetStudents, @PriceInfo);"; SqlCommand com = new SqlCommand(insertQuery, conn); com.Parameters.AddWithValue("@ID", id); com.Parameters.AddWithValue("@Category", category); com.Parameters.AddWithValue("@Subject", subject); com.Parameters.AddWithValue("@Description", description); com.Parameters.AddWithValue("@TargetStudents", target_students); com.Parameters.AddWithValue("@PriceInfo", price_info); com.ExecuteNonQuery(); conn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message, "Preference"); return false; } }
protected void LogInBtn_Click(object sender, EventArgs e) { AccountManager am = new AccountManager(); if(am.checkLogIn(UsernameTB.Text,PasswordTB.Text)) { statusLbl.Text = "log in correct"; Session["account"] = UsernameTB.Text; Response.Redirect("HomePage.aspx"); } else { statusLbl.Text = "Log-in Incorrect"; } }
protected void RegisterBTN_Click(object sender, EventArgs e) { AccountManager am = new AccountManager(); int x = Convert.ToInt32(dayDDL.SelectedValue); if (am.createAccount(emailTB.Text, passwordTB.Text, lastNameTB.Text, firstNameTB.Text, middleNameTB.Text, Convert.ToInt32(dayDDL.SelectedValue), Convert.ToInt32(monthDDL.SelectedValue), Convert.ToInt32(yearDDL.SelectedValue), genderDDL.SelectedValue, civilStatusDDL.SelectedValue, nationalityTB.Text, contactNumTB.Text, provinceTB.Text, cityTB.Text, zipcodeTB.Text)) { Label1.Text = "Log in Successful!"; } else { Label1.Text = "Log in not Successful!"; } }