public int AddDataToDeadlockTable(string lockType, string lockTable, int lockObject, int idTransaction, List <int> transWait) { int nextDeadlockId = GetNextDeadlockId(); string transWaitLock = GetStringForm(transWait); if (dbCon.OpenConnection() == true) { String query = "INSERT INTO `deadlock` (`id`, `lockType`, `lockTable`, `lockObject`, `transThisLock`, `transWaitsLock`) VALUES (@id, @lockType, @lockTable, @lockObject, @transThisLock, @transWaitsLock)"; var cmd = new MySqlCommand(query, dbCon.Connection); cmd.Parameters.AddWithValue("@lockType", lockType); cmd.Parameters.AddWithValue("@lockObject", lockObject); cmd.Parameters.AddWithValue("@lockTable", lockTable); cmd.Parameters.AddWithValue("@transThisLock", idTransaction); cmd.Parameters.AddWithValue("@transWaitsLock", transWaitLock); try { cmd.Parameters.AddWithValue("@id", nextDeadlockId); int result = cmd.ExecuteNonQuery(); dbCon.CloseConnection(); if (result < 0) { Console.WriteLine("Error inserting data into Database!"); } else { return(nextDeadlockId); } } catch (Exception) { nextDeadlockId = nextDeadlockId + idTransaction; cmd.Parameters.RemoveAt("@id"); cmd.Parameters.AddWithValue("@id", nextDeadlockId); int result = cmd.ExecuteNonQuery(); dbCon.CloseConnection(); if (result < 0) { Console.WriteLine("Error inserting data into Database!"); } else { return(nextDeadlockId); } } } return(0); }
public List <Student> GetAllStudents() { string query = "SELECT * FROM student"; List <Student> students = new List <Student>(); if (dbCon.OpenConnection() == true) { var cmd = new MySqlCommand(query, dbCon.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { string idString = reader["id"].ToString(); string nume = reader["Nume"].ToString(); string varstaString = reader["Varsta"].ToString(); string nrMatricolString = reader["NrMatricol"].ToString(); int id = Convert.ToInt32(idString); int varsta = Convert.ToInt32(varstaString); int nrMatricol = Convert.ToInt32(nrMatricolString); Student student = new Student(id, nume, varsta, nrMatricol); students.Add(student); } } dbCon.CloseConnection(); } return(students); }
public bool checkIfTableExists() { if (dbCon.OpenConnection() == true) { String query = "SELECT table_name FROM information_schema.tables WHERE table_schema = 'management' AND table_name = 'lock'"; var cmd = new MySqlCommand(query, dbCon.Connection); var reader = cmd.ExecuteReader(); if (reader.HasRows == true) { dbCon.CloseConnection(); return(true); } else { dbCon.CloseConnection(); return(false); } } return(false); }