public void UpdateLastLocations(string id, string serial) { if (RecordExists <SerialInfo>("Serial", serial, "serial")) { SerialInfo list = LoadRecords <SerialInfo>("Serial", "serial", serial)[0]; var collection = db.GetCollection <SerialInfo>("Serial"); //loop through each locationData object and if object doesn't match the id of most recent entry then set last location to false, otherwise true foreach (LocationData ld in list.locationData) { // Save the entire document back to the database if (ld.ID != id) { collection.FindOneAndUpdate(c => c.serial == serial && c.locationData.Any(s => s.ID == ld.ID), Builders <SerialInfo> .Update.Set(c => c.locationData[-1].lastLocation, false)); } else { collection.FindOneAndUpdate(c => c.serial == serial && c.locationData.Any(s => s.ID == ld.ID), Builders <SerialInfo> .Update.Set(c => c.locationData[-1].lastLocation, true)); collection.FindOneAndUpdate(c => c.serial == serial, Builders <SerialInfo> .Update.Set(c => c.caseID, ld.curCase)); } } } }
private void CheckInDevices(List <DeviceObject> devices) { foreach (DeviceObject device in devices) { SerialInfo si = new SerialInfo(); si.serial = device.serialID; LocationData d = new LocationData(); d.curCase = device.caseID; d.date = DateTime.UtcNow.Date.ToString("MM/dd/yyyy"); d.time = DateTime.Now.ToString("h:mm:ss tt"); d.location = device.location; d.lastLocation = true; d.userID = "311015"; si.locationData.Add(d); if (MongoCRUD.GetInstance().RecordExists <SerialInfo>("Serial", device.serialID, "serial")) { MongoCRUD.GetInstance().AppendRecord <SerialInfo>("Serial", device.serialID, d); } else { MongoCRUD.GetInstance().InsertRecord("Serial", si, device.serialID, device.caseID); } CaseInfo ci = new CaseInfo(); ci.caseID = device.caseID; ci.curLoc = device.location; ci.ageInfo = DateTime.Now.ToString("MM-dd-yyyy hh: mm tt"); MongoCRUD.GetInstance().InsertRecord("Cases", ci, device.caseID, null); AreaInfo a = null; List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", null, null); foreach (AreaInfo area in areas) { foreach (LocationObject loc in area.locationsList) { if (device.location == loc.locName) { a = area; break; } } } if (a != null) { UpdateAreaLocCases(ci, a); } } }
public void UpdateCaseSerials(string serial) { if (RecordExists <SerialInfo>("Serial", serial, "serial")) { SerialInfo si = LoadRecords <SerialInfo>("Serial", "serial", serial)[0]; if (RecordExists <CaseInfo>("Cases", si.caseID, "caseID")) { var collection = db.GetCollection <CaseInfo>("Cases"); CaseInfo ci = LoadRecords <CaseInfo>("Cases", "caseID", si.caseID)[0]; if (!ci.serialList.Contains(si)) { collection.FindOneAndUpdate(c => c.caseID == ci.caseID, Builders <CaseInfo> .Update.Push(c => c.serialList, si)); } } } }