public List <ErrorDetails> Get(string userName, int daemonId) { string commandText = ErrorDetails.GetQuery(); List <ErrorDetails> errorDetails = new List <ErrorDetails>(); using (MySqlConnection sConn = new MySqlConnection(Database.ConnectionString)) { sConn.Open(); MySqlCommand command = new MySqlCommand(commandText, sConn); command.Parameters.Add("@Username", MySqlDbType.VarChar); command.Parameters.Add("@DaemonId", MySqlDbType.Int32); command.Parameters["@UserName"].Value = userName; command.Parameters["@DaemonId"].Value = daemonId; try { MySqlDataReader sRead = command.ExecuteReader(); while (sRead.Read()) { errorDetails.Add(new ErrorDetails() { Id = Convert.ToInt32(sRead[0]), AffectedFiles = Convert.ToInt32(sRead[1]), Problem = sRead[2].ToString(), BackupId = Convert.ToInt32(sRead[3]), DaemonId = Convert.ToInt32(sRead[4]), DaemonName = sRead[5].ToString(), Solved = Convert.ToBoolean(sRead[6]), ProblemPath = sRead[7].ToString(), Time = sRead[8].ToString() }); } if (errorDetails.Count == 0) { errorDetails.Add(new ErrorDetails() { Problem = "N" }); } } catch { errorDetails.Add(new ErrorDetails() { Problem = "N" }); } sConn.Close(); } return(errorDetails); }