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