public Dictionary <string, object> GetAll()
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName}", "id");
if (entityModels != null && entityModels.Any())
{
var dictionary = new Dictionary <string, object>();
foreach (var item in entityModels)
{
dictionary.Add(item["key"].ToString(), Json2KeyValue.JsonConvert.DeserializeObject <UserInfo>(item["value"].ToString()));
}
return(dictionary);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public string GetValue(string key)
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}'", "id");
if (entityModels != null && entityModels.Any())
{
foreach (var item in entityModels)
{
return(item["value"].ToString());
}
return(null);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public static bool StaticSetValue(string value, string key)
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}';", "id");
if (entityModels != null && entityModels.Any() && entityModels.Count > 0)
{
foreach (var item in entityModels)
{
if (item["key"].ToString() == key)
{
item["value"] = value;
item.SaveChange("value");
}
}
return(true);
}
else
{
var entityModel = new EntityModel();
entityModel.ConnectionString = ConnectionString;
entityModel.EntityName = tmpUserCacheTableName;
entityModel.PrimaryKey = new KeyValuePair <string, object>("id", Guid.NewGuid());
entityModel.Add("key", key);
entityModel.Add("value", value);
return(entityModelFactory.AddEntityModel(entityModel));
}
}
catch (Exception ex)
{
return(false);
}
}
public bool Contains(string key)
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}'", "id");
if (entityModels != null && entityModels.Any())
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public DrumbleApp.Shared.Entities.Path GetPinned(Guid tripId, IEnumerable<DrumbleApp.Shared.Entities.PublicTransportOperator> publicTransportOperators)
{
return base.DbSet.Where(x => x.IsPinned == true && x.TripId == tripId).Select(x => EntityModelFactory.Create(x, publicTransportOperators)).FirstOrDefault();
}
public Entities.PublicTransportOperator GetById(Guid operatorId)
{
return(EntityModelFactory.Create(base.DbSet.SingleOrDefault(x => x.Id == operatorId)));
}
public IEnumerable<DrumbleApp.Shared.Entities.Path> GetAllCached(IEnumerable<DrumbleApp.Shared.Entities.PublicTransportOperator> publicTransportOperators)
{
return base.DbSet.Where(x => x.IsPinned == false).Select(x => EntityModelFactory.Create(x, publicTransportOperators));
}
public IEnumerable <Entities.PublicStop> GetNearby(int limit)
{
// Filter out operators not selected.
IEnumerable <OperatorSetting> operatorSettings = Context.OperatorSettings.Where(x => x.IsEnabled);
return(base.DbSet.Where(x => operatorSettings.Select(y => y.OperatorName).Contains(x.OperatorName)).OrderBy(x => x.DistanceFromUserLocationInMeters).Take(limit).Select(x => EntityModelFactory.Create(x)));
}
public IEnumerable <DrumbleApp.Shared.Entities.PublicTransportOperator> GetAll()
{
return(base.DbSet.OrderBy(x => x.Name).Select(x => EntityModelFactory.Create(x)));
}
public IEnumerable <Entities.SearchItemCategory> GetAll()
{
return(base.DbSet.Select(x => EntityModelFactory.Create(x)));
}
public Entities.PlaceOfInterestCategory GetByCategory(string category)
{
return(EntityModelFactory.Create(base.DbSet.Where(x => x.Category == category).SingleOrDefault()));
}
public IEnumerable <Entities.Favourite> GetByName(string searchText)
{
return(base.DbSet.Where(x => x.IsFavourite && (x.Text.ToLower().Contains(searchText.ToLower()))).OrderByDescending(x => x.LastUsedDate).Select(x => EntityModelFactory.CreateFavourite(x)));
}
public IEnumerable <Entities.CacheSetting> GetAllCacheSettings()
{
return(base.DbSet.Select(x => EntityModelFactory.Create(x)));
}
static TableUserCache()
{
try
{
ConnectionString = new TConfigManager().GetConnectionString();
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
tmpUserCacheTableName = "tmp_user_cache";
if (entityModelFactory.ExistModelMeta(tmpUserCacheTableName))
{
return;
}
var entityModelMeta = new EntityModelMeta();
entityModelMeta.EntityName = tmpUserCacheTableName;
entityModelMeta.ConnectionString = ConnectionString;
entityModelMeta.Add("id", new EntityKeyMetaType
{
EntityKeyType = typeof(Guid),
FieldType = new KeyValuePair <string, string>[2]
{
new KeyValuePair <string, string>(SqlFieldType.NotNull, ""),
new KeyValuePair <string, string>(SqlFieldType.PrimaryKey, "")
}
});
entityModelMeta.Add("key", new EntityKeyMetaType
{
EntityKeyType = typeof(string),
FieldType = new KeyValuePair <string, string>[1]
{
new KeyValuePair <string, string>(SqlFieldType.NotNull, "")
}
});
entityModelMeta.Add("value", new EntityKeyMetaType
{
EntityKeyType = typeof(StringBuilder)
});
entityModelMeta.Add("create_time", new EntityKeyMetaType
{
EntityKeyType = typeof(DateTime),
FieldType = new KeyValuePair <string, string>[1]
{
new KeyValuePair <string, string>(SqlFieldType.DefaultValueCurrentDateTime, "")
}
});
entityModelMeta.Add("update_time", new EntityKeyMetaType
{
EntityKeyType = typeof(DateTime),
FieldType = new KeyValuePair <string, string>[1]
{
new KeyValuePair <string, string>(SqlFieldType.DefaultValueCurrentDateTimeAndUpdateTime, "")
}
});
entityModelFactory.CreateEntityModelMeta(entityModelMeta);
}
catch (Exception)
{
}
finally
{
Refresh();
}
}
public DrumbleApp.Shared.Entities.Weather Get()
{
return(EntityModelFactory.Create(base.DbSet.FirstOrDefault()));
}
public IEnumerable <Entities.PublicStop> GetByName(string searchText)
{
// Filter out operators not selected.
IEnumerable <OperatorSetting> operatorSettings = Context.OperatorSettings.Where(x => x.IsEnabled);
return(base.DbSet.Where(x => x.Name.ToLower().Contains(searchText.ToLower()) && operatorSettings.Select(y => y.OperatorName).Contains(x.OperatorName)).OrderBy(x => x.DistanceFromUserLocationInMeters).Take(30).Select(x => EntityModelFactory.Create(x)));
}
public Entities.PublicStop FindById(Guid publicStopId)
{
return(base.DbSet.Where(x => x.Id == publicStopId).Select(x => EntityModelFactory.Create(x)).FirstOrDefault());
}
public DrumbleApp.Shared.Entities.AppSetting FindByType(ApplicationSetting applicationSetting)
{
return(base.DbSet.Where(x => x.ApplicationSetting == applicationSetting).Select(x => EntityModelFactory.Create(x)).Single());
}
public DrumbleApp.Shared.Entities.TransportMode FindByType(ApplicationTransportMode applicationTransportMode)
{
return(base.DbSet.Where(x => x.ApplicationTransportMode == applicationTransportMode).Select(x => EntityModelFactory.Create(x)).Single());
}
public Entities.PublicStop FindByName(string name)
{
return(EntityModelFactory.Create(base.DbSet.Where(x => x.Name.ToLower().Contains(name.ToLower())).FirstOrDefault()));
}
public IEnumerable <Entities.Favourite> GetRecent()
{
return(base.DbSet.Where(x => x.IsFavourite).OrderByDescending(x => x.LastUsedDate).Take(3).Select(x => EntityModelFactory.CreateFavourite(x)));
}
public Entities.User GetUser()
{
User user = base.DbSet.SingleOrDefault();
return((user == null) ? null : EntityModelFactory.Create(user));
}
public Entities.Favourite GetById(System.Guid id)
{
return(EntityModelFactory.CreateFavourite(base.DbSet.Where(x => x.Id == id).FirstOrDefault()));
}
public IEnumerable <Entities.Recent> GetAll()
{
return(base.DbSet.OrderByDescending(x => x.LastUsedDate).Select(x => EntityModelFactory.Create(x)));
}
public Entities.CacheSetting GetByType(Enums.ResourceType resourceType)
{
return(EntityModelFactory.Create(base.DbSet.Where(x => x.ResourceType == resourceType).FirstOrDefault()));
}
public Entities.Recent GetMostRecent()
{
return(EntityModelFactory.Create(base.DbSet.OrderByDescending(x => x.LastUsedDate).FirstOrDefault()));
}
public IEnumerable <Entities.PlaceOfInterestCategory> GetAll()
{
return(base.DbSet.Select(x => EntityModelFactory.Create(x)));
}
public Entities.Recent GetMostFrequent()
{
return(EntityModelFactory.Create(base.DbSet.OrderByDescending(x => x.NumberOfUses).FirstOrDefault()));
}
public IEnumerable <DrumbleApp.Shared.Entities.UberTrip> GetAll()
{
return(base.DbSet.Select(x => EntityModelFactory.Create(x)));
}
public IEnumerable <Entities.PublicStopPoint> GetNearby(int limit, Coordinate location)
{
// Filter out operators not selected.
IEnumerable <OperatorSetting> operatorSettings = Context.OperatorSettings.Where(x => x.IsEnabled);
return(base.DbSet.Where(x => operatorSettings.Select(y => y.OperatorName).Contains(x.OperatorName)).SelectMany(x => x.StopPoints).ToList().OrderBy(x => x.Location.DistanceToCoordinateInMetres(location)).Take(limit).Select(x => EntityModelFactory.CreatePointForMap(x)));
}
