// Data Source -- update category
public bool DSupdateCategory(Category category)
{
try
{
// set adapter
cta = new canoeDataSetTableAdapters.Canoe_CategoryTableAdapter();
// update
cta.UpdateCategoryQuery(
category.Type,
category.Description,
category.CID
);
return true;
}
catch (Exception ex)
{
throw new CanoeException("DSupdateCategory", ex.Message);
}
}
// Data Source -- delete category
public bool DSdeleteCategory(string cID)
{
try
{
// set adapter
cta = new canoeDataSetTableAdapters.Canoe_CategoryTableAdapter();
// delete
cta.DeleteCategoryQuery(int.Parse(cID));
return true;
}
catch (Exception ex)
{
throw new CanoeException("DSdeleteCategory", ex.Message);
}
}
// Data Source -- search category
public DataTable DSsearchCategory()
{
try
{
// set adapter
cta = new canoeDataSetTableAdapters.Canoe_CategoryTableAdapter();
cdt = new canoeDataSet.Canoe_CategoryDataTable();
cta.FillCategoryByNone(cdt);
return cdt;
}
catch (Exception ex)
{
throw new CanoeException("DSsearchCategory", ex.Message);
}
}
