Exemplo n.º 1
0
        public String ReadBouquets(Int32 id_version_bouquet)
        {
            BDBouquets dbQuery = new BDBouquets();
            DataSet    ds      = dbQuery.ConsultarRecetas(id_version_bouquet);
            var        query   = new BLL_Bouquets().BuildBouquet(ds.Tables[0]);

            dbQuery.Cerrar();
            return(new JavaScriptSerializer().Serialize(query));
        }
Exemplo n.º 2
0
        public String ReadDetailBouquet(Int32 id_version_bouquet, Int32 id_formula_bouquet)
        {
            BDBouquets dbQuery = new BDBouquets();
            DataSet    ds      = dbQuery.ConsultarRecetas(id_version_bouquet);
            DataTable  dt      = ds.Tables[1].Clone();

            ds.Tables[1].Select(String.Format("id_formula_bouquet = {0}", id_formula_bouquet)).Take(1).CopyToDataTable(dt, LoadOption.Upsert);
            var query = new BLL_Bouquets().BuildDetailBouquet(dt);

            dbQuery.Cerrar();
            return(new JavaScriptSerializer().Serialize(query));
        }
Exemplo n.º 3
0
        public String ReadSearchRecipe(String texto, String items_a_buscar, String texto2, String items_a_buscar2)
        {
            BDBouquets dbQuery = new BDBouquets();
            DataSet    ds      = dbQuery.ConsultarRecetas(texto, items_a_buscar, texto2, items_a_buscar2);
            DataTable  dt      = ds.Tables[0].Clone();

            ds.Tables[0].Select().Take(100).CopyToDataTable(dt, LoadOption.Upsert);
            var query = new BLL_Bouquets().GenericBuilder(dt);

            dbQuery.Cerrar();
            return(new JavaScriptSerializer().Serialize(query));
        }