public static long findCertificate(string name) { string sql = "SELECT CET_ID, CET_DESCRIPTION FROM ROS_CERTIFICATE_TYPE WHERE CET_DESCRIPTION = \"" + name + "\""; long retorno = -1; try { using (DatabaseROS db = new DatabaseROS()) { retorno = db.executeSelectScalarSQL(sql); } } catch (Exception ex) { throw ex; } return(retorno); }
public static long findCompany(string name) { string sql = "SELECT COM_ID FROM `ROS_COMPANY` WHERE COM_NAME=\"" + name + "\""; long retorno = -1; try { using (DatabaseROS db = new DatabaseROS()) { retorno = db.executeSelectScalarSQL(sql); } } catch (Exception ex) { throw ex; } return(retorno); }