public ActionResult UpdateGridSortOrder(Dictionary <int, int> items)
{
var message = "Updated grid sortorder";
try
{
var dbHelper = new DatabaseHelper();
if (items.Count > 0)
{
foreach (var item in items)
{
// Key = id, Value = SortOrder
dbHelper.UpdateGridSortOrder(item.Key, item.Value);
}
}
// Update runtimecache
var editors = dbHelper.GetEditors();
RuntimeCacheHelper.SetCacheItem("LeBlenderEditors", editors, 1);
}
catch (Exception ex)
{
message = "Error while trying to update grid sortorder";
LogHelper.Error <HelperController>("Error while trying to update grid sortorder in the database", ex);
}
return(Json(new { Message = message }));
}
public ActionResult UpdateEditor(string editor)
{
var message = "Grid editor has been saved";
try
{
var gridEditor = JsonConvert.DeserializeObject <LeBlenderGridEditorModel>(editor);
var dbHelper = new DatabaseHelper();
var LeBlenderGridEditorId = dbHelper.InsertOrUpdateGridEditor(gridEditor);
if (gridEditor.Config.Count > 0)
{
dbHelper.InsertOrUpdateConfig(LeBlenderGridEditorId, gridEditor.Config);
}
// Update runtimecache
var editors = dbHelper.GetEditors();
RuntimeCacheHelper.SetCacheItem("LeBlenderEditors", editors, 1);
}
catch (Exception ex)
{
LogHelper.Error <HelperController>($"Error while trying to update editor", ex);
message = $"{ex.Message} - {ex.InnerException?.Message}";
}
return(Json(new { Message = message }));
}
public ActionResult GetEditors()
{
// Check if they exist in cache
var editors = RuntimeCacheHelper.GetCachedItem <IOrderedEnumerable <LeBlenderGridEditorModel> >("LeBlenderEditors");
if (editors == null)
{
var dbHelper = new DatabaseHelper();
editors = dbHelper.GetEditors();
RuntimeCacheHelper.SetCacheItem("LeBlenderEditors", editors, 1);
}
return(Content(JsonConvert.SerializeObject(editors)));
}
public ActionResult TransferAllEditors(string editors)
{
if (IsValidDomain(Request.Url))
{
Response.Headers.Remove("Access-Control-Allow-Origin");
Response.AddHeader("Access-Control-Allow-Origin", Request.UrlReferrer.GetLeftPart(UriPartial.Authority));
Response.Headers.Remove("Access-Control-Allow-Credentials");
Response.AddHeader("Access-Control-Allow-Credentials", "true");
Response.Headers.Remove("Access-Control-Allow-Methods");
Response.AddHeader("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS");
}
else
{
Response.StatusCode = 403;
return(Content("Forbidden"));
}
var message = "Grideditors has been transferred successfully";
try
{
var gridEditors = JsonConvert.DeserializeObject <List <LeBlenderGridEditorModel> >(editors);
if (gridEditors != null && gridEditors.Any())
{
var dbHelper = new DatabaseHelper();
foreach (var gridEditor in gridEditors)
{
var gridEditorId = dbHelper.InsertOrUpdateGridEditor(gridEditor);
if (gridEditor.Config.Count > 0)
{
dbHelper.InsertOrUpdateConfig(gridEditorId, gridEditor.Config);
}
}
var savedEditors = dbHelper.GetEditors();
RuntimeCacheHelper.SetCacheItem("LeBlenderEditors", savedEditors, 1);
}
}
catch (Exception ex)
{
message = $"Error while transferring editor for database storage. Message: {ex.Message}";
LogHelper.Error <HelperController>(message, ex);
}
return(Content(message));
}
public ActionResult DeleteEditor(int id)
{
var message = $"Successfully deleted editor from the database";
try
{
var dbHelper = new DatabaseHelper();
dbHelper.DelteGridEditor(id);
var editors = dbHelper.GetEditors();
RuntimeCacheHelper.SetCacheItem("LeBlenderEditors", editors, 1);
}
catch (Exception ex)
{
message = $"Error while trying to delete GridEditor with id: {id} from the database";
LogHelper.Error <HelperController>($"Error while trying to delete editor with id: {id} from the database", ex);
}
return(Content(message));
}
public ActionResult DeleteAllEditors(string editors)
{
try
{
var gridEditors = JsonConvert.DeserializeObject <List <LeBlenderGridEditorModel> >(editors);
if (gridEditors != null && gridEditors.Any())
{
var dbHelper = new DatabaseHelper();
foreach (var gridEditor in gridEditors)
{
dbHelper.DelteGridEditor(gridEditor.Id);
}
var updatedEditors = dbHelper.GetEditors();
RuntimeCacheHelper.SetCacheItem("LeBlenderEditors", updatedEditors, 1);
}
return(Content("Deleted all editors from database"));
}
catch (Exception ex)
{
LogHelper.Error <HelperController>($"Error while trying to perform action: Delete All Editors", ex);
return(Content($"Error while trying to delete all editors. Error: {ex.Message}"));
}
}
