public void Clear()
{
using (var db = new VrLifeDbContext())
{
db.AppData.RemoveRange(db.AppData.Where(x => x.AppId == _appId));
db.SaveChanges();
}
}
public void Delete(string field, ulong id)
{
using (var db = new VrLifeDbContext())
{
var toRemove = db.AppData.Where(x => x.AppId == _appId && x.FieldName == field && x.FieldId == id);
db.AppData.RemoveRange(toRemove);
db.SaveChanges();
}
}
public void Insert(ulong id, DataValue val)
{
using (var db = new VrLifeDbContext())
{
AppData data = new AppData();
data.AppId = _appId;
data.FieldName = val.Field;
data.FieldId = id;
SetValues(data, val);
db.AppData.Add(data);
db.SaveChanges();
}
}
public void UpdateOrInsert(ulong id, DataValue val)
{
using (var db = new VrLifeDbContext())
{
AppData data = db.AppData.SingleOrDefault(x => x.AppId == _appId && x.FieldName == val.Field && x.FieldId == id);
if (data != null)
{
SetValues(data, val);
db.SaveChanges();
return;
}
}
Insert(id, val);
}
public void GetTest()
{
var user = new VrLifeServer.Database.DbModels.User();
using (var db = new VrLifeDbContext())
{
user.Username = "******";
user.Passphrase = "password";
db.Users.Add(user);
db.SaveChanges();
}
User obj = User.Get(user.UserId);
Assert.NotNull(obj);
obj.Delete();
}
public void DeleteTest()
{
var user = new VrLifeServer.Database.DbModels.User();
using (var db = new VrLifeDbContext())
{
user.Username = "******";
user.Passphrase = "password";
db.Users.Add(user);
db.SaveChanges();
}
ulong userId = user.UserId;
User obj = new User(user);
obj.Delete();
using (var db = new VrLifeDbContext())
{
Assert.Null(db.Users.SingleOrDefault(x => x.UserId == userId));
}
}
