public PopulateDataReturn Get(PopulateDataMockRequest request) { var returnLog = new PopulateDataReturn(); returnLog.OperationLog = new List<string>(); returnLog.OperationLog.Add("Populate Data started on " + DateTime.Now.ToShortTimeString() + "."); var hostId = Config.SodaHost; var dataSetId = Config.SodaDataSet; if (request.PopulateKey.IsEqualWithCase("PrettyPleasePopulateTheSystem")) { using (var db = DbConnectionFactory.OpenDbConnection()) { returnLog.OperationLog.Add("Populating TypeOfWork Table."); //db.Insert(new TypeOfWorkDB() { Description = "Road Construction"}); //db.Insert(new TypeOfWorkDB() { Description = "Pot Hole" }); } } else { returnLog.OperationLog.Add("Invalid Key."); } return returnLog; }
public PopulateDataReturn Get(PopulateDataRoadConstructionRequest request) { var returnLog = new PopulateDataReturn(); returnLog.OperationLog = new List<string>(); returnLog.OperationLog.Add("Populate Data started on " + DateTime.Now.ToShortTimeString() + "."); var host= Config.SodaHost; var dataSetId = Config.SodaDataSet; var dataSet = PD.API.SODA.ReadDataFromSoda.RoadContructionData(host, dataSetId); // var collection = new List<LocationOfInterestDB>(); if (request.PopulateKey.IsEqualWithCase("PrettyPleasePopulateTheSystem")) { using (var db = DbConnectionFactory.OpenDbConnection()) { returnLog.OperationLog.Add("Inserting DataSet of New Location"); db.Insert(new TypeOfWorkDB() { Description = "Road Construction"}); var types = db.Select<TypeOfWorkDB>(m => m.Description == "Road Construction"); foreach (var data in dataSet) { var locationOfInterestDB = new LocationOfInterestDB(); locationOfInterestDB.PositionLatitutde = data.Latitude; locationOfInterestDB.PositionLongitude = data.Longitude; locationOfInterestDB.LocationDescription = data.Location; locationOfInterestDB.TypeOfWorkID = types[0].TypeOfWorkID; locationOfInterestDB.StateCreated = false; locationOfInterestDB.DescriptionOfWork = data.Description; locationOfInterestDB.CreatedOn = DateTime.Now; locationOfInterestDB.StartDate =null; locationOfInterestDB.StopDate = null; locationOfInterestDB.UpVote=0; db.Insert(locationOfInterestDB); //collection.Add(locationOfInterestDB); } } } else { returnLog.OperationLog.Add("Invalid Key."); } return returnLog; }