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);
}
