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)); }
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)); }
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)); }