public JsonResult Delete(int id) { try { DataClassesDataContext context = new Config().GetNewContext(); var urlObj = (from u in context.Urls where u.ID == id select u).First(); context.Urls.DeleteOnSubmit(urlObj); context.SubmitChanges(); return Json(true); } catch (Exception exc) { return Json(false); } }
public JsonResult Insert(FormCollection form) { try { string naam = form["naam"]; string url = form["url"]; int setting; if (!int.TryParse(form["setting"], out setting)) throw new ArgumentException(); try { if (!url.StartsWith("http://")) url = "http://" + url; Uri u = new Uri(url); url = u.ToString(); } catch { url = "[FOUT] " + url; } DataClassesDataContext context = new Config().GetNewContext(); Url urlObj = new Url(); urlObj.Naam = naam; urlObj.Url1 = url; urlObj.Settings = setting; context.Urls.InsertOnSubmit(urlObj); context.SubmitChanges(); return Json(urlObj.ID); } catch (Exception exc) { return Json(-1); } }
public JsonResult Update(FormCollection form) { try { int id; if(!int.TryParse(form["id"], out id)) throw new ArgumentException(); string naam = form["naam"]; string url = form["url"]; int setting; if(!int.TryParse(form["setting"], out setting)) throw new ArgumentException(); DataClassesDataContext context = new Config().GetNewContext(); var urlObj = (from u in context.Urls where u.ID == id select u).First(); urlObj.Naam = naam; urlObj.Url1 = url; urlObj.Settings = setting; context.SubmitChanges(); return Json(true); } catch (Exception exc) { return Json(false); } }