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