public void SaveGPSPositionGH3000(GPSdata gpsPos) { DBUtils db = new DBUtils(); SqlCommand sp = db.InitQuery(@" INSERT INTO GPS_Real (ModemId, [ServerTimestamp], Long, Lat, Altitude, Direction, Satellites, Speed) VALUES (@ModemId, @ServerTimestamp, @Long, @Lat, @Altitude, @Direction, @Satellites, @Speed)"); sp.Parameters.AddWithValue("@ModemId", gpsPos.Direction.ToString()); sp.Parameters.AddWithValue("@ServerTimestamp", gpsPos.Direction.ToString()); sp.Parameters.AddWithValue("@Long", gpsPos.Direction.ToString()); sp.Parameters.AddWithValue("@Lat", gpsPos.Direction.ToString()); sp.Parameters.AddWithValue("@Altitude", gpsPos.Direction.ToString()); sp.Parameters.AddWithValue("@Direction", gpsPos.Direction.ToString()); sp.Parameters.AddWithValue("@Satellites", gpsPos.Direction.ToString()); sp.Parameters.AddWithValue("@Speed", gpsPos.Direction.ToString()); db.ExecQuery(sp); try { db.ExecSP(sp); } catch (Exception ex) { WriteIntoFile.write(ex.ToString()); } finally { db.FreeSP(sp); } }
public void SaveGPSElementsFMXXXX(string IMEI, GPSElement _gpsElement) { DBUtils db = new DBUtils(); string sqlQuery = (@"INSERT INTO [GPS_Tracking].[dbo].[GPS_Element] ([IMEI] ,[ignition] ,[movement] ,[dataMode] ,[gsmSignalStrength] ,[sleepMode] ,[GNSSStatus] ,[DIN1] ,[DOUT1] ,[SDStatus] ,[bleBatteryVolt1] ,[bleBatteryVolt2] ,[bleBatteryVolt3] ,[bleBatteryVolt4] ,[PDOP] ,[HDOP] ,[extVolt] ,[speed] ,[gsmCellID] ,[gsmAreaCode] ,[batteryVoltage] ,[batteryCurrent] ,[AIN1] ,[averageFuelUse] ,[xaxis] ,[yaxis] ,[zaxis] ,[ecoScore] ,[bleTemp1] ,[bleTemp2] ,[bleTemp3] ,[bleTemp4] ,[bleHumidity1] ,[bleHumidity2] ,[bleHumidity3] ,[bleHumidity4] ,[gsmOperator] ,[tripOdoMeter] ,[totalOdoMeter] ,[fuelUsedGPS] ,[ICCID1] ,[ICCID2] ,[userID]) VALUES (@IMEI ,@ignition ,@movement ,@dataMode ,@gsmSignalStrength ,@sleepMode ,@GNSSStatus ,@DIN1 ,@DOUT1 ,@SDStatus ,@bleBatteryVolt1 ,@bleBatteryVolt2 ,@bleBatteryVolt3 ,@bleBatteryVolt4 ,@PDOP ,@HDOP ,@extVolt ,@speed ,@gsmCellID ,@gsmAreaCode ,@batteryVoltage ,@batteryCurrent ,@AIN1 ,@averageFuelUse ,@xaxis ,@yaxis ,@zaxis ,@ecoScore ,@bleTemp1 ,@bleTemp2 ,@bleTemp3 ,@bleTemp4 ,@bleHumidity1 ,@bleHumidity2 ,@bleHumidity3 ,@bleHumidity4 ,@gsmOperator ,@tripOdoMeter ,@totalOdoMeter ,@fuelUsedGPS ,@ICCID1 ,@ICCID2 ,@userID)"); SqlCommand sp = db.InitQuery(sqlQuery); sp.Parameters.AddWithValue("@IMEI", IMEI); sp.Parameters.AddWithValue("@ignition", _gpsElement.ignition); sp.Parameters.AddWithValue("@movement", _gpsElement.movement); sp.Parameters.AddWithValue("@dataMode", _gpsElement.dataMode); sp.Parameters.AddWithValue("@gsmSignalStrength", _gpsElement.gsmSignalStrength); sp.Parameters.AddWithValue("@sleepMode", _gpsElement.sleepMode); sp.Parameters.AddWithValue("@GNSSStatus", _gpsElement.GNSSStatus); sp.Parameters.AddWithValue("@DIN1", _gpsElement.DIN1); sp.Parameters.AddWithValue("@DOUT1", _gpsElement.DOUT1); sp.Parameters.AddWithValue("@SDStatus", _gpsElement.SDStatus); sp.Parameters.AddWithValue("@bleBatteryVolt1", _gpsElement.bleBatteryVolt1); sp.Parameters.AddWithValue("@bleBatteryVolt2", _gpsElement.bleBatteryVolt2); sp.Parameters.AddWithValue("@bleBatteryVolt3", _gpsElement.bleBatteryVolt3); sp.Parameters.AddWithValue("@bleBatteryVolt4", _gpsElement.bleBatteryVolt4); sp.Parameters.AddWithValue("@PDOP", _gpsElement.PDOP); sp.Parameters.AddWithValue("@HDOP", _gpsElement.HDOP); sp.Parameters.AddWithValue("@extVolt", _gpsElement.extVolt); sp.Parameters.AddWithValue("@speed", _gpsElement.speed); sp.Parameters.AddWithValue("@gsmCellID", _gpsElement.gsmCellID); sp.Parameters.AddWithValue("@gsmAreaCode", _gpsElement.gsmAreaCode); sp.Parameters.AddWithValue("@batteryVoltage", _gpsElement.batteryVoltage); sp.Parameters.AddWithValue("@batteryCurrent", _gpsElement.batteryCurrent); sp.Parameters.AddWithValue("@AIN1", _gpsElement.AIN1); sp.Parameters.AddWithValue("@averageFuelUse", _gpsElement.averageFuelUse); sp.Parameters.AddWithValue("@xaxis", _gpsElement.xaxis); sp.Parameters.AddWithValue("@yaxis", _gpsElement.yaxis); sp.Parameters.AddWithValue("@zaxis", _gpsElement.zaxis); sp.Parameters.AddWithValue("@ecoScore", _gpsElement.ecoScore); sp.Parameters.AddWithValue("@bleTemp1", _gpsElement.bleTemp1); sp.Parameters.AddWithValue("@bleTemp2", _gpsElement.bleTemp2); sp.Parameters.AddWithValue("@bleTemp3", _gpsElement.bleTemp3); sp.Parameters.AddWithValue("@bleTemp4", _gpsElement.bleTemp4); sp.Parameters.AddWithValue("@bleHumidity1", _gpsElement.bleHumidity1); sp.Parameters.AddWithValue("@bleHumidity2", _gpsElement.bleHumidity2); sp.Parameters.AddWithValue("@bleHumidity3", _gpsElement.bleHumidity3); sp.Parameters.AddWithValue("@bleHumidity4", _gpsElement.bleHumidity4); sp.Parameters.AddWithValue("@gsmOperator", _gpsElement.gsmOperator); sp.Parameters.AddWithValue("@tripOdoMeter", _gpsElement.tripOdoMeter); sp.Parameters.AddWithValue("@totalOdoMeter", _gpsElement.totalOdoMeter); sp.Parameters.AddWithValue("@fuelUsedGPS", _gpsElement.fuelUsedGPS); sp.Parameters.AddWithValue("@ICCID1", _gpsElement.ICCID1); sp.Parameters.AddWithValue("@ICCID2", _gpsElement.ICCID2); sp.Parameters.AddWithValue("@userID", _gpsElement.userID); ////LoggerInLogger(sqlQuery); db.ExecQuery(sp); try { db.ExecSP(sp); } catch (Exception ex) { WriteIntoFile.write(ex.ToString()); } finally { db.FreeSP(sp); } }