IList <GameObjDTO> IGameObjSvc.GetGOsByType(string type) { List <GameObjDTO> res = new List <GameObjDTO>(); try { GameObjectType goType = (GameObjectType)Enum.Parse(typeof(GameObjectType), type); System.Diagnostics.Debug.WriteLine("goType=" + (int)goType); using (var repo = new CityGameDBModel()) { player player = repo.player.Where <player>(p => p.login.Equals("nomitrey")).FirstOrDefault <player>(); List <gameobj> goEntities = repo.gameobj.Where <gameobj> (go => (go.player_id == player.player_id) && (go.object_type == (long)goType)).ToList <gameobj>(); foreach (var eGO in goEntities) { res.Add(Converters.DtoFromEntity(eGO)); } } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Exception: " + e); } return(res); }
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 SaveGameDto GetAllGO() { List <GameObjDTO> res = new List <GameObjDTO>(); try { using (var repo = new CityGameDBModel()) { player player = repo.player.Where <player>(p => p.login.Equals("nomitrey")).FirstOrDefault <player>(); List <gameobj> goEntities = repo.gameobj.Where <gameobj>(go => go.player_id == player.player_id).ToList <gameobj>(); foreach (var eGO in goEntities) { res.Add(Converters.DtoFromEntity(eGO)); } } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Exception: " + e); } return(new SaveGameDto(res)); }