private void button1_Click(object sender, EventArgs e) { try { bool isvalidated = validatefields(); if (isvalidated) { NotAvailableTime notAvailableTime = new NotAvailableTime(); notAvailableTime.Lecturer = LectuercomboBox.SelectedItem.ToString(); notAvailableTime.GroupID = GroupcomboBox.SelectedItem.ToString(); notAvailableTime.SubGroupID = SubGroupcomboBox.SelectedItem.ToString(); notAvailableTime.SessionID = SessionIDtextBox.Text; notAvailableTime.Time = TimetextBox.Text; string message = NotAvailableTimeController.AddNotAvailableTime(notAvailableTime); MessageBox.Show(message); clear(); } else { MessageBox.Show("please fill in all fields!"); } } catch (NullReferenceException nre) { MessageBox.Show("please fill in all fields!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dataGridView6_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { try { if (e.RowIndex >= 0) { DataGridViewRow row = dataGridView6.Rows[e.RowIndex]; int NotAvailableTimeID = Convert.ToInt32(row.Cells[0].Value.ToString()); NotAvailableTime notAvailableTime = NotAvailableTimeController.SelectedNotAvailableTime(NotAvailableTimeID); if (notAvailableTime != null) { Hidelabel55.Text = notAvailableTime.NotAvailableTimeID.ToString(); } else { Hidelabel55.Text = string.Empty; } } } catch (FormatException fe) { MessageBox.Show("no data selected"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static NotAvailableTime SelectedNotAvailableTime(int notAvailableTimeid) { string query = "SELECT NotAvailableTimeID, Lecturer, GroupID, SubGroupID, SessionID, Time " + " FROM notavailabletime where NotAvailableTimeID = " + notAvailableTimeid; MySqlConnection databaseConnection = new MySqlConnection(connectionString); MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); commandDatabase.CommandTimeout = 60; MySqlDataReader reader; try { databaseConnection.Open(); reader = commandDatabase.ExecuteReader(); if (reader.HasRows) { NotAvailableTime notAvailableTime = new NotAvailableTime(); if (reader.Read()) { notAvailableTime.NotAvailableTimeID = reader.GetInt32(0); notAvailableTime.Lecturer = reader.GetString(1); notAvailableTime.GroupID = reader.GetString(2); notAvailableTime.SubGroupID = reader.GetString(3); notAvailableTime.SessionID = reader.GetString(4); notAvailableTime.Time = reader.GetString(5); } return(notAvailableTime); } else { Console.WriteLine("No rows found."); } databaseConnection.Close(); return(null); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public static string AddNotAvailableTime(NotAvailableTime notavailabletime) { string query = "INSERT INTO notavailabletime(`Lecturer`,`GroupID`,`SubGroupID`," + "`SessionID`,`Time`) " + "VALUES " + "('" + notavailabletime.Lecturer + "', '" + notavailabletime.GroupID + "', '" + notavailabletime.SubGroupID + "', '" + notavailabletime.SessionID + "', " + "'" + notavailabletime.Time + "')"; MySqlConnection databaseConnection = new MySqlConnection(connectionString); MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); commandDatabase.CommandTimeout = 60; try { databaseConnection.Open(); MySqlDataReader myReader = commandDatabase.ExecuteReader(); databaseConnection.Close(); return("User succesfully registered"); } catch (Exception ex) { return(ex.Message); } }