protected void loginButton1_Click(object sender, EventArgs e) { DataAccess_MySQL dbconn0 = new DataAccess_MySQL(); Aux aux1 = new Aux(); if (loginTextboxPass.Text.ToString().Contains("OR") || loginTextboxUser.Text.ToString().Contains("OR")) { ErrMsg_1.Text = "Sugi pula cristi"; return; } if (aux1.IsEmpty(loginTextboxUser.Text.ToString()) == true || aux1.IsEmpty(loginTextboxPass.Text.ToString()) == true) { ErrMsg_1.Text = aux1.ErrorIsEmpty; } else { dbconn0.setUserName = loginTextboxUser.Text; dbconn0.setPassword = loginTextboxPass.Text; dbconn0.Settype = "login"; dbconn0.connect(); if (dbconn0.setconnSuccess == true) { Response.Redirect("~/Pages/ExerciseUpload.aspx"); } else { ErrMsg_1.Text = "Invalid credentials if you want to create a new account, please click to SignUp button below"; signUpButton1.Visible = true; } } return; }
protected void uploadButton2_Click(object sender, EventArgs e) { DataAccess_MySQL mySQL2 = new DataAccess_MySQL(); mySQL2.Settype = "InsertExercise"; mySQL2.SqlCommand = "INSERT INTO web.Exercise(Date,Time,Exercise,Reps,Weight) VALUES('" + uploadTextBox1.Text + "','" + uploadTextBox2.Text + "','" + uploadTextBox3.Text + "','" + uploadTextBox4.Text + "','" + uploadTextBox5.Text + "')"; mySQL2.connect(); //Repopulate the list with newly inserted item PopulateDropDown exerciseDD = new PopulateDropDown(); exerciseDD.Type = "AllDistinctExercises"; exerciseDD.populate(); uploadDropDownList1.DataSource = exerciseDD.ReturnedList; uploadDropDownList1.DataBind(); }