public static void addCat(int certID, string title, string text, string image_path, bool inActive)
{
try {
B2BDataContext db = new B2BDataContext();
B2BCategory newCat = new B2BCategory();
newCat.certID = certID;
newCat.title = title;
newCat.text = text;
newCat.image_path = image_path;
newCat.date_added = DateTime.Now;
newCat.date_modified = DateTime.Now;
newCat.inactive = inActive;
db.B2BCategories.InsertOnSubmit(newCat);
db.SubmitChanges();
} catch (Exception e) {
throw new Exception("Could not add category: " + e.Message);
}
}
public ActionResult EditCat(int id, string title, string text, string logo, string inactive)
{
ViewBag.error = "";
if (id > 0) {
Boolean inActive = false;
inActive = (inactive == "on") ? true : false;
// retrieve the cat with the id
try {
B2BDataContext db = new B2BDataContext();
B2BCategory cat = new B2BCategory();
cat = db.B2BCategories.Where(x => x.id == id).FirstOrDefault<B2BCategory>();
cat.title = title;
cat.text = text;
cat.image_path = logo;
cat.inactive = inActive;
db.SubmitChanges();
ViewBag.cat = cat;
ViewBag.msg = "The category changes have been made.";
} catch (Exception e) {
ViewBag.error = e.Message;
}
} else {
return RedirectToAction("Index");
}
return View();
}
public static B2BCategory getCategory(int catID)
{
try {
B2BDataContext db = new B2BDataContext();
B2BCategory cat = new B2BCategory();
cat = db.B2BCategories.Where(x => x.id == catID).Select(x => x).FirstOrDefault<B2BCategory>();
return cat;
} catch (Exception e) {
throw new Exception("Could not load category: " + e.Message);
}
}
public static string DeleteCat(int id)
{
try {
B2BDataContext db = new B2BDataContext();
B2BCategory cat = new B2BCategory();
cat = db.B2BCategories.Where(x => x.id == id).FirstOrDefault<B2BCategory>();
db.B2BCategories.DeleteOnSubmit(cat);
db.SubmitChanges();
return "";
} catch (Exception) {
return "Error while deleting";
}
}