public ActionResult UpdateTmplVars(TemplateVariableModel tmplVar)
{
if (tmplVar.Description.Length < 1 || tmplVar.Name.Length < 1 || tmplVar.Value.Length < 1)
{
ModelState.AddModelError("Template Variable", "Template Variable should have a name, a description and a value");
}
if (!ModelState.IsValid)
{
return(Json(ModelState));
}
using (var dbContext = new SarahIncContext())
{
var tplVar = (from t in dbContext.TemplateVariable
where t.TmplId == tmplVar.TmplId
select t).FirstOrDefault();
if (tplVar == null)
{
return(Json(ModelState));
}
tplVar.UserId = tmplVar.UserId;
tplVar.Description = tmplVar.Description;
tplVar.Name = tmplVar.Name;
tplVar.Value = tmplVar.Value;
dbContext.SaveChanges();
}
// Return the updated tmplVar. Also return any validation errors.
return(Json(ModelState));
}
public ActionResult DeleteUsers(TemplateVariableModel tpl)
{
if (!ModelState.IsValid)
{
return(Json(ModelState));
}
using (var dbContext = new SarahIncContext())
{
var tmplVar = (from t in dbContext.TemplateVariable
where t.TmplId == tpl.TmplId
select t).FirstOrDefault();
if (tmplVar == null)
{
return(Json(ModelState));
}
dbContext.TemplateVariable.Remove(tmplVar);
dbContext.SaveChanges();
}
// Return the updated tpl. Also return any validation errors.
return(Json(ModelState));
}
