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!";
}
}
