/// /// przycisk połączenia /// private void connButton_Click(object sender, EventArgs e) { string connetionString, sql = ""; login = loginTextBox1.Text; password = loginTextBox2.Text; SqlConnection DBconnect; connetionString = @"Data Source=mssql-2017.labs.wmi.amu.edu.pl;Initial Catalog=s434903_inzopr2019z;User ID=s444513;Password=Gxrbqfvw7L"; DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "SELECT * FROM Studenci WHERE Imie LIKE '" + login + "' AND Nazwisko LIKE '" + password + "';"; SqlCommand command = new SqlCommand(sql, DBconnect); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { reader.Read(); string semester; semester = reader.GetValue(3).ToString(); if (semester.CompareTo("0") != 0) { StudentWin next = new StudentWin(login, password, semester); next.Show(); this.Hide(); } else { AdmWin next = new AdmWin(login, password); next.Show(); this.Hide(); } } else { MessageBox.Show("Nie znaleźono rekordu."); } reader.Close(); DBconnect.Close(); }
/// /// metoda odpowiedzialna za akcje przycisków w tabeli /// private void tabela1_CellContentClick(object sender, DataGridViewCellEventArgs e) { string connetionString, sql = ""; SqlConnection DBconnect; connetionString = @"Data Source=mssql-2017.labs.wmi.amu.edu.pl;Initial Catalog=s434903_inzopr2019z;User ID=s444513;Password=Gxrbqfvw7L"; var senderGrid = (DataGridView)sender; if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.ColumnIndex == 4) { var wartośćKonkretnejKomórki = senderGrid.Rows[e.RowIndex].Cells[0].Value; String[] name = wartośćKonkretnejKomórki.ToString().Split(' '); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "select Id from Studenci where Imie ='" + name[0] + "' and Nazwisko ='" + name[1] + "'"; SqlCommand command6 = new SqlCommand(sql, DBconnect); SqlDataReader reader6 = command6.ExecuteReader(); if (reader6.HasRows) { reader6.Read(); string id; id = reader6.GetValue(0).ToString(); PreviewShedule shedule = new PreviewShedule(id, name[0], name[1]); shedule.Show(); } reader6.Close(); DBconnect.Close(); } if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.ColumnIndex == 2) { var wartośćKonkretnejKomórki = senderGrid.Rows[e.RowIndex].Cells[0].Value; String[] name = wartośćKonkretnejKomórki.ToString().Split(' '); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "select Id from Studenci where Imie ='" + name[0] + "' and Nazwisko ='" + name[1] + "'"; SqlCommand command3 = new SqlCommand(sql, DBconnect); SqlDataReader reader3 = command3.ExecuteReader(); if (reader3.HasRows) { reader3.Read(); string id; id = reader3.GetValue(0).ToString(); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "update Plan_Zajec set status = 'zatwierdzony' where Studenci_Id =" + id; SqlCommand command4 = new SqlCommand(sql, DBconnect); SqlDataReader reader4 = command4.ExecuteReader(); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "select Zajecia_Id from Plan_Zajec where Studenci_Id=" + id;; SqlCommand command5 = new SqlCommand(sql, DBconnect); SqlDataReader reader5 = command5.ExecuteReader(); if (reader5.HasRows) { for (int i = 0; i <= 3; i++) { reader5.Read(); string zajecia_id; zajecia_id = reader5.GetValue(0).ToString(); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "select Ilosc_Miejsc from Zajecia where Id=" + zajecia_id; SqlCommand command6 = new SqlCommand(sql, DBconnect); SqlDataReader reader6 = command6.ExecuteReader(); if (reader6.HasRows) { int ilo_miejsc; string ilosc_miejsc; reader6.Read(); ilosc_miejsc = reader6.GetValue(0).ToString(); ilo_miejsc = Convert.ToInt32(ilosc_miejsc); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "update Zajecia set Ilosc_Miejsc =" + (ilo_miejsc - 1) + " where Id=" + zajecia_id; SqlCommand command7 = new SqlCommand(sql, DBconnect); SqlDataReader reader7 = command7.ExecuteReader(); reader7.Close(); DBconnect.Close(); } reader6.Close(); DBconnect.Close(); } } reader4.Close(); DBconnect.Close(); reader5.Close(); DBconnect.Close(); MessageBox.Show("Zaakceptowano pomyślnie"); AdmWin next = new AdmWin("Admin", "Admin"); next.Show(); this.Hide(); } reader3.Close(); DBconnect.Close(); } if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.ColumnIndex == 3) { var wartośćKonkretnejKomórki = senderGrid.Rows[e.RowIndex].Cells[0].Value; String[] name = wartośćKonkretnejKomórki.ToString().Split(' '); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "select Id from Studenci where Imie ='" + name[0] + "' and Nazwisko ='" + name[1] + "'"; SqlCommand command5 = new SqlCommand(sql, DBconnect); SqlDataReader reader5 = command5.ExecuteReader(); if (reader5.HasRows) { reader5.Read(); string id; id = reader5.GetValue(0).ToString(); DBconnect = new SqlConnection(connetionString); DBconnect.Open(); sql = "delete Plan_Zajec where Studenci_Id =" + id; SqlCommand command6 = new SqlCommand(sql, DBconnect); SqlDataReader reader6 = command6.ExecuteReader(); MessageBox.Show("Odrzucono pomyślnie"); AdmWin next = new AdmWin("Admin", "Admin"); next.Show(); this.Hide(); reader6.Close(); DBconnect.Close(); } reader5.Close(); DBconnect.Close(); } }