public bool ExisteAvisoEnVigencia(string IdentifIdentAtencion)
{
string qry = @"SELECT COUNT(1)
FROM AvisosIdAten
JOIN Avisos ON AvisosIdAten.IdentifAviso = Avisos.IdentifAviso
WHERE AvisosIdAten.IdentifIdentAte = '{0}'
AND Avisos.VigHasta > GETDATE() AND Avisos.DatareaId = " + DAOHelper.DatareaId;
qry = string.Format(qry, IdentifIdentAtencion);
return(Convert.ToInt32(DAOHelper.EjecutarScalar(qry)) > 0);
}
public int GetLastRecId()
{
object aux = DAOHelper.EjecutarScalar("SELECT MAX(RECID) FROM ESTIMADODET");
if (aux is DBNull)
{
return(0);
}
else
{
return(Convert.ToInt32(aux));
}
}
public string GetSqlVersion()
{
return(Convert.ToString(DAOHelper.EjecutarScalar("SELECT SERVERPROPERTY('productversion')")));
}
public string AnoMesCierreOrd()
{
return(Convert.ToString(DAOHelper.EjecutarScalar("SELECT AnoMesCierreOrd FROM dbo.SetUp ")));
}
