protected void btn_insertLec_Click(object sender, EventArgs e) { if (tb_usernameLec.Text.TrimStart().TrimEnd() == "" || tb_passLec.Text == "" || tb_fullname.Text.TrimStart().TrimEnd() == "") { lb_msg.Text = "You are required to fill all fields"; } else { con.Open(); cmd.CommandText = "SELECT * FROM Lectures WHERE username=@username AND pass=@pass"; cmd.Parameters.AddWithValue("@username", tb_usernameLec.Text); cmd.Parameters.AddWithValue("@pass", tb_passLec.Text); reader = cmd.ExecuteReader(); if (reader.Read()) { reader.Close(); lb_msg.Text = "Sorry bro this username and password already exists!"; } else { reader.Close(); cmd.CommandText = "INSERT INTO Lectures (username,pass,fullname,notes,active) VALUES (@username2,@pass2,@fullname,@notes, 'false')"; cmd.Parameters.AddWithValue("@username2", tb_usernameLec.Text); cmd.Parameters.AddWithValue("@pass2", tb_passLec.Text); cmd.Parameters.AddWithValue("@fullname", tb_fullname.Text); cmd.Parameters.AddWithValue("@notes", tb_notes.Text); cmd.ExecuteNonQuery(); lb_msg.Text = "Successfully added to database"; GridView_Lectures.DataBind(); } con.Close(); } }
protected void btn_signupLec_Click(object sender, EventArgs e) { if (tb_usernameLec.Text.TrimStart().TrimEnd() == "" || tb_passLec.Text == "" || tb_fullname.Text.TrimStart().TrimEnd() == "") { lb_msg.Text = "Please enter your information. Fields cannot be blank!"; } else { con.Open(); cmd.CommandText = "SELECT id FROM Lectures WHERE username=@username AND pass=@pass"; cmd.Parameters.AddWithValue("@username", tb_usernameLec.Text); cmd.Parameters.AddWithValue("@pass", tb_passLec.Text); reader = cmd.ExecuteReader(); if (reader.Read()) { reader.Close(); lb_msg.Text = " The username and password you have selected bave been to another user, " + "please choose a different username and password.\nThank you!"; } else { reader.Close(); cmd.CommandText = "INSERT INTO Lectures (username,pass,fullname,notes,active) VALUES (@username2,@pass2,@fullname,@notes,'false')"; cmd.Parameters.AddWithValue("@username2", tb_usernameLec.Text); cmd.Parameters.AddWithValue("@pass2", tb_passLec.Text); cmd.Parameters.AddWithValue("@fullname", tb_fullname.Text); cmd.Parameters.AddWithValue("@notes", tb_notes.Text); cmd.ExecuteNonQuery(); lb_msg.Text = "Information entered Successfully"; GridView_Lectures.DataBind(); } con.Close(); } }