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