public void SaveOrUpdateGO(GameObjDTO composite)
{
try
{
using (var repo = new CityGameDBModel())
{
player player = repo.player.Where <player>(p => p.login.Equals(composite.player)).FirstOrDefault <player>();
if (player != null)
{
gameobj go = repo.gameobj.Where <gameobj>(g => g.gameobj_id.Equals(composite.guid)).FirstOrDefault <gameobj>();
if (go == null)
{ // We have a new record...
go = Converters.EntityFromDto(composite);
repo.gameobj.Add(go);
}
else
{ // We have an existing record...
go = Converters.EntityFromDto(composite, go);
repo.Entry(go).State = System.Data.Entity.EntityState.Modified;
}
go.player_id = player.player_id;
repo.SaveChanges();
}
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
System.Diagnostics.Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("Exception: " + e);
}
}
public void DeleteGO(string guid)
{
try
{
using (var repo = new CityGameDBModel())
{
gameobj go = repo.gameobj.Where <gameobj>(g => g.gameobj_id.Equals(guid)).FirstOrDefault <gameobj>();
if (go != null)
{ // We have a record...
repo.gameobj.Remove(go);
}
repo.SaveChanges();
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("Exception: " + e);
}
}
public static gameobj EntityFromDto(GameObjDTO aGameobjDto, gameobj aGameObjectEntity = null)
{
gameobj eGO = aGameObjectEntity == null ? new gameobj() : aGameObjectEntity;
GameObjectType goType = (GameObjectType)Enum.Parse(typeof(GameObjectType), aGameobjDto.type);
eGO.gameobj_id = aGameobjDto.guid;
eGO.object_type = (long)goType;
eGO.prefab = aGameobjDto.prefab;
eGO.layer = aGameobjDto.layer;
eGO.tag = aGameobjDto.tag;
if (aGameobjDto.position != null)
{
eGO.pos_x = aGameobjDto.position.X;
eGO.pos_y = aGameobjDto.position.Y;
eGO.pos_z = aGameobjDto.position.Z;
}
if (aGameobjDto.rotation != null)
{
eGO.rot_x = aGameobjDto.rotation.X;
eGO.rot_y = aGameobjDto.rotation.Y;
eGO.rot_z = aGameobjDto.rotation.Z;
eGO.rot_w = aGameobjDto.rotation.W;
}
if (aGameobjDto.scale != null)
{
eGO.scale_x = aGameobjDto.scale.X;
eGO.scale_y = aGameobjDto.scale.Y;
eGO.scale_z = aGameobjDto.scale.Z;
}
for (int i = 1;
(aGameobjDto.layerChildren != null) &&
(i < aGameobjDto.layerChildren.Count); i++)
{
// Remove all current children...
if (aGameObjectEntity != null)
{
aGameObjectEntity.gameobj1.Clear();
}
// .. and add a new one for each child.
gameobj eChild = new gameobj();
eChild.gameobj_id = System.Guid.NewGuid().ToString();
eChild.prefab = @"none";
eChild.layer = aGameobjDto.layerChildren[i];
eChild.tag = aGameobjDto.tag;
eGO.gameobj1.Add(eChild);
}
/**/
return(eGO);
}
public static GameObjDTO DtoFromEntity(gameobj aGameobjEntity)
{
GameObjDTO goDto = new GameObjDTO();
Vector3 pos = new Vector3();
pos.X = aGameobjEntity.pos_x;
pos.Y = aGameobjEntity.pos_y;
pos.Z = aGameobjEntity.pos_z;
Quaternion rot = new Quaternion();
rot.X = aGameobjEntity.rot_x;
rot.Y = aGameobjEntity.rot_y;
rot.Z = aGameobjEntity.rot_z;
rot.W = aGameobjEntity.rot_w;
Vector3 scale = new Vector3();
scale.X = aGameobjEntity.scale_x;
scale.Y = aGameobjEntity.scale_y;
scale.Z = aGameobjEntity.scale_z;
goDto.player = aGameobjEntity.player.login;
goDto.guid = aGameobjEntity.gameobj_id;
goDto.prefab = aGameobjEntity.prefab;
goDto.type = Enum.Format(typeof(GameObjectType), (int)aGameobjEntity.object_type, "G");
goDto.layer = (Nullable <int>)aGameobjEntity.layer;
goDto.tag = aGameobjEntity.tag;
goDto.position = pos;
goDto.rotation = rot;
goDto.scale = scale;
/* TODO handle children */
goDto.layerChildren = new List <int>();
goDto.tagsChildren = new List <string>();
for (int i = 0;
(aGameobjEntity.gameobj1 != null) &&
(i < aGameobjEntity.gameobj1.Count);
i++)
{
goDto.layerChildren.Add((int)aGameobjEntity.gameobj1.ElementAt(i).layer);
goDto.tagsChildren.Add(aGameobjEntity.gameobj1.ElementAt(i).tag);
}
/* */
return(goDto);
}