public static void DeActivate(int id) { var q = db.Groups.First(x => x.GroupId == id); q.Status = false; db.SaveChanges(); }
public static void RemoveGroupAlertsByGroupId(int groupId) { var gAlerts = db.GroupAlerts.Where(x => x.GroupId == groupId); foreach (var item in gAlerts) { db.GroupAlerts.DeleteObject(item); } db.SaveChanges(); }
public bool UpdateVibe(int vibe, string phonenumber) { bool retval = true; GPSTrackerEntities1 context = new GPSTrackerEntities1(); // Create or overwrite LimerInfo for user LR_LimerInfo _info = context.LR_LimerInfo.Where(p => p.TrackerId == phonenumber).FirstOrDefault(); if (_info == null) { retval = false; } else { _info.Vibe = vibe; try { context.SaveChanges(); } catch (System.Exception e) { ExceptionHandler.HandleGeneralException(e); retval = false; } } return(retval); }
public static void Save(AlertLog alertlog) { var db = new GPSTrackerEntities1(); db.AlertLogs.AddObject(alertlog); db.SaveChanges(); }
public static void Save(LocationMessageAlert locationMessageAlert) { var db = new GPSTrackerEntities1(); db.LocationMessageAlerts.AddObject(locationMessageAlert); db.SaveChanges(); }
public bool Add(string trackerId, string mileageCount, string maintenanceNote) { try { //dirty GPSTrackerEntities1 context = new GPSTrackerEntities1(); Maintenance m = context.Maintenance.CreateObject(); m.trackerId = trackerId; m.mileage = Double.Parse(mileageCount); m.notes = maintenanceNote; m.dateTimeRecorded = DateTime.Now; // Need to update table and last set location message? Trackers _tracker = context.Trackers.Where(t => t.Id == trackerId).FirstOrDefault(); _tracker.Mileage = double.Parse(mileageCount); context.Maintenance.AddObject(m); context.SaveChanges(); return(true); } catch (System.Exception ex) { return(false); } }
public static void Save(AlertFired alertFired) { var db = new GPSTrackerEntities1(); db.AlertFireds.AddObject(alertFired); db.SaveChanges(); }
/// <summary> /// Needs to be updated to update general tracking information /// </summary> /// <param name="?"></param> public static void UpdateTrackerInformation(LocationMessages message) { GPSTrackerEntities1 context = new GPSTrackerEntities1(); Trackers _tracker = context.Trackers.Where(t => t.Id == message.TrackerId).FirstOrDefault(); _tracker.LastUpdate = DateTime.Now; _tracker.LastLat = (new Latitude() { Degrees = message.LatDegrees, Minutes = message.LatMinutes, Seconds = message.LatSeconds, Heading = message.LatitudeHeading[0] }).Decimal; _tracker.LastLon = (new Longitude() { Degrees = message.LngDegrees, Minutes = message.LngMinutes, Seconds = message.LngSeconds, Heading = message.LongitudeHeading[0] }).Decimal; if (message.Id != 0) { _tracker.LastLocationId = message.Id; } context.SaveChanges(); }
public static void UpdateByTrackerId(string trackerId) { var db = new GPSTrackerEntities1(); var data = db.LocationMessageAlerts.FirstOrDefault(x => x.TrackerId == trackerId && x.IsProcessed == false); data.IsProcessed = true; db.SaveChanges(); }
public static void ProcessedAlertExitFired(int id) { var db = new GPSTrackerEntities1(); var data = db.AlertFireds.FirstOrDefault(x => x.Id == id); // data.IsEnter = true; data.IsExit = true; data.Active = false; db.SaveChanges(); }
public static void Save(GeoFence geoFence) { if (geoFence.FencesId == 0) { geoFence.CreatedDate = DateTime.Now; db.GeoFences.AddObject(geoFence); } geoFence.UpdatedDate = DateTime.Now; db.SaveChanges(); }
public bool CompleteRegistration(string fname, string lname, string phonenumber, string passcode) { bool retval = true; GPSTrackerEntities1 context = new GPSTrackerEntities1(); LR_Passcode pass = context.LR_Passcode.Where(p => p.phonenumber == phonenumber).FirstOrDefault(); retval = pass != null && pass.Passcode.Trim() == passcode.Trim(); if (retval) { Trackers newTracker = context.Trackers.Where(t => t.Id == phonenumber).FirstOrDefault(); // test that this works if tracker does not exist and if it does exist if (newTracker == null) { newTracker = new Trackers(); context.Trackers.AddObject(newTracker); newTracker.Id = phonenumber; } newTracker.Name = fname + " " + lname; newTracker.Type = "TYPMB"; newTracker.Status = "LR002"; // Create or overwrite LimerInfo for user LR_LimerInfo _info = context.LR_LimerInfo.Where(p => p.TrackerId == phonenumber).FirstOrDefault(); if (_info == null) { _info = new LR_LimerInfo(); context.LR_LimerInfo.AddObject(_info); _info.TrackerId = phonenumber; } _info.Vibe = 1; _info.Status = 3; _info.Message = "Hey, I'm on LimeR!!!"; try { context.SaveChanges(); } catch (System.Exception e) { ExceptionHandler.HandleGeneralException(e); retval = false; } } return(retval); }
public static bool UpdateTrackerInformation(CellLocationMessage message) { bool retval = true; GPSTrackerEntities1 context = new GPSTrackerEntities1(); Trackers _tracker = context.Trackers.Where(t => t.Id == message.TrackerID).FirstOrDefault(); _tracker.LastUpdate = DateTime.Now; _tracker.LastLat = message.Latitude.Decimal; _tracker.LastLon = message.Longitude.Decimal; context.SaveChanges(); return(retval); }
/// <summary> /// Needs to be updated to update general tracking information /// </summary> /// <param name="?"></param> public static void UpdateTrackerInformation(GTSLocationMessage message) { GPSTrackerEntities1 context = new GPSTrackerEntities1(); Trackers _tracker = context.Trackers.Where(t => t.Id == message.TrackerID).FirstOrDefault(); _tracker.LastUpdate = DateTime.Now; _tracker.LastLat = message.Latitude.Decimal; _tracker.LastLon = message.Longitude.Decimal; if (message.Id != 0) { _tracker.LastLocationId = message.Id; } context.SaveChanges(); }
// Method that shares the tracker information with Security Personel Assigned // Currently First Response TODO: Update to assign response team based on location or something public static bool AlertSecurity(string trackerId) { // First response User Id 172D2D4A-8711-48EC-9ADE-D0660D4568E0 GPSTrackerEntities1 context = new GPSTrackerEntities1(); try { TrackerUser tu = TrackerUser.CreateTrackerUser(1, trackerId, new Guid("172D2D4A-8711-48EC-9ADE-D0660D4568E0"), true); context.AddToTrackerUser(tu); context.SaveChanges(); } catch (System.Exception e) { ExceptionHandler.HandleGeneralException(e); return(false); } return(true); }
public void SaveEvents(List <Event> events) { // if event id exist, then update GTSDataStorage.Event eventt; foreach (Event e in events) { if (e.EventId == 0) { eventt = GTSDataStorage.Event.CreateEvent(0, e.EventDescription, e.GetTrackerEventType, e.Time, e.ObjectId); eventt.ExtendedProperties = e.ExtendedProperties; context.AddToEvents(eventt); } else { eventt = context.Events.Where(t => t.Id == e.EventId).FirstOrDefault(); eventt.Description = e.EventDescription; eventt.ExtendedProperties = e.ExtendedProperties; } context.SaveChanges(); } }
public bool StartSMSRegistration(string phonenumber) { GPSTrackerEntities1 context = new GPSTrackerEntities1(); bool retval = true; // Get 4 digit random pass code string passcode = getPasscode(); // Send pascode to phone number retval = retval && sendSMS(phonenumber, "This is your passcode: " + passcode); // save pass code and phone number to table. Check to see if exist already LR_Passcode passCode = context.LR_Passcode.Where(p => p.phonenumber == phonenumber).FirstOrDefault(); if (passCode == null) { passCode = new LR_Passcode(); context.AddToLR_Passcode(passCode); } passCode.Passcode = passcode; passCode.phonenumber = phonenumber; try { context.SaveChanges(); } catch (System.Exception e) { retval = false; } return(retval); }
public static void SaveTrackerInformation(GTSLocationMessage message) { GTSLocationMessage prevMessage = getLastLocationMessage(message.TrackerID); GPSTrackerEntities1 context = new GPSTrackerEntities1(); LocationMessages msg; double mileage; // Update total milage TODO: we need to add in the engine on check here!!!! After we put engine on as a standard on all vehicles if (message.Speed != 0) { //Calculate what the mileage on the tracker should be try { //get the Tracker (this is probably done elsewhere, so it's an extra hit) Trackers _tracker = context.Trackers.Where(t => t.Id == message.TrackerID).FirstOrDefault(); //if we didnt have a mileage reading before, get it from Tracker if it exists, else assume it's 0 and start counting from there. double mileageChange; if (_tracker.Mileage.HasValue && _tracker.Mileage.Value > 0.0) { mileageChange = Utilities.CalculateDistanceBetween(_tracker.LastLat.Value, _tracker.LastLon.Value, message.Latitude.Decimal, message.Longitude.Decimal); mileage = _tracker.Mileage.Value + mileageChange; //update tracker mileage value too } else { mileage = 0; } _tracker.Mileage = mileage; //saving here to make sure we don't throw off anything else later down by doing a batch save // this is a wasted DB hit though. context.SaveChanges(); } catch (System.Exception ex) { //swallow for now mileage = 0.0; } } else { mileage = prevMessage != null?prevMessage.Mileage.GetValueOrDefault() : 0; } if (prevMessage == null || prevMessage.Speed != 0 || message.Speed != 0 || Math.Abs(prevMessage.Latitude.Decimal - message.Latitude.Decimal) > 0.001 || Math.Abs(prevMessage.Longitude.Decimal - message.Longitude.Decimal) > 0.001 || prevMessage.Status != message.Status) { // add new message into messages msg = LocationMessages.CreateLocationMessages(1, message.RawLocationMessageData, message.Latitude.Degrees , message.Latitude.Minutes, message.Latitude.Seconds, message.Longitude.Degrees, message.Longitude.Minutes , message.Longitude.Seconds, message.ServerRecordedDateTime, message.TrackerID, message.Latitude.Heading.ToString(), message.Longitude.Heading.ToString(), message.Speed, message.IdleTime, message.Direction, message.Status, message.ClientRecordedDateTime, message.HDOP, message.VDOP, message.Altitude, message.Status, message.Input1, message.Input2, message.DInput1, message.DInput2, message.DInput3, message.DInput4, message.DInput5, mileage); context.AddToLocationMessages(msg); int affectedRows = context.SaveChanges(); message.Id = msg.Id; } else { // update time on previous message //weird..... must be some better way of architechting this...... as well should be exception handeled!!! //vs: If it's in the same spot, we don't need to do anything with mileage TimeSpan span = message.ServerRecordedDateTime.Subtract(prevMessage.ServerRecordedDateTime); prevMessage.IdleTime = span.Ticks; msg = context.LocationMessages.Where(m => m.Id == prevMessage.Id).First(); message.IdleTime = msg.IdleTime = prevMessage.IdleTime; context.SaveChanges(); } if (msg != null) { UpdateTrackerInformation(msg); } // Events pulled from information in the Location Messages // All Hooks so far for events are here - lets keep it so until needed List <Events.Event> events = new Events.Management().GetVT310eEvents(message, prevMessage); new Events.Management().SaveEvents(events); Utilities.writeLine("Debug 30: Message Saved!"); }
public static void Add(TrackerFenceMap trackerFenceMap) { db.AddToTrackerFenceMaps(trackerFenceMap); db.SaveChanges(); }
public static void Add(UserFenceMap userFenceMap) { db.AddToUserFenceMaps(userFenceMap); db.SaveChanges(); }