Пример #1
0
        async static void GetData()
        {
            ISchemaContext ctx = new SchemaDb();
            dynamic contacts2 = new ExpandoObject();
            (contacts2 as IDictionary<string, object>).Add("Usia", 39);
            contacts2.Name = "Asep XX";
            contacts2.Phone = "206-555-0155";
            contacts2.House = new List<dynamic>();
            contacts2.House.Add(new ExpandoObject());
            contacts2.House[0].Address = "Jln. Klumet";
            contacts2.House[0].POBox = "23456";
            contacts2._id = 1;
           

            IDataContext dtx = new InMemoryDb("lake",ctx);

            dtx.InsertData(contacts2, "contacts");
            //dtx.InsertData(contacts2, "contacts");
            var datas = await dtx.GetAllData("contacts");
            //var datas = await dtx.GetDataByStartId(2,1,"contacts");
            foreach (dynamic item in datas)
            {
                Console.WriteLine($"{item.House[0].Address}");
                //Console.WriteLine(SchemaConverter.AreExpandoStructureEquals(item, contacts2));
                //(item as IDictionary<string, object>)["Usia"]= 31;
               
                //dtx.UpdateData(item, "contacts");
            }
        }
Пример #2
0
        static void Main(string[] args)
        {
            HttpClient client = new HttpClient();
            var nameValues = new Dictionary<string, string>();
            nameValues.Add("data", @"{""Nama"":""SENSOR 004"",""Lokasi"":""L003"",""Nilai"":22}");
            var Name = new FormUrlEncodedContent(nameValues);
            client.PostAsync("http://*****:*****@"select id,evid_cislo,nazov,adresa,ulica,vec,datum_zal,datum_odos,ukoncene_dna  from koresp  
where ((id_typ <= 3 or id_typ = 4) 
 and (datum_zal > datum_odos)) or (id > 21) 
order by nazov desc ,id asc";
            string CAML = SqlToCAML.TextSqlToCAML(SqlStr);
            WriteLine(CAML);

            //test caml to sql where
            string CAML2 = @"<Where>
  <And>
    <Or>
      <Geq>
        <FieldRef Name='Microfilm' />
        <Value Type='Text'>10</Value>
      </Geq>
      <Leq>
        <FieldRef Name='Microfilm' />
        <Value Type='Text'>50</Value>
      </Leq>
    </Or>
    <BeginsWith>
      <FieldRef Name='Title' />
      <Value Type='Text'>Ice</Value>
    </BeginsWith> 
  </And>
</Where>";
            string Sql2 = CamlToSql.CamlToSqlWhere(CAML2);
            WriteLine(Sql2);

            WriteLine(SampleLinqToCaml.GetLinqToCaml());
            Console.ReadLine();
            /*
            ISchemaContext ctx = new SchemaDb();
            dynamic contacts = new System.Dynamic.ExpandoObject();
            (contacts as IDictionary<string, object>).Add("Usia", 40);
            contacts.Name = "Patrick Hines";
            contacts.Phone = "206-555-0144";
            (contacts as IDictionary<string, object>).Add("House", new List<dynamic>());
            contacts.House.Add(new System.Dynamic.ExpandoObject());
            contacts.House[0].Address = "Jln. Klumeten";
            contacts.House[0].POBox = "7658";

            dynamic contacts2 = new ExpandoObject();
            (contacts2 as IDictionary<string, object>).Add("Usia", 39);
            contacts2.Name = "Ellen Adams";
            contacts2.Phone = "206-555-0155";
            contacts2.House = new List<dynamic>();
            contacts2.House.Add(new ExpandoObject());
            contacts2.House[0].Address = "Jln. Klumet";
            contacts2.House[0].POBox = "23456";
           
            Console.WriteLine(SchemaConverter.AreExpandoStructureEquals(contacts, contacts2));
            //GetData();
            //dtx.InsertData<dynamic>(contacts, "contacts");
            SchemaEntity item = SchemaConverter.ExpandoToSchema(contacts, nameof(contacts));
            item.Id = ctx.GetSequence<SchemaEntity>();
            ctx.InsertData<SchemaEntity>(item);
            */
            /*
            var data = ctx.GetAllData<SchemaEntity>();
            foreach(var item in data)
            {
                dynamic obj = SchemaConverter.JsonToExpando(item.JsonStructure);
                if (obj is ExpandoObject)
                {
                    foreach (var property in (IDictionary<String, Object>)obj)
                    {
                        if (property.Value is ExpandoObject)
                        {
                            //do nothing

                        }
                        else if (property.Value is List<dynamic>)
                        {
                            foreach (var element in (List<dynamic>)property.Value)
                            {
                                if (element is ExpandoObject)
                                {
                                    foreach (var pr in (IDictionary<String, Object>)element)
                                    {
                                        Console.WriteLine($"{pr.Key} as {pr.Value.GetType().ToString()} = {pr.Value}");
                                    }
                                }
                            }
                        }
                        else
                        {
                            Console.WriteLine($"{property.Key} as {property.Value.GetType().ToString()} = {property.Value}");
                        }

                    }
                }
                
            }*/
            Console.ReadLine();
        }