private void ShowBirthDate()
{
string sqlString = "SELECT BASE_CONTACTS.ID,ISNULL(BASE_CONTACTS.NAME,'')+' '+BASE_CONTACTS.SURNAME AS REFERENTE ";
sqlString += "FROM BASE_CONTACTS ";
sqlString += "WHERE (BASE_CONTACTS.LIMBO = 0) ";
sqlString += " AND ((BASE_CONTACTS.FLAGGLOBALORPERSONAL=2 AND BASE_CONTACTS.OWNERID=" + UC.UserId + ") OR (BASE_CONTACTS.FLAGGLOBALORPERSONAL<>2)) ";
sqlString += " AND (MONTH(BASE_CONTACTS.BIRTHDAY)=" + DateTime.Now.Month + " AND DAY(BASE_CONTACTS.BIRTHDAY)=" + DateTime.Now.Day + ");";
ContactBirthDate.DataSource = DatabaseConnection.CreateDataset(sqlString);
ContactBirthDate.DataBind();
if (ContactBirthDate.Items.Count > 0)
{
ContactBirthDate.Visible = true;
ContactBirthDateInfo.Visible = false;
}
else
{
ContactBirthDate.Visible = false;
ContactBirthDateInfo.Visible = true;
ContactBirthDateInfo.Text = Root.rm.GetString("Deftxt27");
}
}