public IActionResult EditColumns(GrantColumnsViewModel model)
{
var old_columns = GetColumns(model.SchemaName, model.TableName, model.Rolename)
.OrderBy(r => r.Column_name).ToList();
var columns = model.Columns.OrderBy(r => r.Column_name).ToList();
CompareColumnsGrants(old_columns, columns, out bool selChanged, out bool updChanged, out bool insChanged);
if (selChanged || updChanged || insChanged)
{
try
{
List <string> selectList = new List <string>();
List <string> updateList = new List <string>();
List <string> insertList = new List <string>();
foreach (var column in columns)
{
if (column.IsSelect)
{
selectList.Add(column.Column_name);
}
if (column.IsUpdate)
{
updateList.Add(column.Column_name);
}
if (column.IsInsert)
{
insertList.Add(column.Column_name);
}
}
_service.GrantColumnsToRole(model.SchemaName, model.TableName, model.Rolename,
selectList, updateList, insertList,
selChanged, updChanged, insChanged);
//TempData["message"] = $"Сохранено.";
//if (_device.Type.ToString().ToLower() == "desktop")
// return Json(new { ok = true, mobile = false });
//else
//{
// TempData["message"] = $"Сохранено.";
// return Json(new { ok = true, mobile = true, newurl = Url.Action("Index") });
//}
return(Json(new { ok = true, mobile = false }));
}
catch (Exception e)
{
//TempData["error"] = $"Warning. {e.Message}";
return(Json(new { ok = false, message = e.Message }));
}
}
return(Json(new { ok = true }));
}
public IActionResult EditColumns(string schema, string table, string rolename)
{
List <GrantColumn> columns = GetColumns(schema, table, rolename).ToList();
var model = new GrantColumnsViewModel
{
Columns = columns,
TableName = table,
SchemaName = schema,
Rolename = rolename
};
return(PartialView("EditGrantsColumnsModalPartial", model));
}
