public static List <UserLoginStatusDataModel> GetList() { var resultList = new List <UserLoginStatusDataModel>(); var userLogin = database.GetCollection <BsonDocument>("UserLoginStatus"); var filter = new BsonDocument(); DataTable dt = new DataTable(); foreach (BsonDocument obj in userLogin.Find(filter).ToListAsync().Result) { resultList.Add(UserLoginStatusMongoDbDataManager.MapToUserLoginStatusRecord(obj)); } return(resultList); }
public static List <UserLoginStatusDataModel> GetList(UserLoginStatusDataModel data, RequestProfile requestProfile) { var resultList = new List <UserLoginStatusDataModel>(); var statusData = database.GetCollection <BsonDocument>("UserLoginStatus"); var listUserLoginStatus = new List <BsonDocument>(); var builder = Builders <BsonDocument> .Filter; if (string.IsNullOrEmpty(data.Name) && string.IsNullOrEmpty(data.ApplicationId.ToString())) { resultList = GetList(); } else { if (!string.IsNullOrEmpty(data.Name) && !string.IsNullOrEmpty(data.ApplicationId.ToString())) { var filter = builder.Eq(UserLoginStatusDataModel.DataColumns.Name, data.Name) & builder.Eq(UserLoginStatusDataModel.DataColumns.ApplicationId, data.ApplicationId); listUserLoginStatus = statusData.Find(filter).ToListAsync().Result; } else if (!string.IsNullOrEmpty(data.Name) || !string.IsNullOrEmpty(data.ApplicationId.ToString())) { var filter = builder.Eq(UserLoginStatusDataModel.DataColumns.Name, data.Name) | builder.Eq(UserLoginStatusDataModel.DataColumns.ApplicationId, data.ApplicationId); listUserLoginStatus = statusData.Find(filter).ToListAsync().Result; } if (listUserLoginStatus != null) { foreach (BsonDocument obj in listUserLoginStatus) // Loop thru all Bson documents returned from the query. { resultList.Add(UserLoginStatusMongoDbDataManager.MapToUserLoginStatusRecord(obj)); } } } return(resultList); }