public static void DeleteDb(int type) { if (type == 0) { var db1 = new DbContext("LocationConnection"); var delResult1 = db1.Database.Delete(); var db2 = new DbContext("LocationHistoryConnection"); var delResult2 = db2.Database.Delete(); } else if (type == 1) { DirectoryInfo dirInfo = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory + "\\Data\\"); FileInfo[] files = dirInfo.GetFiles("*.db"); foreach (var file in files) { file.Delete(); } } else { LocationDb Ldb = new LocationDb(); LocationHistoryDb Lhdb = new LocationHistoryDb(); // Ldb.Database.ExecuteSqlCommand("drop database location"); // Lhdb.Database.ExecuteSqlCommand("drop database locationhistory"); Ldb.Database.Delete(); Lhdb.Database.Delete(); } }
// Use this for initialization void Start() { LocationDb mLocationDb = new LocationDb(); //Add Data mLocationDb.addData(new LocationEntity("0", "AR", "0.001", "0.007")); mLocationDb.addData(new LocationEntity("1", "AR", "0.002", "0.006")); mLocationDb.addData(new LocationEntity("2", "AR", "0.003", "0.005")); mLocationDb.addData(new LocationEntity("3", "AR", "0.004", "0.004")); mLocationDb.addData(new LocationEntity("4", "AR", "0.005", "0.003")); mLocationDb.addData(new LocationEntity("5", "AR", "0.006", "0.002")); mLocationDb.addData(new LocationEntity("6", "AR", "0.007", "0.001")); mLocationDb.close(); //Fetch All Data LocationDb mLocationDb2 = new LocationDb(); System.Data.IDataReader reader = mLocationDb2.getAllData(); int fieldCount = reader.FieldCount; List <LocationEntity> myList = new List <LocationEntity>(); while (reader.Read()) { LocationEntity entity = new LocationEntity(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString()); Debug.Log("id: " + entity._id); myList.Add(entity); } }
/// <summary> /// Displays all <c>Location</c> in the database. Accepts console input to delete a location from the database. /// </summary> public void RemoveLocation() { Console.WriteLine("Remove a Location (WARNING: Will remove products and order history):\n"); Console.WriteLine("0:\tReturn"); try { //Loads locations from database. var locations = new LocationDb().GetLocations(); foreach (var location in locations) { Console.WriteLine(location); } //Console input. Console.Write("\nEnter Location ID:\n> "); var input = Int32.Parse(Console.ReadLine()); Console.Clear(); //0: Return if (input == 0) { Continue(); return; } new LocationDb().RemoveLocation(input); Console.WriteLine("Location and products removed."); Continue(); } catch (System.Exception) { CommandError(); } }
/// <summary> /// Display all <c>Location</c> in the database. /// Accepts console input to view a <c>Location</c>. /// Sets appropriate field in <c>UserTerminal</c>. /// </summary> public void ViewLocations() { try { //Loads locations from database. ICollection <Location> locations = new LocationDb().GetLocations(); Console.WriteLine("Choose a Location to View:\n"); Console.WriteLine("0:\tReturn"); foreach (Location location in locations) { Console.WriteLine(location); } Console.Write("\nEnter Location Id:\n> "); //Console input. var input = Int32.Parse(Console.ReadLine()); Console.Clear(); //0: Return if (input == 0) { GoBack(); return; } //Load location from database. UI.Location = new LocationDb().GetLocation(input); } catch (System.Exception) { CommandError(); } }
private void Start() { LocationDb mLocationDb = new LocationDb(); //Add Data mLocationDb.addData(new LocationEntity("SPHERE 1", "5.000", "5.000")); mLocationDb.addData(new LocationEntity("SPHERE 2", "4.000", "4.000")); mLocationDb.addData(new LocationEntity("SPHERE 3", "3.000", "3.000")); mLocationDb.addData(new LocationEntity("SPHERE 4", "2.000", "2.000")); mLocationDb.addData(new LocationEntity("SPHERE 5", "1.000", "1.000")); mLocationDb.addData(new LocationEntity("SPHERE 6", "0.000", "0.000")); mLocationDb.Close(); //Fetch All Data LocationDb mLocationDb2 = new LocationDb(); IDataReader reader = mLocationDb2.GetAllData(); int fieldCount = reader.FieldCount; List <LocationEntity> myList = new List <LocationEntity>(); while (reader.Read()) { LocationEntity entity = new LocationEntity(Convert.ToInt32(reader[0]), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString()); Debug.Log("id: " + entity.Id); myList.Add(entity); Instantiate(GameObject.CreatePrimitive(PrimitiveType.Sphere), new Vector3((float)Convert.ToDouble(entity.Lat), (float)Convert.ToDouble(entity.Lon), 0), Quaternion.identity); } }
private static LocationDb GetDb() { var db = new LocationDb(); db.Configuration.AutoDetectChangesEnabled = false; db.Configuration.LazyLoadingEnabled = false; //关闭延迟加载 db.Configuration.ProxyCreationEnabled = false; return(db); }
public TestBll(bool autoDetectChangesEnabled, bool lazyLoadingEnabled, bool isCreateDb) { Db = new LocationDb(isCreateDb); Db.Configuration.AutoDetectChangesEnabled = autoDetectChangesEnabled; Db.Configuration.LazyLoadingEnabled = lazyLoadingEnabled; //关闭延迟加载 Maps = new MapBll(Db); Areas = new AreaBll(Db); Position = new PositionBll(DbHistory); TagPositions = new TagPositionBll(Db); Departments = new DepartmentBll(Db); Users = new UserBll(Db); Tags = new TagBll(Db); Archors = new ArchorBll(Db); KKSCodes = new KKSCodeBll(Db); t_KKSCodes = new t_KKSCodeBll(Dbtopviewxp); t_SetModels = new t_SetModelBll(Db); t_TypeProperties = new t_Template_TypePropertyBll(Db); TransformMs = new TransformMBll(Db); DevInfos = new DevInfoBll(Db); DevPos = new DevPosBll(Db); U3DPositions = new U3DPositionBll(DbHistory); PhysicalTopologys = new PhysicalTopologyBll(Db); NodeKKSs = new NodeKKSBll(Db); Personnels = new PersonnelBll(Db); Posts = new PostBll(Db); JurisDictions = new JurisDictionBll(Db); JurisDictionRecords = new JurisDictionRecordBll(Db); Meterials = new MeterialBll(Db); //U3DPositions.ToList(); ConfigArgs = new ConfigArgBll(Db); Bounds = new BoundBll(Db); Points = new PointBll(Db); OperationTickets = new OperationTicketBll(Db); OperationItems = new OperationItemBll(Db); WorkTickets = new WorkTicketBll(Db); SafetyMeasuress = new SafetyMeasuresBll(Db); MobileInspections = new MobileInspectionBll(Db); MobileInspectionItems = new MobileInspectionItemBll(Db); MobileInspectionContents = new MobileInspectionContentBll(Db); MobileInspectionDevs = new MobileInspectionDevBll(Db); PersonnelMobileInspections = new PersonnelMobileInspectionBll(Db); PersonnelMobileInspectionItems = new PersonnelMobileInspectionItemBll(Db); PersonnelMobileInspectionHistorys = new PersonnelMobileInspectionHistoryBll(DbHistory); PersonnelMobileInspectionItemHistorys = new PersonnelMobileInspectionItemHistoryBll(DbHistory); OperationTicketHistorys = new OperationTicketHistoryBll(DbHistory); OperationItemHistorys = new OperationItemHistoryBll(DbHistory); WorkTicketHistorys = new WorkTicketHistoryBll(DbHistory); SafetyMeasuresHistorys = new SafetyMeasuresHistoryBll(DbHistory); Targets = new TargetBll(Db); Roles = new RoleBll(Db); Menus = new MenuBll(Db); Z.EntityFramework.Extensions.LicenseManager.AddLicense("34;100-LLHSWWHA", "384799A60700037CBFC0EB5E03A62474"); }
/// <summary> /// Creates a new <c>Location</c> and inserts into the database. /// </summary> public void AddLocation() { try { //New instance of LocationDb. Returns instance of Location. var location = new LocationDb().Build(); Console.Clear(); Console.WriteLine("New location added.\n"); Console.WriteLine(location + "\n"); Continue(); } catch (System.Exception ex) { Console.Clear(); Console.WriteLine(ex.Message); Continue(); } }
public static void LocationTestingData() { var locCount = TotalLocationCount(); using (SQLiteConnection conn = new SQLiteConnection(DatabaseLocation)) { conn.CreateTable <LocationDb>(); var location = conn.Table <LocationDb>().ToList(); if (locCount < 1) { LocationDb newLocaiton = new LocationDb() { CurrentUser = UserLoggedIn, LocationName = "Favorite Hunting Spot", Longitude = -84.317241, Latitude = 34.736907, EventType = "Hunting", CreatedDate = DateTime.Today, ReturnDate = DateTime.Today, Notification = "Enabled", Notes = "This testing data is for the assessor and is created at the login page with any new user created that doesn't contain any data" }; conn.Insert(newLocaiton); LocationDb newLocaiton2 = new LocationDb() { CurrentUser = UserLoggedIn, LocationName = "Favorite Hunting Spot 2", Longitude = -84.317241, Latitude = 34.736907, EventType = "Hunting", CreatedDate = DateTime.Today, ReturnDate = DateTime.Today, Notification = "Enabled", Notes = "This testing data is for the assessor and is created at the login page with any new user created that doesn't contain any data" }; conn.Insert(newLocaiton2); } } }
private static List <object> GetList(PropertyInfo p, LocationDb db) { var ds = p.GetValue(db); //var ps = ds.GetType().GetProperties(); //var ms = ds.GetType().GetMethods(); var list = ds as IEnumerable; var list2 = new List <object>(); foreach (var item in list) { //if(item is IComparable) //{ // list2.Add(item as IComparable); //} //else { list2.Add(item); } } return(list2); }
async void Save_Clicked(System.Object sender, System.EventArgs e) { using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { conn.CreateTable <LocationDb>(); // handles Longitude and Latitude input //double longitudeOut; //bool longParsed = double.TryParse(longitude.Text, out longitudeOut); //bool longValid = double.IsNaN(longitudeOut); if (string.IsNullOrWhiteSpace(locationName.Text) || string.IsNullOrWhiteSpace(Convert.ToString(eventTypePicker.SelectedItem)) || string.IsNullOrWhiteSpace(Convert.ToString(notificationStatus.SelectedItem)) || string.IsNullOrWhiteSpace(notes.Text)) { await DisplayAlert("Failure", "Please enter valid information for all location fields including only numbers/decimil for Longitude and Latitude.", "OK"); } else { LocationDb newLocation = new LocationDb { CurrentUser = App.UserLoggedIn, LocationName = locationName.Text, Longitude = Convert.ToDouble(longitude.Text), Latitude = Convert.ToDouble(latitude.Text), EventType = Convert.ToString(eventTypePicker.SelectedItem), CreatedDate = DateTime.Now, ReturnDate = returnDate.Date, Notification = Convert.ToString(notificationStatus.SelectedItem), Notes = notes.Text }; conn.Insert(newLocation); await DisplayAlert("Success", "Location successfully created", "OK"); await Navigation.PopModalAsync(); } } }
public WarehouseRepository() { this.db = new LocationDb(); this.regionRepo = new RegionRepository(this.db); }
internal RegionRepository(LocationDb context) { this.db = context; }
public RegionRepository() { this.db = new LocationDb(); }
public EditLocationPage(LocationDb selectedLocation) { InitializeComponent(); this.selectedLocation = selectedLocation; }
public Manager() { var connection = DbConnectionFactory.CreateTransient(); Db = new LocationDb(connection); }
public ProvinceRepository() { this.db = new LocationDb(); }
public void AddEntity(LocationDb item) { Locations.Add(item); }
public Bll(bool autoDetectChangesEnabled, bool lazyLoadingEnabled, bool isCreateDb, bool useProxy = true) { Db = new LocationDb(isCreateDb); Db.Configuration.AutoDetectChangesEnabled = autoDetectChangesEnabled; Db.Configuration.LazyLoadingEnabled = lazyLoadingEnabled; //关闭延迟加载 Db.Configuration.ProxyCreationEnabled = useProxy; if (ShowLog) { Db.Database.Log = Log.Debug; } Archors = new ArchorBll(Db); Areas = new AreaBll(Db); Bounds = new BoundBll(Db); ConfigArgs = new ConfigArgBll(Db); Departments = new DepartmentBll(Db); DevAlarms = new DevAlarmBll(Db); DevInfos = new DevInfoBll(Db); Dev_DoorAccess = new Dev_DoorAccessBll(Db); Dev_CameraInfos = new Dev_CameraInfoBll(Db); DevInstantDatas = new DevInstantDataBll(Db); DevModels = new DevModelBll(Db); DevTypes = new DevTypeBll(Db); EntranceGuardCards = new EntranceGuardCardBll(Db); EntranceGuardCardToPersonnels = new EntranceGuardCardToPersonnelBll(Db); AreaAuthorizations = new AreaAuthorizationBll(Db); AreaAuthorizationRecords = new AreaAuthorizationRecordBll(Db); KKSCodes = new KKSCodeBll(Db); LocationAlarms = new LocationAlarmBll(Db); LocationCards = new LocationCardBll(Db); LocationCardPositions = new LocationCardPositionBll(Db); LocationCardToPersonnels = new LocationCardToPersonnelBll(Db); MobileInspections = new MobileInspectionBll(Db); MobileInspectionContents = new MobileInspectionContentBll(Db); MobileInspectionDevs = new MobileInspectionDevBll(Db); MobileInspectionItems = new MobileInspectionItemBll(Db); NodeKKSs = new NodeKKSBll(Db); OperationItems = new OperationItemBll(Db); OperationTickets = new OperationTicketBll(Db); Personnels = new PersonnelBll(Db); PersonnelMobileInspections = new PersonnelMobileInspectionBll(Db); PersonnelMobileInspectionItems = new PersonnelMobileInspectionItemBll(Db); Points = new PointBll(Db); Posts = new PostBll(Db); Roles = new RoleBll(Db); SafetyMeasuress = new SafetyMeasuresBll(Db); WorkTickets = new WorkTicketBll(Db); Pictures = new PictureBll(Db); ArchorSettings = new ArchorSettingBll(Db); CardRoles = new CardRoleBll(Db); DevMonitorNodes = new DevMonitorNodeBll(Db); //Shapes = new ShapeBll(Db); //ShapePoints = new ShapePointBll(); DevAlarmHistorys = new DevAlarmHistoryBll(DbHistory); DevEntranceGuardCardActions = new DevEntranceGuardCardActionBll(DbHistory); DevInfoHistorys = new DevInfoHistoryBll(DbHistory); DevInstantDataHistorys = new DevInstantDataHistoryBll(DbHistory); EntranceGuardCardHistorys = new EntranceGuardCardHistoryBll(DbHistory); EntranceGuardCardToPersonnelHistorys = new EntranceGuardCardToPersonnelHistoryBll(DbHistory); LocationAlarmHistorys = new LocationAlarmHistoryBll(DbHistory); LocationCardHistorys = new LocationCardHistoryBll(DbHistory); LocationCardToPersonnelHistorys = new LocationCardToPersonnelHistoryBll(DbHistory); OperationItemHistorys = new OperationItemHistoryBll(DbHistory); OperationTicketHistorys = new OperationTicketHistoryBll(DbHistory); PersonnelHistorys = new PersonnelHistoryBll(DbHistory); PersonnelMobileInspectionHistorys = new PersonnelMobileInspectionHistoryBll(DbHistory); PersonnelMobileInspectionItemHistorys = new PersonnelMobileInspectionItemHistoryBll(DbHistory); Positions = new PositionBll(DbHistory); SafetyMeasuresHistorys = new SafetyMeasuresHistoryBll(DbHistory); U3DPositions = new U3DPositionBll(DbHistory); WorkTicketHistorys = new WorkTicketHistoryBll(DbHistory); bus_anchors = new bus_anchorBll(DbE); bus_tags = new bus_tagBll(DbE); bus_anchor_config = new bus_anchor_configBll(DbE); bus_anchor_switch_area = new bus_anchor_switch_areaBll(DbE); //LocationCards.ToList(); //DevEntranceGuardCardActions.ToList(); //bus_archors.ToList(); Z.EntityFramework.Extensions.LicenseManager.AddLicense("34;100-LLHSWWHA", "384799A60700037CBFC0EB5E03A62474"); }
internal WarehouseRepository(LocationDb context, IRegionRepository repo) { this.db = context; this.regionRepo = repo; }
internal ProvinceRepository(LocationDb context) { db = context; }
public LocationDetailsPage(LocationDb selectedLocation) { this.selectedLocation = selectedLocation; InitializeComponent(); }