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