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));
}
