protected string GetStorefront()
{
string sql = "Select * from Products WHERE deleted=0 order by Title";
sql = "Select * from Products where deleted=0 Order by Title";
DataTable dt = gData.GetDataTable2(sql);
string html = "<table><tr>";
int iTD = 0;
for (int y = 0; y < dt.Rows.Count; y++)
{
string div = ZincOps.GetAmazonItem(dt.Rows[y], false);
html += div + "\r\n";
iTD++;
if (iTD == 3)
{
iTD = 0;
html += "</tr><tr>";
}
}
// Check for quizzes
html += "</table>";
return(html);
}
public string GetAmzItem(bool fBuying)
{
string sID = Request.QueryString["buyid"].ToNonNullString();
string sql = "Select * from Products Where id='" + BMS.PurifySQL(sID, 200) + "' and deleted=0";
DataTable dt = gData.GetDataTable2(sql);
if (dt.Rows.Count < 1)
{
return("");
}
string div = ZincOps.GetAmazonItem(dt.Rows[0], fBuying);
return(div);
}
