public static async Task <List <Actors> > GetActors(GetActorInput Parameters) { var List = new List <Actors>(); var projection = Builders <Actors> .Projection; var project = projection.Exclude("_id"); var filter = FilterDefinition <Actors> .Empty; BsonValue val; if (Parameters.ColumnType == "int") { val = Convert.ToInt64(Parameters.Value); } else if (Parameters.ColumnType == "bool") { val = Convert.ToBoolean(Parameters.Value); } else { val = Convert.ToString(Parameters.Value); } if (Parameters.Statement == "=") { filter = Builders <Actors> .Filter.Eq(Parameters.Column, val); } else if (Parameters.Statement == "<") { filter = Builders <Actors> .Filter.Lt(Parameters.Column, val); } else if (Parameters.Statement == ">") { filter = Builders <Actors> .Filter.Gt(Parameters.Column, val); } var option = new FindOptions <Actors, BsonDocument> { Projection = project }; using (var cursor = await db.GetCollection <Actors>("Actors").FindAsync(filter, option)) { while (await cursor.MoveNextAsync()) { var batch = cursor.Current; foreach (BsonDocument s in batch) { var Actors = new Actors(); if (s.Contains("ActorID")) { Actors.ActorID = s["ActorID"].AsString; } if (s.Contains("ActorName")) { Actors.ActorName = s["ActorName"].AsString; } if (s.Contains("Actorİmage")) { Actors.Actorİmage = s["Actorİmage"].AsString; } List.Add(Actors); } } } return(List); }
public async Task <List <Actors> > GetActors(GetActorInput Parameters) { return(await ActorsManager.GetActors(Parameters)); }