private void GetUserData(ProcessData processData)
{
var factory = new DbConnectionFactory("testDatabase");
var context = new DbContext(factory);
User_Driving_DataRepository repo = new User_Driving_DataRepository(context);
dataList = repo.GetUserDrivingDataWithIdAndSessionId(processData.userID, processData.Session_Id);
}
public void Map_data(Driving_Data aData)
{
User_Driving_Data aDrivingData = new User_Driving_Data();
aDrivingData.User_Id = aData.userID;
aDrivingData.Session_Id = aData.Session_Id;
//aDrivingData.Data_Id = 1;
aDrivingData.Frequency = aData.frequency;
aDrivingData.Street_Name = aData.streetName;
aDrivingData.Speed_Limit = aData.speedLimit;
aDrivingData.Longitude = aData.coordinate.longitude;
aDrivingData.Latitude = aData.coordinate.latitude;
aDrivingData.TimeStamp = aData.datetime;
aDrivingData.Horizontal_Accuracy = aData.coordinate.horizontalAccuracy;
aDrivingData.Speed = aData.speed;
aDrivingData.Gravity_X = aData.gravity.x;
aDrivingData.Gravity_Y = aData.gravity.y;
aDrivingData.Gravity_Z = aData.gravity.z;
aDrivingData.User_Acceleration_X = aData.userAcceleration.x;
aDrivingData.User_Acceleration_Y = aData.userAcceleration.y;
aDrivingData.User_Acceleration_Z = aData.userAcceleration.z;
aDrivingData.Rotation_Rate_X = aData.rotationRate.x;
aDrivingData.Rotation_Rate_Y = aData.rotationRate.y;
aDrivingData.Rotation_Rate_Z = aData.rotationRate.z;
aDrivingData.Magnetic_Flied_X = aData.magneticField.x;
aDrivingData.Magnetic_Field_Y = aData.magneticField.y;
aDrivingData.Magnetic_Field_Z = aData.magneticField.z;
var factory = new DbConnectionFactory("testDatabase");
var context = new DbContext(factory);
var sessionHistoryRepo = new Session_HistoryRepository(context);
bool flag = sessionHistoryRepo.checkSession(aDrivingData.Session_Id);
if (flag)
{
var sessionHistory = new Session_History();
sessionHistory.Session_Id = aDrivingData.Session_Id;
sessionHistory.User_Id = aDrivingData.User_Id;
sessionHistory.Start_time = DateTime.Now;
sessionHistoryRepo.Insert(sessionHistory);
}
User_Driving_DataRepository arepo = new User_Driving_DataRepository(context);
//////////////////////////////////////////////////Username
//If you want use username instead of userid -------(change json model userid-> username)
//
//
//
//int untid = aUrepo.GetUserID(Username).User_Id;
//aDrivingData.User_Id = untid;
////////////////////////////////////////////////
arepo.Insert(aDrivingData);
}
