public T SelectById(ObjectId id) { BsonDocument document = Uow.ExecuteRetrieveFirst(CollectionName, Builders <BsonDocument> .Filter.Eq("_id", id)); return(DeserializeDocument <T>(document)); }
public Household SelectByUsername(string username) { FilterDefinition <BsonDocument> filterDefinition = Builders <BsonDocument> .Filter.Eq("Username", username); BsonDocument document = Uow.ExecuteRetrieveFirst(CollectionName, filterDefinition); return(DeserializeDocument <Household>(document)); }
public Schedule SelectByDevice(ObjectId deviceId) { FilterDefinition <BsonDocument> filterDefinition = Builders <BsonDocument> .Filter.Eq("DeviceId", deviceId); BsonDocument document = Uow.ExecuteRetrieveFirst(CollectionName, filterDefinition); return(DeserializeDocument <Schedule>(document)); }
public bool CheckRequestingResetPw(string username) { FilterDefinition <BsonDocument> filterDefinition = Builders <BsonDocument> .Filter.Eq("Username", username); BsonDocument document = Uow.ExecuteRetrieveFirst(CollectionName, filterDefinition); Household household = DeserializeDocument <Household>(document); return(household != null && household.IsResetPassword); }
public Household Login(string username, string password) { FilterDefinition <BsonDocument> filterDefinition = Builders <BsonDocument> .Filter.Eq("Username", username); filterDefinition &= Builders <BsonDocument> .Filter.Eq("Password", password); BsonDocument document = Uow.ExecuteRetrieveFirst(CollectionName, filterDefinition); return(DeserializeDocument <Household>(document)); }
public Household SelectByAddress(string street, int postalCode, string unitNo) { FilterDefinition <BsonDocument> filterDefinition = Builders <BsonDocument> .Filter.Eq("Street", street); filterDefinition &= Builders <BsonDocument> .Filter.Eq("PostalCode", postalCode); filterDefinition &= Builders <BsonDocument> .Filter.Eq("UnitNo", unitNo); BsonDocument document = Uow.ExecuteRetrieveFirst(CollectionName, filterDefinition); return(DeserializeDocument <Household>(document)); }
public DeviceLog SelectIndividual(ObjectId householdId, string location, string type, DateTime start, DateTime end) { FilterDefinition <BsonDocument> filterDefinition = Builders <BsonDocument> .Filter.Eq("HouseholdId", householdId); filterDefinition &= Builders <BsonDocument> .Filter.Eq("Location", location); filterDefinition &= Builders <BsonDocument> .Filter.Eq("Type", type); filterDefinition &= Builders <BsonDocument> .Filter.Gte("DateTime", start); filterDefinition &= Builders <BsonDocument> .Filter.Lte("DateTime", end); BsonDocument document = Uow.ExecuteRetrieveFirst(CollectionName, filterDefinition); return(DeserializeDocument <DeviceLog>(document)); }