public bool IsUnique(int id, string term, string def) { using (CSE_DatabaseEntities dc = new CSE_DatabaseEntities()) { Glossary glossary; if (id > 0) { // Edit glossary = dc.Glossaries.Where(a => (a.ID == id)).FirstOrDefault(); if (glossary.Term == term && glossary.Definition != def) { //Definition Only Update return(true); } else if (glossary.Term == term && glossary.Definition == def) { //Update whileout Changes return(true); } else { //Updating Term return(IsUnique(term)); } } else { //Adding New Term return(IsUnique(term)); } } }
public ActionResult Save(Glossary gloss) { if (ModelState.IsValid) { using (CSE_DatabaseEntities dc = new CSE_DatabaseEntities()) { if (gloss.ID > 0) { //Edit var glossary = dc.Glossaries.Where(a => a.ID == gloss.ID).FirstOrDefault(); if (glossary != null) { glossary.Term = gloss.Term; glossary.Definition = gloss.Definition; } } else { //Save dc.Glossaries.Add(gloss); } dc.SaveChanges(); } } return(RedirectToAction("Index", "Home")); }
public ActionResult Save(int id) { using (CSE_DatabaseEntities dc = new CSE_DatabaseEntities()) { var glossary = dc.Glossaries.Where(a => a.ID == id).FirstOrDefault(); return(View(glossary)); } }
public ActionResult GetGlossaries() { using (CSE_DatabaseEntities dc = new CSE_DatabaseEntities()) { var glossaries = dc.Glossaries.OrderBy(a => a.Term).ToList(); return(Json(new { data = glossaries }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteGlossary(int id) { using (CSE_DatabaseEntities dc = new CSE_DatabaseEntities()) { var glossary = dc.Glossaries.Where(a => a.ID == id).FirstOrDefault(); if (glossary != null) { dc.Glossaries.Remove(glossary); dc.SaveChanges(); } return(RedirectToAction("Index", "Home")); } }
public bool IsUnique(string term) { using (CSE_DatabaseEntities dc = new CSE_DatabaseEntities()) { var glossary = dc.Glossaries.Where(a => a.Term == term).FirstOrDefault(); if (glossary == null) { return(true); } else { return(false); } } }
public ActionResult Delete(int id) { using (CSE_DatabaseEntities dc = new CSE_DatabaseEntities()) { var glossary = dc.Glossaries.Where(a => a.ID == id).FirstOrDefault(); if (glossary != null) { return(View(glossary)); } else { return(HttpNotFound()); } } }