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); } }