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); }
public HttpResponseMessage post(Driving_Data alist) { HttpResponseMessage response = null; try { Map_User_Driving_Data_Helper aMap = new Map_User_Driving_Data_Helper(); aMap.Map_data(alist); response = Request.CreateResponse(HttpStatusCode.OK, "Success"); } catch (Exception) { response = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error"); } return(response); }
public Driving_Data Get() { //[{"xData":"23","yData":"43","zData":"64"},{"xData":"233","yData":"443","zData":"634"}] //Sweq List <Driving_Data> alist = new List <Driving_Data>(); Driving_Data p1 = new Driving_Data(); p1.userID = 1; p1.streetName = "yoyo"; p1.speedLimit = 90.00; //p1.datetime = "2009-05-01T14:18:12.430"; p1.speed = 67; p1.course = 170; p1.gravity = new Gravity(222.2, 12.12, 121212111.111); p1.rotationRate = new RotationRate(00.23, 12.23, 0.23); p1.magneticField = new MagneticField(4.23, 2.4, 1.5); p1.userAcceleration = new UserAcceleration(1.2, 1.4, 4.4); p1.coordinate = new Coordinate(2.3, 23, 0.44); Driving_Data p2 = new Driving_Data(); p2.userID = 1; p2.streetName = "y3o"; p2.speedLimit = 30.00; //DateTime adateTime= DateTime.UtcNow; //p2.datetime = Serialize(adateTime.ToString("yyyy-MM-dd'T'HH:mm:ss.fffffffzzz")); p2.datetime = DateTime.UtcNow; p2.speed = 90; p2.course = 130; p2.gravity = new Gravity(21.3, 3.2, 0.031); p2.rotationRate = new RotationRate(023.23, 12.2323, 32.23); p2.magneticField = new MagneticField(23.23, 23.4, 32.5); p2.userAcceleration = new UserAcceleration(32.23, 21.23, 34.23); p2.coordinate = new Coordinate(2.3, 23, 0.44); alist.Add(p1); alist.Add(p2); return(p2); }