private void buttonEnterGame_Click(object sender, EventArgs e) { string server = IPBox.Text; if (IPBox.Text == null || IPBox.Text == "") { Dialogue.Show("Enter Server IP", "", "Ok", "Cancel"); } else { try { IPHostEntry host = Dns.GetHostEntry(server); foreach (IPAddress ip in host.AddressList) { if (ip.AddressFamily == AddressFamily.InterNetwork) { Program.serverIP = ip.ToString(); timer1.Start(); } } }//end try catch { Dialogue.Show("Connection Failed", "", "Ok", "Cancel"); } } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { SqlDataAdapter sda = new SqlDataAdapter("select fullname AS 'Name' from participant p,classlist cl where p.participant_id=cl.participant_id AND class_id=(select class_id from classrooms where class_name = '" + comboBox1.SelectedItem + "') ", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 0) { BindingSource bs = new BindingSource(); bs.DataSource = dt; bunifuCustomDataGrid1.DataSource = bs; sda.Update(dt); bunifuCustomLabel1.Visible = true; } else { BindingSource bs = new BindingSource(); bs.DataSource = dt; bunifuCustomDataGrid1.DataSource = bs; sda.Update(dt); bunifuCustomLabel1.Visible = false; } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void GameParticipant_Load(object sender, EventArgs e) { try { SqlDataAdapter Name = new SqlDataAdapter("Select fullname from participant where participant_id='" + Program.par_id + "' ", con); DataTable dt = new DataTable(); Name.Fill(dt); Pname = dt.Rows[0][0].ToString(); //tg balik ko if (GameType == "QB") { label2.Text = "Quiz Bee"; label3.Text = System.IO.File.ReadAllText(@"QuizBeeRules.txt"); } else if (GameType == "PZ") { label2.Text = "Picture Puzzle"; label3.Text = System.IO.File.ReadAllText(@"PicturePuzzleRules.txt"); } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
public void Load_Participant() { try { SqlDataAdapter sda = new SqlDataAdapter("select fullname AS 'Name' from participant p,classlist cl where p.participant_id=cl.participant_id AND class_id=(select class_id from classrooms where class_name = '" + className + "' AND facilitator_id='" + Program.user_id + "') ", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 0) { label6.Text = "Of " + className + " "; bunifuCustomLabel1.Visible = true; BindingSource bs = new BindingSource(); bs.DataSource = dt; bunifuCustomDataGrid2.DataSource = bs; sda.Update(dt); pictureBox2.Visible = true; } else { label6.Text = "Of " + className + " "; bunifuCustomLabel1.Visible = false; BindingSource bs = new BindingSource(); bs.DataSource = dt; bunifuCustomDataGrid2.DataSource = bs; sda.Update(dt); pictureBox2.Visible = true; } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void buttonEnterGame_Click(object sender, EventArgs e) { SqlDataAdapter sda = new SqlDataAdapter("Select Game_Pin,Mode From Pincode where Mode='GP' ", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 0) { Dialogue.Show("No Host Server Detected for Groups! Please Wait for the Host to Start.", "", "Ok", "Cancel"); } else { string code = dt.Rows[0][0].ToString(); if (code == bunifuMetroTextbox1.Text) { LobbyParticipant lobby = new LobbyParticipant(); lobby.ShowDialog(); } else if (bunifuMetroTextbox1.Text == null || bunifuMetroTextbox1.Text == "") { bunifuCustomLabel1.Text = "* Please Enter Code"; } else { bunifuCustomLabel1.Text = "* Code is Invalid!"; } }//end else */ }
void Load_Quiz() { try { SqlDataAdapter sda = new SqlDataAdapter("Select quiz_title AS 'Title' ,date_created AS 'Created',game_type from quizzes where facilitator_id= '" + Program.user_id + "' ", con); DataTable data = new DataTable(); sda.Fill(data); if (data.Rows.Count == 0) { BindingSource bs = new BindingSource(); bs.DataSource = data; bunifuCustomDataGrid1.DataSource = bs; sda.Update(data); bunifuCustomDataGrid1.ClearSelection(); bunifuCustomLabel2.Visible = true; } else { BindingSource bs = new BindingSource(); bs.DataSource = data; bunifuCustomDataGrid1.DataSource = bs; sda.Update(data); bunifuCustomDataGrid1.ClearSelection(); bunifuCustomLabel2.Visible = false; } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void editC_Click(object sender, EventArgs e) { try { if (bunifuCustomDataGrid1.SelectedCells.Count > 0) { SqlDataAdapter adapt = new SqlDataAdapter("select Class_name from classrooms where class_name= '" + className + "' AND facilitator_id='" + Program.user_id + "' ", con); DataTable dt = new DataTable(); adapt.Fill(dt); SetValueForText1 = dt.Rows[0][0].ToString();//Getting the Name of The Classroom EditClassroom EC = new EditClassroom(); EC.ShowDialog(); } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }//try catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void bunifuFlatButton4_Click(object sender, EventArgs e) { try { if (bunifuCustomDataGrid1.SelectedCells.Count > 0) { SqlDataAdapter adapt = new SqlDataAdapter("select group_name from groups where group_name= '" + GroupName + "'", con); DataTable dt = new DataTable(); adapt.Fill(dt); SetValueForText4 = dt.Rows[0][0].ToString(); //Getting the Name of The group SetValueForText3 = Class; //Getting ClassName EditGroup EG = new EditGroup(); EG.ShowDialog(); } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }//try catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
}//end if private void bunifuFlatButton1_Click(object sender, EventArgs e) { try { if (bunifuCustomDataGrid1.SelectedRows.Count > 0) { SqlDataAdapter adapt = new SqlDataAdapter("select quiz_id from quizzes where quiz_title= '" + QuizName + "'", con); DataTable dt = new DataTable(); adapt.Fill(dt); int ID = Convert.ToInt32(dt.Rows[0][0].ToString()); //Getting the ID of The Quiz SetValueForText1 = ID.ToString(); if (GameType == "Quiz Bee") { EditQuizBEE EQB = new EditQuizBEE(); EQB.ShowDialog(); } else if (GameType == "Picture Puzzle") { EditPuzzle EP = new EditPuzzle(); EP.ShowDialog(); } } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }//try catch (Exception ex) { // Dialogue.Show(" ' " + ex.Message.ToString() + "'", "", "Ok", "Cancel"); } }
void Load_Participant() { try { SqlDataAdapter sad = new SqlDataAdapter("Select group_id from groups WHERE group_name = '" + group + "' ", con); DataTable data = new DataTable(); sad.Fill(data); ID = Convert.ToInt32(data.Rows[0][0]); SqlDataAdapter sda = new SqlDataAdapter("Select fullname from participant p, grouplist gl WHERE p.participant_id = gl.participant_id AND gl.group_id= '" + ID + "' ", con); DataTable dt = new DataTable(); sda.Fill(dt); BindingSource bs = new BindingSource(); bs.DataSource = dt; bunifuCustomDataGrid1.DataSource = bs; sda.Update(dt); } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void ButtonParticipantSignIn_Click(object sender, EventArgs e) { SqlDataAdapter sda = new SqlDataAdapter("Select count(*) From participant Where p_username='******' COLLATE SQL_Latin1_General_CP1_CS_AS and p_password= '******' COLLATE SQL_Latin1_General_CP1_CS_AS", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { SqlCommand cmd = new SqlCommand("Select participant_id from participant where p_username='******' COLLATE SQL_Latin1_General_CP1_CS_AS and p_password= '******' COLLATE SQL_Latin1_General_CP1_CS_AS", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Program.par_id = Convert.ToInt32(dr["participant_id"]); } dr.Close(); con.Close(); Program.PSession_id = TextboxUsername.Text; //For Session // Dialogue.Show("Login Successful!", "", "Ok", "Cancel"); this.Hide(); MainMenu2 mm = new MainMenu2(); mm.Show(); } else { Dialogue.Show("Login Failed! \r\n Please Check your Username and Password!", "", "Ok", "Cancel"); } }
private void deleteP_Click(object sender, EventArgs e) { if (bunifuCustomDataGrid2.SelectedCells.Count > 0) { SqlDataAdapter adapt = new SqlDataAdapter("select class_id from classrooms where class_name= '" + className + "' AND facilitator_id='" + Program.user_id + "' ", con); DataTable dt = new DataTable(); adapt.Fill(dt); int ID = int.Parse(dt.Rows[0][0].ToString());//Getting the ID of The Classroom SqlDataAdapter add = new SqlDataAdapter("select participant_id from participant where fullname= '" + participantName + "'", con); DataTable data = new DataTable(); add.Fill(data); int id = int.Parse(data.Rows[0][0].ToString());//Getting the ID of The Participant DialogResult result = Dialogue1.Show("Are You Sure?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { con.Open(); String query = "DELETE FROM classlist WHERE class_id= '" + ID + "' AND facilitator_id = '" + Program.user_id + "' AND participant_id= '" + id + "' "; SqlDataAdapter sda = new SqlDataAdapter(query, con); int m = sda.SelectCommand.ExecuteNonQuery(); con.Close(); if (m > 0) { Load_Class(); Load_Participant(); bunifuCustomDataGrid1.ClearSelection(); bunifuCustomDataGrid2.ClearSelection(); Dialogue.Show("Successfully Deleted!", "", "Ok", "Cancel"); } else { Dialogue.Show("Fail to Delete!", "", "Ok", "Cancel"); Load_Class(); Load_Participant(); bunifuCustomDataGrid1.ClearSelection(); bunifuCustomDataGrid2.ClearSelection(); } }//end if result } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }
private void bunifuFlatButton3_Click(object sender, EventArgs e) { try { if (bunifuCustomDataGrid1.SelectedRows.Count > 0) { SqlDataAdapter sed = new SqlDataAdapter("select class_id from classrooms where class_name= '" + Class + "' ", con); DataTable det = new DataTable(); sed.Fill(det); int id = Convert.ToInt32(det.Rows[0][0]); DialogResult result = Dialogue1.Show("Are You Sure?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { con.Open(); String q = "DELETE FROM grouplist WHERE group_id IN (select group_id from groups where group_name= '" + GroupName + "')"; SqlDataAdapter s = new SqlDataAdapter(q, con); int n = s.SelectCommand.ExecuteNonQuery(); String query = "DELETE FROM groups WHERE group_name= '" + GroupName + "' AND class_id= '" + id + "' "; SqlDataAdapter sda = new SqlDataAdapter(query, con); int m = sda.SelectCommand.ExecuteNonQuery(); con.Close(); if (m > 0) { Load_Group(); bunifuCustomDataGrid1.ClearSelection(); Dialogue.Show("Successfully Deleted!", "", "Ok", "Cancel"); } else { Load_Group(); Dialogue.Show("Fail to Delete!", "", "Ok", "Cancel"); bunifuCustomDataGrid1.ClearSelection(); } }//end if result } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }//try catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void bunifuThinButton21_Click(object sender, EventArgs e) { SqlDataAdapter adapter = new SqlDataAdapter("select count(class_id) from classrooms where class_name= '" + ClassNameBox.Text + "' ", con); DataTable dat = new DataTable(); adapter.Fill(dat); int Count = int.Parse(dat.Rows[0][0].ToString()); if (string.IsNullOrWhiteSpace(ClassNameBox.Text) && ClassNameBox.Text.Length > 0 || ClassNameBox.Text == "") { Dialogue.Show("Invalid Input or Empty", "", "Ok", "Cancel"); }//If End else if (Count != 0) { Dialogue.Show("Classroom Already Exist! Please use Other Name", "", "Ok", "Cancel"); } else { DialogResult result = Dialogue1.Show("Are You Sure?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { SqlDataAdapter adapt = new SqlDataAdapter("select class_id from classrooms where class_name= '" + Cname + "'", con); DataTable dt = new DataTable(); adapt.Fill(dt); int ID = int.Parse(dt.Rows[0][0].ToString());//Getting the ID of The Classroom con.Open(); String query = "UPDATE classrooms SET class_name= '" + ClassNameBox.Text + " ' WHERE facilitator_id= '" + Program.user_id + "' AND class_id= '" + ID + "' "; SqlDataAdapter sda = new SqlDataAdapter(query, con); int n = sda.SelectCommand.ExecuteNonQuery(); con.Close(); CreateMyClassroom CC = (CreateMyClassroom)Application.OpenForms["CreateMyClassroom"]; CC.Load_Class(); CC.Load_Participant(); this.Close(); } else { Dialogue.Show("Fail to Update", "", "Ok", "Cancel"); } } }
private void ButtonFacilitatorCreateAccount_Click(object sender, EventArgs e) { if (FName.Text == "" || Mname.Text == "" || Lname.Text == "") { Dialogue.Show("Fill All Fields!", "", "Ok", "Cancel"); } else { /////Password char[] letters = "q1we2rty3uio4pas5dfgh6jklz7x8cv9bnm0".ToCharArray(); Random r = new Random(); string randomString = ""; for (int i = 0; i < 9; i++) //i < # depends how long the password { randomString += letters[r.Next(0, 34)].ToString(); } // MessageBox.Show(randomString); /////Username string fName = FName.Text; string mName = Mname.Text; string lName = Lname.Text; string usernameFormat = String.Format("{0}_" + "{1}" + "{2}", lName.ToLower(), fName.Substring(0, 3), mName.Substring(0, 1)); // MessageBox.Show(usernameFormat); con.Open(); SqlCommand cmd = new SqlCommand("Insert into participant(fullname,p_username,p_password,F_name,M_name,L_name) Values('" + fName + " " + mName + " " + lName + "','" + usernameFormat + "','" + randomString + "','" + fName + "','" + mName + "','" + lName + "')", con); int n = cmd.ExecuteNonQuery(); con.Close(); if (n > 0) { Dialogue.Show("Successfully Created", "", "Ok", "Cancel"); FName.Text = null; Mname.Text = null; Lname.Text = null; } else { Dialogue.Show("Failed! Please Retry", "", "Ok", "Cancel"); } } }
private void createC_Click(object sender, EventArgs e) { SqlDataAdapter adapt = new SqlDataAdapter("select count(class_id) from classrooms where class_name= '" + textBoxCreateClassroom.Text + "' AND facilitator_id= '" + Program.user_id + "' ", con); DataTable dt = new DataTable(); adapt.Fill(dt); int ID = int.Parse(dt.Rows[0][0].ToString());//Counting The Instances of Same Classroom //if (textBoxCreateClassroom.Text == " ") if (string.IsNullOrWhiteSpace(textBoxCreateClassroom.Text) && textBoxCreateClassroom.Text.Length > 0 || textBoxCreateClassroom.Text == "") { Dialogue.Show("Invalid Input or Empty", "", "Ok", "Cancel"); } else if (ID != 0) { Dialogue.Show("Classroom Already Exist!", "", "Ok", "Cancel"); } else { Random random = new Random(); int randomNumber = random.Next(101010, 999999); string code = Convert.ToString(randomNumber); con.Open(); String query = "INSERT INTO classrooms (class_name,facilitator_id,class_code) VALUES ('" + textBoxCreateClassroom.Text + "','" + Program.user_id + "','" + code + "')"; SqlDataAdapter sda = new SqlDataAdapter(query, con); int n = sda.SelectCommand.ExecuteNonQuery(); con.Close(); if (n > 0) { Dialogue.Show("Classroom Created!", "", "Ok", "Cancel"); } else { Dialogue.Show("Creation Failed!", "", "Ok", "Cancel"); } className = " "; Load_Class(); bunifuCustomDataGrid1.ClearSelection(); textBoxCreateClassroom.Text = " "; // Load_Participant(); bunifuCustomDataGrid2.ClearSelection(); } }
private void updatescore(string name, string points) { if (participant == "PUBLIC") { int counter = 0; for (int i = 0; i < EmptyData.Rows.Count; i++) { if (EmptyData.Rows[i][0].ToString() == name.ToString()) { this.Invoke((MethodInvoker)(() => EmptyData.Rows[i][1] = points.ToString())); this.Invoke((MethodInvoker)(() => leaderboardFREE())); this.Invoke((MethodInvoker)(() => bunifuCustomDataGrid1.Update())); this.Invoke((MethodInvoker)(() => bunifuCustomDataGrid1.Refresh())); counter++; } } if (counter == 0) { DataRow DR = EmptyData.NewRow(); this.Invoke((MethodInvoker)(() => DR[0] = name.ToString())); this.Invoke((MethodInvoker)(() => DR[1] = points.ToString())); this.Invoke((MethodInvoker)(() => EmptyData.Rows.Add(DR))); this.Invoke((MethodInvoker)(() => leaderboardFREE())); this.Invoke((MethodInvoker)(() => bunifuCustomDataGrid1.Update())); this.Invoke((MethodInvoker)(() => bunifuCustomDataGrid1.Refresh())); } } else { for (int i = 0; i < data.Rows.Count; i++) { try { if (data.Rows[i][0].ToString() == name.ToString()) { this.Invoke((MethodInvoker)(() => data.Rows[i][1] = points.ToString())); this.Invoke((MethodInvoker)(() => leaderboard())); this.Invoke((MethodInvoker)(() => bunifuCustomDataGrid1.Update())); this.Invoke((MethodInvoker)(() => bunifuCustomDataGrid1.Refresh())); } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } } } }
private void btn_print_Click(object sender, EventArgs e) { if (comboBox1.SelectedItem == null) { Dialogue.Show("Please Select Class First", "", "Ok", "Cancel"); } else { exporttopdf(bunifuCustomDataGrid1, comboBox1.SelectedItem.ToString()); } }
private void create_Click(object sender, EventArgs e) { SqlDataAdapter sda = new SqlDataAdapter("Select count(*) From quizzes Where quiz_title ='" + textBoxQuizTitle.Text + "' ", con); DataTable dt = new DataTable(); sda.Fill(dt); int check = Convert.ToInt32(dt.Rows[0][0].ToString()); if (splitPicture.ImageLocation == null || textBoxQuizTitle.Text == "" || string.IsNullOrWhiteSpace(textBoxQuizTitle.Text) && textBoxQuizTitle.Text.Length > 0 || textBox1.Text == "" || string.IsNullOrWhiteSpace(textBox1.Text) && textBox1.Text.Length > 0) { Dialogue.Show("Please Fill All Fields", "", "Ok", "Cancel"); } else if (check >= 1) { Dialogue.Show("Quiz already exist, please use other Title", "", "Ok", "Cancel"); } else { SetValueForText3 = splitPicture.ImageLocation; SetValueForText2 = textBoxQuizTitle.Text; SetValueForText4 = textBox1.Text; if (textBoxQuizTimeLimit.Text == "" || string.IsNullOrWhiteSpace(textBoxQuizTimeLimit.Text) && textBoxQuizTimeLimit.Text.Length > 0) { time = ""; } else { if (bunifuDropdown1.selectedIndex == 0)//Minutes { time = textBoxQuizTimeLimit.Text + "(Minutes)"; } else { time = textBoxQuizTimeLimit.Text + "(Seconds)"; } } SetWidth = splitPicture.Image.Width; SetHeight = splitPicture.Image.Height; this.Hide(); PicturePuzzle pz = new PicturePuzzle(); pz.ShowDialog(); } }
private void DeleteQuiz_Click(object sender, EventArgs e) { try { if (bunifuCustomDataGrid1.SelectedRows.Count > 0) { SqlDataAdapter adapt = new SqlDataAdapter("select quiz_id from quizzes where quiz_title= '" + QuizName + "'", con); DataTable dt = new DataTable(); adapt.Fill(dt); int ID = int.Parse(dt.Rows[0][0].ToString());//Getting the ID of The Quiz DialogResult result = Dialogue1.Show("Are You Sure?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { con.Open(); String qer = "DELETE FROM QuestionAnswers WHERE quiz_id= '" + ID + "' "; String query = "DELETE FROM quizzes WHERE quiz_id= '" + ID + "' AND facilitator_id = '" + Program.user_id + "' "; SqlDataAdapter sad = new SqlDataAdapter(qer, con); SqlDataAdapter sda = new SqlDataAdapter(query, con); int n = sad.SelectCommand.ExecuteNonQuery(); int m = sda.SelectCommand.ExecuteNonQuery(); con.Close(); if (n >= 0 && m > 0) { Load_Quiz(); bunifuCustomDataGrid1.ClearSelection(); search.Text = ""; Dialogue.Show("Successfully Deleted!", "", "Ok", "Cancel"); } else { Dialogue.Show("Fail to Delete!", "", "Ok", "Cancel"); bunifuCustomDataGrid1.ClearSelection(); } }//end if result } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }//try catch (Exception ex) { // Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { if (comboBox1.SelectedItem == null) { Dialogue.Show("Classroom Not Specified", "", "Ok", "Cancel"); } else { SetValueForText1 = Class; AddGroup AG = new AddGroup(); AG.ShowDialog(); } }
private void MyAccountEdit_Click(object sender, EventArgs e) { switch (MyAccountEdit.Text) { case "Edit": { fullname.Enabled = true; username.Enabled = true; password.Enabled = true; MyAccountEdit.Text = "Save"; password.isPassword = false; } break; case "Save": { if (fullname.Text != "" && username.Text != "" && password.Text != "") { DialogResult result = Dialogue1.Show("Are you sure ?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { fullname.Enabled = false; username.Enabled = false; password.Enabled = false; MyAccountEdit.Text = "Edit"; con.Open(); String query = "UPDATE participant SET fullname= '" + fullname.Text + "', p_username='******', p_password = '******' WHERE participant_id= '" + Program.par_id + "' "; SqlDataAdapter sda = new SqlDataAdapter(query, con); int n = sda.SelectCommand.ExecuteNonQuery(); con.Close(); password.isPassword = true; load_account(); } } else { Dialogue.Show("Please Fill all Fields!", "", "Ok", "Cancel"); } } break; } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { if (bunifuMetroTextbox1.Text == null || bunifuMetroTextbox1.Text == "") { Dialogue.Show("Please Provide a Screen Name", "", "Ok", "Cancel"); } else { NameFREE = bunifuMetroTextbox1.Text; this.Hide(); LobbyParticipant con = new LobbyParticipant(); con.Show(); } }
private void bunifuFlatButton2_Click(object sender, EventArgs e) { if (bunifuCustomDataGrid1.SelectedRows.Count > 0) { SetValueForText2 = GroupName; SetValueForText3 = Class; ViewGroupParticipant VGP = new ViewGroupParticipant(); VGP.ShowDialog(); } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { SqlDataAdapter sda = new SqlDataAdapter("select p_username AS 'Username',p_password AS 'Password',fullname AS 'Name' from participant p,classlist cl where p.participant_id=cl.participant_id AND class_id=(select class_id from classrooms where class_name = '" + comboBox1.SelectedItem + "' AND facilitator_id='" + Program.user_id + "') ", con); DataTable dt = new DataTable(); sda.Fill(dt); SqlDataAdapter sad = new SqlDataAdapter("Select class_code from classrooms where class_name = '" + comboBox1.SelectedItem + "' ", con); DataTable data = new DataTable(); sad.Fill(data); string code = data.Rows[0][0].ToString(); label5.Text = code; label4.Visible = true; if (dt.Rows.Count == 0) { BindingSource bs = new BindingSource(); bs.DataSource = dt; bunifuCustomDataGrid1.DataSource = bs; sda.Update(dt); bunifuCustomLabel2.Visible = true; } else { BindingSource bs = new BindingSource(); bs.DataSource = dt; bunifuCustomDataGrid1.DataSource = bs; sda.Update(dt); bunifuCustomLabel2.Visible = false; bunifuCustomDataGrid1.ClearSelection(); } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
void Load_List() { try { SqlDataAdapter sad = new SqlDataAdapter("select class_id from classrooms where class_name = '" + Class + "' ", con); DataTable data = new DataTable(); sad.Fill(data); int ClassID = Convert.ToInt32(data.Rows[0][0]); SqlDataAdapter s = new SqlDataAdapter("Select count(l_name) from participant p left join classlist cl on p.participant_id = cl.participant_id where cl.class_id = '" + ClassID + "' ", con); DataTable dt = new DataTable(); s.Fill(dt); if (dt.Rows[0][0].ToString() == "0") { bunifuFlatButton1.Visible = false; bunifuFlatButton2.Visible = false; Dialogue.Show("No Classroom Participant Found", "", "Ok", "Cancel"); } else { SqlCommand cmd = new SqlCommand("Select DISTINCT l_name from participant p left join classlist cl on p.participant_id =cl.participant_id where cl.class_id = '" + ClassID + "' ", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { comboBox1.Items.Add(dr["l_name"]); } dr.Close(); con.Close(); grouptext.Text = group; classtext.Text = Class; } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void bunifuFlatButton2_Click(object sender, EventArgs e) { try { if (bunifuCustomDataGrid1.SelectedRows.Count > 0) { DialogResult result = Dialogue1.Show("Are You Sure?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { con.Open(); String q = "DELETE FROM grouplist WHERE participant_id=(select participant_id from participant where fullname= '" + ParticipantName + "')"; SqlDataAdapter s = new SqlDataAdapter(q, con); int n = s.SelectCommand.ExecuteNonQuery(); con.Close(); if (n > 0) { Load_Participant(); bunifuCustomDataGrid1.ClearSelection(); Dialogue.Show("Successfully Deleted!", "", "Ok", "Cancel"); } else { Dialogue.Show("Fail to Delete!", "", "Ok", "Cancel"); bunifuCustomDataGrid1.ClearSelection(); } }//end if result } else { Dialogue.Show("Nothing Selected", "", "Ok", "Cancel"); } }//try catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { if (comboBox1.SelectedItem != null) { SqlDataAdapter cd = new SqlDataAdapter("SELECT class_id FROM classrooms where class_name='" + comboBox1.SelectedItem.ToString() + "' ", con); DataTable dt = new DataTable(); cd.Fill(dt); ID = dt.Rows[0][0].ToString(); this.Hide(); GameSettings LF = new GameSettings(); LF.Show(); } else { Dialogue.Show("Select Class First.", "", "Ok", "Cancel"); } }
private void TextboxUsername_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { try { SqlDataAdapter sda = new SqlDataAdapter("Select count(*) From facilitator Where username='******' COLLATE SQL_Latin1_General_CP1_CS_AS and password= '******' COLLATE SQL_Latin1_General_CP1_CS_AS", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { SqlCommand cmd = new SqlCommand("Select facilitator_id from facilitator where username='******' COLLATE SQL_Latin1_General_CP1_CS_AS and password= '******' COLLATE SQL_Latin1_General_CP1_CS_AS", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Program.user_id = Convert.ToInt32(dr["facilitator_id"]); } dr.Close(); con.Close(); Program.Session_id = TextboxUsername1.Text; //For Session this.Hide(); MainMenu mm = new MainMenu(); mm.Show(); } else { Dialogue.Show("Login Failed! Please Check your Username and Password!", "", "Ok", "Cancel"); } } catch (Exception ex) { Dialogue.Show(" ' " + ex.Message.ToString() + "' ", "", "Ok", "Cancel"); } e.SuppressKeyPress = true; } }
private void MyAccountEdit_Click(object sender, EventArgs e) { switch (MyAccountEdit.Text) { case "Edit": { pin.Enabled = true; MyAccountEdit.Text = "Save"; } break; case "Save": { if (pin.Text != "") { DialogResult result = Dialogue1.Show("Are you sure ?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { pin.Enabled = false; MyAccountEdit.Text = "Edit"; con.Open(); String query = "UPDATE SERVER SET PIN= '" + pin.Text + "' "; SqlDataAdapter sda = new SqlDataAdapter(query, con); int n = sda.SelectCommand.ExecuteNonQuery(); con.Close(); PIN(); } } else { Dialogue.Show("Please Fill !", "", "Ok", "Cancel"); } } break; } }