private static void Create(Exception ex)
{
if (ex.Message.Contains("doesn't exist"))
{
CreateTable();
ConsultasRecebidas.CreateTable();
}
}
public static ConsultasRecebidas Select(int id)
{
var c = new MySqlCommand();
c.CommandText = $"select {nameof(Consulta)}, {nameof(Valor)} from {Name} where {nameof(Consulta)} = @id;";
c.Parameters.AddWithValue("@id", id);
ConsultasRecebidas cr = null;
QueryRLoop("Erro ao obter consulta recebida.", c, (r) => {
cr = new ConsultasRecebidas();
cr.Consulta = id;
cr.Valor = r.GetDouble(1);
}, (ex) => {
if (ex.Message.Contains("doesn't exist"))
{
CreateTable();
}
}, true);
return(cr);
}
