public String ConsultarDetallePO(Int32 idDetallePO)
{
DataSet ds = new DataSet();
String response = String.Empty;
//HttpContext.Current.Session["SessionPO"] = po;
//HttpContext.Current.Session["id_usuario"] = usuario;
BDBouquets dbQuery = new BDBouquets();
//if (String.IsNullOrEmpty(po))
//{
ds = dbQuery.ConsultarBouquet(idDetallePO);
var query = new BLL_Bouquets().BuildRecipePO(ds.Tables[0]);
response = new JavaScriptSerializer().Serialize(query);
//}
////else
////{
// ds = dbQuery.DetallePO(Int32.Parse(HttpContext.Current.Session["SessionPO"].ToString()), Int32.Parse(HttpContext.Current.Session["id_usuario"].ToString()));
// var query = new BLL_Bouquets().BuildRecipePO(ds.Tables[0]).Where(bouquet => bouquet.id_detalle_po == idDetallePO);
// response = new JavaScriptSerializer().Serialize(query);
////}
dbQuery.Cerrar();
return(response);
}
public String InsertBouquetRecipe(String nombre_formula, Int32 id_version_bouquet, String especificacion, String construccion, String cadena_formula, Int32 opcion_menu, Int32 unidades, Decimal precio, Int32 id_comida, Int32 id_detalle_version_bouquet, Int32 id_formato_upc)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.InsertarFormula(nombre_formula, 50, id_version_bouquet, especificacion, construccion, cadena_formula, opcion_menu, unidades, precio, id_comida, id_detalle_version_bouquet, id_formato_upc);
var query = new BLL_Bouquets().GenericBuilder(ds.Tables[0]);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
public String ReadTablaSticker(Int32 id_detalle_version_bouquet)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.ConsultargvSticker(id_detalle_version_bouquet);
var query = new BLL_Bouquets().BuildSticker(ds.Tables[0]);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
public String ReadDetailFormulaOP3(Int32 id_detalle_version_bouquet)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.ConsultarDetalleFormula_3(id_detalle_version_bouquet);
var query = new BLL_Bouquets().BuildDetailFormulaOP3(ds.Tables[0]);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
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 RemoveRecipe(Int32 id_detalle_version_bouquet)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.EliminarReceta(id_detalle_version_bouquet);
var query = new BLL_Bouquets().BuildGenericResponse("_removed");
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
public String InsertObservation(List <BEL_BouquetRecipe> liRecipes, Int32 id_formula_bouquet, Int32 id_detalle_version_bouquet)
{
BDBouquets dbQuery = new BDBouquets();
foreach (var recipe in liRecipes)
{
DataSet ds = dbQuery.InsertarObservacion(recipe.id_variedad_flor_cultivo, recipe.id_grado_flor_cultivo, recipe.cantidad_tallos, id_formula_bouquet, recipe.observacion, recipe.id_variedad_flor_cultivo_sustitucion, recipe.id_grado_flor_cultivo_sustitucion, id_detalle_version_bouquet);
}
return("[]");
}
public String InsertUPC(Int32 id_detalle_version_bouquet, List <BEL_UPC> upc)
{
BDBouquets dbQuery = new BDBouquets();
foreach (var item in upc)
{
DataSet ds = dbQuery.ActualizarUPC(id_detalle_version_bouquet, item.descripcion_upc, Convert.ToInt16(item.orden_upc), item.nombre_informacion_upc);
}
return("[]");
}
public String ReadSearchBouquet(String texto, String columnas)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.ConsultarTodoFlor();
DataTable dt = ds.Tables[0].Clone();
ds.Tables[0].Select(String.Format("{0} LIKE '%{1}%'", columnas, texto)).Take(100).CopyToDataTable(dt, LoadOption.Upsert);
var query = new BLL_Bouquets().BuildSearchBouquet(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));
}
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 ReadFlowerGrade(Int32 id_tipo_flor_cultivo, String nombre_grado_flor)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.BouquetConsulatarFlor("consultar_grado_flor", id_tipo_flor_cultivo);
DataTable dt = ds.Tables[0].Clone();
ds.Tables[0].Select(String.Format("disponible_comercializadora = True AND nombre_grado_flor LIKE '%{0}%'", nombre_grado_flor)).CopyToDataTable(dt, LoadOption.Upsert);
var query = new BLL_Bouquets().BuildFlowerGrade(dt);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
public String ReadFormatoUPC(String nombre_formato)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.ConsultarFormatoUpc();
DataTable dt = ds.Tables[0].Clone();
ds.Tables[0].Select(String.Format("nombre_formato LIKE '%{0}%'", nombre_formato)).Take(100).CopyToDataTable(dt, LoadOption.Upsert);
var query = new BLL_Bouquets().BuildFormatoUPC(dt);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
public String InsertSticker(String id_sticker, Int32 id_detalle_version_bouquet)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = new DataSet();
foreach (var id_sticker_s in id_sticker.Split(','))
{
ds = dbQuery.InsertarSticker(id_detalle_version_bouquet, Convert.ToInt32(id_sticker_s));
}
var query = new BLL_Bouquets().BuildGenericResponse(ds.Tables[0]);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
public String InsertSleeve(String id_capuchon_cultivo, Int32 id_detalle_version_bouquet)
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = new DataSet();
foreach (var id_capuchon in id_capuchon_cultivo.Split(','))
{
ds = dbQuery.InsertarSleeve(Convert.ToInt32(id_capuchon), id_detalle_version_bouquet);
}
var query = new BLL_Bouquets().BuildGenericResponse(ds.Tables[0]);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
public String ReadDetailBouquetSelected(Int32 id_detalle_version_bouquet)
{
List <Object> liBouquet = new List <object>();
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.ConsultarFormula(id_detalle_version_bouquet);
var query = new BLL_Bouquets().BuildBouquetSelected(ds.Tables[0]);
liBouquet.Add(query);
DataTable dt = ds.Tables[1];
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
var queryDetail = new BLL_Bouquets().BuildDetailBouquetSelected(dt);
liBouquet.Add(queryDetail);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(liBouquet));
}
public String ReadBouquetRecipe(Int32 id_detalle_version_bouquet, Boolean getModel, Boolean emptyRow)
{
if (getModel)
{
return(new JavaScriptSerializer().Serialize(new BEL_BouquetRecipe()));
}
else
{
BDBouquets dbQuery = new BDBouquets();
DataSet ds = dbQuery.ConsultarFormula(id_detalle_version_bouquet);
DataTable dt = ds.Tables[1];
if (emptyRow)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
var query = new BLL_Bouquets().BuildBouquetRecipe(dt);
dbQuery.Cerrar();
return(new JavaScriptSerializer().Serialize(query));
}
}
