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 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 void addBlurb(BM_Blurb blurb)
{
string query = "INSERT INTO hectorhaas.precheckBlurbs (blurbText, categoryID) VALUES ('" + cleanText(blurb.blurbText) + "', " + blurb.categoryID + ")";
DataAccess.justExecuteQuery(query);
}