public static int GeraId(string table)
{
try
{
return(Convert.ToInt32(MySQLDao.GetRegistros(table, " max(id) as id ").Rows[0]["id"]) + 1);
}
catch
{
return(1);
}
}
public static DataTable GetCursos(string select = "*", string where = "")
{
return(MySQLDao.GetRegistros("curso", select, where));
}
public static DataTable GetAuditorias(string where = "")
{
return(MySQLDao.GetRegistros("auditoria_operacao", "*", " where not (operacao = 'U' and coluna_alterada = 'diploma_validado' and ((date_sub({fn now()}, interval 40 year)) >= data_operacao))"));
}
public static DataTable GetInstituicoes(string where = "", string select = "*")
{
return(MySQLDao.GetRegistros("instituicao", select, where));
}
public static DataTable GetDiplomas(string select = "*", string where = "")
{
return(MySQLDao.GetRegistros("diploma", select, where));
}