public List<BM_Blurb> getAllBlurbsByCategory(string categoryID)
{
List<BM_Blurb> blurbList = new List<BM_Blurb>();
//get data
string query = "SELECT id, blurbText, categoryID FROM hectorhaas.precheckBlurbs WHERE categoryID = " + categoryID+" ORDER BY blurbText ASC";
DataTable dt = DataAccess.getAnyDataTable(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
BM_Blurb tempBlurb = new BM_Blurb();
tempBlurb.id = dt.Rows[i]["id"].ToString();
tempBlurb.categoryID = dt.Rows[i]["categoryID"].ToString();
tempBlurb.blurbText = dt.Rows[i]["blurbText"].ToString();
blurbList.Add(tempBlurb);
}
return blurbList;
}
public BM_Blurb getBlurbWithID(string blurbID)
{
BM_Blurb blurb = new BM_Blurb();
string query = "SELECT id, blurbText, categoryID FROM hectorhaas.precheckBlurbs WHERE id = " + blurbID;
DataTable dt = DataAccess.getAnyDataTable(query);
blurb.categoryID = dt.Rows[0]["categoryID"].ToString();
blurb.blurbText = dt.Rows[0]["blurbText"].ToString();
blurb.id = blurbID;
return blurb;
}
public void addBlurb(BM_Blurb blurb)
{
string query = "INSERT INTO hectorhaas.precheckBlurbs (blurbText, categoryID) VALUES ('"+cleanText(blurb.blurbText)+"', "+blurb.categoryID+")";
DataAccess.justExecuteQuery(query);
}