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