public static DataSet GetMatchedAttributes(int birthNumber, string fortune, int nameNumber)
{
string query = "SELECT attribute.attribute as attribute " +
"FROM attribute INNER JOIN [attribute-birthnumber] ON attribute.Id = [attribute-birthnumber].IDattribute " +
"WHERE ((([attribute-birthnumber].birthNumber)={0})) " +
"UNION ALL " +
"SELECT attribute.attribute as attribute " +
"FROM fortune INNER JOIN (attribute INNER JOIN [attribute-fortune] ON attribute.Id = [attribute-fortune].IDattribute) ON fortune.Id = [attribute-fortune].IDfortune " +
"WHERE (((fortune.fortune)='{1}')) " +
"UNION ALL " +
"SELECT attribute.attribute as attribute " +
"FROM attribute INNER JOIN [attribute-namenumber] ON attribute.Id = [attribute-namenumber].IDattribute " +
"WHERE ((([attribute-namenumber].nameNumber)={2}))";
DataSet vDataset = null;
vDataset = MicrosoftAccessConnector.Recuperar_Consulta(string.Format(query, birthNumber, fortune, nameNumber));
return(vDataset);
}
public static string GetFAQContent()
{
string query = "SELECT content FROM cms WHERE Id=4";
DataSet vDataset = null;
vDataset = MicrosoftAccessConnector.Recuperar_Consulta(query);
DataTable tbl = vDataset.Tables[0];
string content = tbl.Rows[0]["content"].ToString();
return(content);
}
