public BM_BlurbCategory getBlurbCategoryWithID(string ID)
{
BM_BlurbCategory blurbCat = new BM_BlurbCategory();
string query = "SELECT id, categoryName, categoryDescription FROM hectorhaas.precheckBlurbCategories WHERE id = " + ID;
DataTable dt = DataAccess.getAnyDataTable(query);
blurbCat.id = ID;
blurbCat.categoryName = dt.Rows[0]["categoryName"].ToString();
blurbCat.categoryDescription = dt.Rows[0]["categoryDescription"].ToString();
return(blurbCat);
}
public List<BM_BlurbCategory> getAllBlurbCategories()
{
List<BM_BlurbCategory> catList = new List<BM_BlurbCategory>();
string query = "SELECT id, categoryName, categoryDescription FROM hectorhaas.precheckBlurbCategories ORDER BY categoryName ASC";
DataTable dt = DataAccess.getAnyDataTable(query);
for (int i = 0;i<dt.Rows.Count;i++)
{
BM_BlurbCategory blurbCat = new BM_BlurbCategory();
blurbCat.id = dt.Rows[i]["id"].ToString();
blurbCat.categoryName = dt.Rows[i]["categoryName"].ToString();
blurbCat.categoryDescription = dt.Rows[i]["categoryDescription"].ToString();
catList.Add(blurbCat);
}
return catList;
}
public List <BM_BlurbCategory> getAllBlurbCategories()
{
List <BM_BlurbCategory> catList = new List <BM_BlurbCategory>();
string query = "SELECT id, categoryName, categoryDescription FROM hectorhaas.precheckBlurbCategories ORDER BY categoryName ASC";
DataTable dt = DataAccess.getAnyDataTable(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
BM_BlurbCategory blurbCat = new BM_BlurbCategory();
blurbCat.id = dt.Rows[i]["id"].ToString();
blurbCat.categoryName = dt.Rows[i]["categoryName"].ToString();
blurbCat.categoryDescription = dt.Rows[i]["categoryDescription"].ToString();
catList.Add(blurbCat);
}
return(catList);
}
public BM_BlurbCategory getBlurbCategoryWithID(string ID)
{
BM_BlurbCategory blurbCat = new BM_BlurbCategory();
string query = "SELECT id, categoryName, categoryDescription FROM hectorhaas.precheckBlurbCategories WHERE id = " + ID;
DataTable dt = DataAccess.getAnyDataTable(query);
blurbCat.id = ID;
blurbCat.categoryName = dt.Rows[0]["categoryName"].ToString();
blurbCat.categoryDescription = dt.Rows[0]["categoryDescription"].ToString();
return blurbCat;
}
public void addBlurbCategory(BM_BlurbCategory category)
{
string query = "INSERT INTO hectorhaas.precheckBlurbCategories (categoryName, categoryDescription) VALUES ('"+ cleanText(category.categoryName)+"', '"+ cleanText(category.categoryDescription)+"')";
DataAccess.justExecuteQuery(query);
}
public void addBlurbCategory(BM_BlurbCategory category)
{
string query = "INSERT INTO hectorhaas.precheckBlurbCategories (categoryName, categoryDescription) VALUES ('" + cleanText(category.categoryName) + "', '" + cleanText(category.categoryDescription) + "')";
DataAccess.justExecuteQuery(query);
}
