private void PopulateTables(SQLite.SQLiteConnection connection, string jsonCallback) { /* * Regex regex = new Regex("[(.*?)]"); * var v = regex.Match(jsonCallback); * string json = v.Groups[1].ToString(); */ string json = jsonCallback.Replace("staticDataCallback([", ""); json = json.Replace("])", ""); StaticData staticData = JsonConvert.DeserializeObject <StaticData>(json); if (staticData != null) { if (staticData.MediaStatus != null) { foreach (var item in staticData.MediaStatus) { var entity = new MediaStatusEntity { ID = item.Id, Name = item.Name, Key = item.Key }; connection.Insert(entity); } } if (staticData.MediaType != null) { foreach (var item in staticData.MediaType) { var entity = new MediaTypeEntity { ID = item.Id, Name = item.Name, Key = item.Key }; connection.Insert(entity); } } if (staticData.FavoriteMusic != null) { foreach (var item in staticData.FavoriteMusic) { var entity = new FavoriteMusicEntity { ID = item.Id, Name = item.Name, Key = item.Key }; connection.Insert(entity); } } if (staticData.FavoriteSport != null) { foreach (var item in staticData.FavoriteSport) { var entity = new FavoriteSportEntity { ID = item.Id, Name = item.Name, Key = item.Key }; connection.Insert(entity); } } } }
public static MediaType MapToMediatype(this MediaTypeEntity mediaType) { switch (mediaType) { case MediaTypeEntity.Hardback: return(MediaType.Hardback); case MediaTypeEntity.Hardcover: return(MediaType.Hardcover); case MediaTypeEntity.GraphicNovel: return(MediaType.GraphicNovel); case MediaTypeEntity.Paperback: return(MediaType.Paperback); default: throw new ArgumentOutOfRangeException(); } }
public async Task <IResultModel> Add(MediaTypeAddModel model) { if (await _repository.Exists(model.Ext)) { return(ResultModel.HasExists); } var entity = new MediaTypeEntity { Ext = model.Ext, Value = model.Value }; var result = await _repository.AddAsync(entity); return(ResultModel.Result(result)); }