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());
}
}
}
