public ActionResult App(AjaxPersonaAppRolesForTable model, string submitButton)
{
switch (submitButton)
{
case "addRole": return(addColumn(model));
case "save": return(saveModel(model));
default:
#region Remove column
if (submitButton.StartsWith("removeColumn"))
{
int colIndex = Convert.ToInt32(submitButton.Substring("removeColumn".Length));
model.ColHeaders[colIndex].IsDeleted = true;
if (model.DeletedCols == null)
{
model.DeletedCols = new List <int>();
}
model.DeletedCols.Add(colIndex);
}
#endregion
break;
}
return(View("App", model));
}
private ActionResult addColumn(AjaxPersonaAppRolesForTable model)
{
var context = COREobject.i.Context;
#region ColHeader
int priority;
if (context.AppRoles.Count(r => r.ApplicationId == model.AppID) > 0)
{
priority = context.AppRoles.Where(r => r.ApplicationId == model.AppID).Max(r => r.Priority) + 1;
}
else
{
priority = 1;
}
ColumnHeaderAppRolesForTable newColHeader = new ColumnHeaderAppRolesForTable(-1, "New role", priority);
if (model.ColHeaders == null)
{
model.ColHeaders = new List <ColumnHeaderAppRolesForTable>();
}
model.ColHeaders.Add(newColHeader);
context.AppRoles.Add(new PersonaAppRole {
Name = "New role", Priority = priority, ApplicationId = model.AppID
});
/*context.SaveChanges();*/
#endregion
#region Data
if (model.Data == null)
{
model.Data = new List <bool[]>();
}
model.Data.Add(new bool[model.RowHeaders.Count]);
#endregion
return(View("App", model));
}
private ActionResult removeColumn(AjaxPersonaAppRolesForTable model, int columnIndex)
{
model.ColHeaders[columnIndex].IsDeleted = true;
return(View("App", model));
}
// GET: Roles
public ActionResult App(int Id)
{
ViewBag.Saved = false;
DBEntities masterContext = COREobject.i.Context;
Application masterApp = masterContext.Applications.Find(Id);
DBEntities context = COREobject.i.AppContext;
Application app = masterApp.similarApp;
if (app == null)
{
app = new Application();
app.CopyPropertiesFrom(masterApp, skip: new string[] { "Id" });
context.Applications.Add(app);
context.SaveChanges();
}
#region Basic variables declaration
List <ColumnHeaderAppRolesForTable> colHeaders = new List <ColumnHeaderAppRolesForTable>();
List <RowHeaderAppRolesForTable> rowHeaders = new List <RowHeaderAppRolesForTable>();
List <bool[]> data = new List <bool[]>(); //bool[] jsou sloupce, List jsou radky
#endregion
#region Rows headers
if (masterApp.IsAllowedForAll)
{
foreach (User u in masterContext.Users)
{
rowHeaders.Add(new RowHeaderAppRolesForTable(u.Id, u.DisplayName));
}
}
else
{
//find ad_group =>
ADgroup adg = masterContext.ADgroups.SingleOrDefault(i => i.ApplicationId == Id);
if (adg != null)
{
foreach (ADgroup_User adgu in adg.ADgroup_Users)
{
rowHeaders.Add(new RowHeaderAppRolesForTable(adgu.User.Id, adgu.User.DisplayName));
}
}
}
#endregion
#region Column headers + data
IQueryable <PersonaAppRole> roles = context.AppRoles.Where(c => c.ApplicationId == app.Id);
int x = 0;
foreach (PersonaAppRole role in roles)
{
#region Data column prepare
//Creating a column length of rowHeaders.Count
bool[] boolColumn = new bool[rowHeaders.Count];
data.Add(boolColumn);
#endregion
colHeaders.Add(new ColumnHeaderAppRolesForTable(role.Id, role.Name, role.Priority));
#region Data
List <int> MemberList = role.getUsers_roles(masterContext).Select(u => u.UserId).ToList();
for (int y = 0; y < MemberList.Count; y++)
{
int currID = MemberList[y];
int index = 0;
for (; index < rowHeaders.Count; index++)
{
if (currID == rowHeaders[index].Id)
{
break;
}
if (index == rowHeaders.Count + 1)
{
throw new IndexOutOfRangeException("There is no user with this ID");
}
}
if (index == rowHeaders.Count)
{
data[x][index - 1] = true;
}
else
{
data[x][index] = true;
}
}
#endregion
x++;
}
#endregion
AjaxPersonaAppRolesForTable model = new AjaxPersonaAppRolesForTable(colHeaders, rowHeaders, data);
model.AppName = app.DisplayName;
model.AppID = app.Id;
return(View("App", model));
}
private ActionResult saveModel(AjaxPersonaAppRolesForTable model)
{
#region Column headers validation
foreach (ColumnHeaderAppRolesForTable colHeader in model.ColHeaders)
{
colHeader.Name = colHeader.Name.Trim();
if (String.IsNullOrWhiteSpace(colHeader.Name))
{
ViewBag.BadNameRole = true;
ViewBag.Saved = false;
return(View("App", model));
}
}
for (int i = 0; i < model.ColHeaders.Count; i++)
{
ColumnHeaderAppRolesForTable currHeader = model.ColHeaders[i];
for (int j = i + 1; j < model.ColHeaders.Count; j++)
{
if (model.DeletedCols == null || (!model.DeletedCols.Contains(i) && !model.DeletedCols.Contains(j)))
{
if (currHeader.Name == model.ColHeaders[j].Name)
{
ViewBag.RolesAreEqual = true;
ViewBag.Saved = false;
return(View("App", model));
}
}
}
if (String.IsNullOrEmpty(currHeader.Priority.ToString()) || currHeader.Priority == 0)
{
ViewBag.BadPriorityRole = true;
ViewBag.Saved = false;
return(View("App", model));
}
}
#endregion
#region Save model
var context = COREobject.i.Context;
Application app = context.Applications.Find(model.AppID);
#region Column headers + data
IQueryable <PersonaAppRole> roles = context.AppRoles.Where(c => c.ApplicationId == app.Id);
#region Save columns
int x = 0;
foreach (ColumnHeaderAppRolesForTable colHeader in model.ColHeaders)
{
if (model.DeletedCols == null || !model.DeletedCols.Contains(x))
{
#region Add or update column
#region New users IDs - Data for this column
List <int> NewUsersIDsList = new List <int>();
for (int y = 0; y < model.RowHeaders.Count; y++)
{
if (model.Data[x][y] == true)
{
NewUsersIDsList.Add(model.RowHeaders[y].Id);
}
}
#endregion
if (colHeader.Id != -1)
{
#region Update role
PersonaAppRole realRole = roles.FirstOrDefault(a => a.Id == colHeader.Id);
if (realRole != null)
{
#region Role name
if (realRole.Name != colHeader.Name)
{
realRole.Name = colHeader.Name;
}
if (realRole.Priority != colHeader.Priority)
{
realRole.Priority = colHeader.Priority;
}
#endregion
context.Users_Roles.RemoveRange(context.Users_Roles.Where(r => r.RoleName == realRole.Name && r.ApplicationId == realRole.ApplicationId));
foreach (int id in NewUsersIDsList)
{
context.Users_Roles.Add(new User_Role()
{
RoleName = realRole.Name, Application = realRole.Application, UserId = id
});
}
context.SaveChanges();
}
#endregion
}
else
{
#region New role
PersonaAppRole realRole = new PersonaAppRole();
realRole.Application = app;
realRole.Name = colHeader.Name;
realRole.Priority = colHeader.Priority;
if (realRole.Name == "New role")
{
}
#region Fill realRole with users
foreach (int id in NewUsersIDsList)
{
context.Users_Roles.Add(new User_Role()
{
RoleName = realRole.Name, Application = realRole.Application, UserId = id
});
}
#endregion
realRole = context.AppRoles.Add(realRole);
try
{
context.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
string text = "Entity of type \"" + eve.Entry.Entity.GetType().Name + "\" in state \"" + eve.Entry.State + "\" has the following validation errors:";
foreach (var ve in eve.ValidationErrors)
{
string message = "- Property: \"" + ve.PropertyName + "\", Error: \"" + ve.ErrorMessage + "\"";
}
}
throw;
}
#endregion
colHeader.Id = realRole.Id;
#endregion
}
#endregion
}
else
{
#region Delete column (role)
if (colHeader.Id != -1)
{
PersonaAppRole role = context.AppRoles.First(a => a.Id == colHeader.Id);
context.AppRoles.Remove(role);
context.SaveChanges();
}
#endregion
}
x++;
}
#endregion
try
{
context.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
string text = "Entity of type \"" + eve.Entry.Entity.GetType().Name + "\" in state \"" + eve.Entry.State + "\" has the following validation errors:";
foreach (var ve in eve.ValidationErrors)
{
string message = "- Property: \"" + ve.PropertyName + "\", Error: \"" + ve.ErrorMessage + "\"";
}
}
throw;
}
#endregion
ViewBag.Saved = true;
return(RedirectToAction("App", "Roles", new { @Id = model.AppID }));//App(model.AppID);
}
