Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
 public async Task <List <Actors> > GetActors(GetActorInput Parameters)
 {
     return(await ActorsManager.GetActors(Parameters));
 }