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