//////////////////////== Create ==////////////////////////////
public static void addCert(string title, string text, int reqNum, string image_path, bool inActive)
{
try {
B2BDataContext db = new B2BDataContext();
B2BCertificate newCertificate = new B2BCertificate();
newCertificate.title = title;
newCertificate.text = text;
newCertificate.requirementNum = reqNum;
newCertificate.image_path = image_path;
newCertificate.date_added = DateTime.Now;
newCertificate.date_modified = DateTime.Now;
newCertificate.inactive = inActive;
db.B2BCertificates.InsertOnSubmit(newCertificate);
db.SubmitChanges();
} catch (Exception e) {
throw new Exception("Could not add certificate: " + e.Message);
}
}
public ActionResult EditCert(int id, string title, string text, int reqNum, string logo, string inactive)
{
ViewBag.error = "";
if (id > 0) {
Boolean inActive = false;
inActive = (inactive == "on") ? true : false;
// retrieve the cert with the id
try {
B2BDataContext db = new B2BDataContext();
B2BCertificate cert = new B2BCertificate();
cert = db.B2BCertificates.Where(x => x.id == id).FirstOrDefault<B2BCertificate>();
cert.title = title;
cert.text = text;
cert.requirementNum = reqNum;
cert.image_path = logo;
cert.inactive = inActive;
db.SubmitChanges();
ViewBag.cert = cert;
ViewBag.msg = "The certificate changes have been made.";
} catch (Exception e) {
ViewBag.error = e.Message;
}
} else {
return RedirectToAction("Index");
}
return View();
}
public static B2BCertificate getCertificate(int certID)
{
try {
B2BDataContext db = new B2BDataContext();
B2BCertificate cert = new B2BCertificate();
cert = db.B2BCertificates.Where(x => x.id == certID).Select(x => x).FirstOrDefault<B2BCertificate>();
return cert;
} catch (Exception e) {
throw new Exception("Could not load certificate: " + e.Message);
}
}
///////////////////////== Delete ==/////////////////////////
public static string DeleteCert(int id)
{
try {
B2BDataContext db = new B2BDataContext();
B2BCertificate cert = new B2BCertificate();
cert = db.B2BCertificates.Where(x => x.id == id).FirstOrDefault<B2BCertificate>();
db.B2BCertificates.DeleteOnSubmit(cert);
db.SubmitChanges();
return "";
} catch (Exception e) {
return "Error while deleting" + e.Message;
}
}
