public async Task <PermissionDto> Create(PermissionRequestModel model)
{
var permission = new Data.Models.Permission
{
Name = model.Name,
Description = model.Description,
Action = model.Action,
Entity = model.Entity
};
_db.Permissions.Add(permission);
await _db.SaveChangesAsync();
return(await GetById(permission.Id));
}
public JsonResult AddPermission(Data.Models.Permission permission)
{
return(Json(DataAccess.Account.AddPermission(permission)));
}
static void Main(string[] args)
{
if (args.Length != 2)
{
return;
}
string oldDbConnect = args[0];
string newDbConnect = args[1];
var newctx = new Data.Context(new DbContextOptionsBuilder().UseLazyLoadingProxies().UseSqlServer(newDbConnect).Options);
var oldctx = new DB.Context(new DbContextOptionsBuilder <DB.Context>().UseMySql(oldDbConnect).Options);
foreach (var grp in oldctx.Groups)
{
var newGrp = new Data.Models.Group()
{
Name = grp.Name
};
foreach (var perm in oldctx.Permissions.Where(o => o.Group == grp.Name))
{
var newPerm = new Data.Models.Permission()
{
Group = newGrp,
Perm = perm.Perm
};
newGrp.Permissions.Add(newPerm);
}
newctx.Groups.Add(newGrp);
}
newctx.SaveChanges();
foreach (var usr in oldctx.Users)
{
var newUsr = new Data.Models.User()
{
Id = usr.UUID,
FirstName = usr.FirstName,
LastName = usr.LastName,
Email = usr.EMail,
Private = usr.ShowEmail,
ProfileMsg = usr.ProfileMsg,
Points = usr.Points,
Pseudo = usr.Pseudo,
Group = newctx.Groups.Where(g => g.Name == usr.Group).First(),
Pass = SHA512(usr.Pass),
RegistrationDate = usr.Date
};
newctx.Users.Add(newUsr);
}
newctx.SaveChanges();
foreach (var sym in oldctx.Symbols)
{
var newSym = new Symbol()
{
Path = sym.Path,
CreationDate = sym.Date,
LastModificationDate = DateTime.UtcNow,
User = newctx.Users.Where(u => u.Id == sym.UserID).FirstOrDefault()
};
if (newctx.SymbolTypes.Any(e => e.Name == sym.Type))
{
newSym.Type = newctx.SymbolTypes.Where(e => e.Name == sym.Type).FirstOrDefault();
}
else
{
newSym.Type = new Data.Models.Symbols.Type()
{
Name = sym.Type
}
};
foreach (var proto in JsonConvert.DeserializeObject <API.Entities.Symbol.Prototype[]>(sym.Prototypes))
{
var newProto = new Data.Models.Symbols.Prototype()
{
Description = proto.Description,
Symbol = newSym,
Data = proto.Proto
};
foreach (var param in proto.Parameters)
{
var newParam = new Data.Models.Symbols.PrototypeParam()
{
Description = param.Description,
Data = param.Proto,
SymbolRef = param.Path != null ? new PrototypeParamSymbolRef()
{
RefPath = param.Path
} : null,
Prototype = newProto
};
newProto.Parameters.Add(newParam);
}
newSym.Prototypes.Add(newProto);
}
foreach (var symref in JsonConvert.DeserializeObject <string[]>(sym.Symbols))
{
var newSymRef = new Data.Models.Symbols.SymbolRef()
{
RefPath = symref,
Symbol = newSym
};
newSym.Symbols.Add(newSymRef);
}
newctx.Symbols.Add(newSym);
}
newctx.SaveChanges();
}
}
