public static bool editSource(Models.SourceCrud source)
{
bool result = false;
try
{
using (var _db = new Models.BleacherDb())
{
var sourceObj = (from x in _db.Sources where x.Id == source.Id select x).FirstOrDefault();
if (sourceObj != null)
{
sourceObj.Name = source.Name;
sourceObj.Active = source.Active;
int aff = _db.SaveChanges();
if (aff > 0)
{
result = true;
}
}
}
} catch (Exception e)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(e);
}
return(result);
}
public static void editcachedRow(Models.SourceCrud edited, string sessionid)
{
try
{
List <Models.Source> cachedSources = (List <Models.Source>)HttpRuntime.Cache["FileSources." + sessionid];
if (cachedSources != null)
{
var sourceRow = (from x in cachedSources where x.Id == edited.Id select x).FirstOrDefault();
sourceRow.Name = edited.Name;
sourceRow.Active = edited.Active;
insertIntoCache(cachedSources, sessionid);
}
} catch (Exception e)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(e);
}
}
public ActionResult editSources()
{
System.Collections.Specialized.NameValueCollection RequestParams = ControllerContext.RequestContext.HttpContext.Request.Params;
bool result = false;
if (RequestParams.Count > 0)
{
Helpers.jqGrid <Models.SourceCrud> jqgrid = new Helpers.jqGrid <Models.SourceCrud>();
Models.SourceCrud crudVars = jqgrid.getReqParamsAsObject(RequestParams);
if (crudVars == null)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
Models.Source rowToEdit = Helpers.SourcesAdapter.getcachedRow(crudVars.Id, cachedSessionId);
if (rowToEdit != null && crudVars.oper != null)
{
if (crudVars.oper == "edit")
{
if (Helpers.SourcesAdapter.editSource(crudVars))
{
result = false;
Helpers.SourcesAdapter.editcachedRow(crudVars, cachedSessionId);
}
}
else if (crudVars.oper == "del")
{
if (Helpers.SourcesAdapter.deleteSourceAsync(rowToEdit))
{
result = true;
}
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
