public void deleteing(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ingid", DbType.String, BO.ingid);
oDAL.executeQuery(" deleteing");
}
public DataTable addSupp(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_supplier", DbType.String, BO.supp1);
return(oDAL.getDataTable(" addSupplier"));
}
public DataTable getSupplierBudget(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catID", DbType.String, BO.catid);
return(oDAL.getDataTable("getSupplierBudget"));
}
public DataTable getRecipeNameAndFormulaAndPriceByDish(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
return(oDAL.getDataTable(" getRecipeNameAndFormulaAndPriceByDish"));
}
public void deleteSupplierBudget(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catid", DbType.String, BO.catid);
oDAL.getDataTable(" deleteSupplierBudget");
}
public DataTable getAllrecipeWithIng(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ingid", DbType.String, BO.ingid);
return(oDAL.getDataTable(" getAllrecipeWithIng"));
}
public DataTable showReportByEvent(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_events", DbType.String, BO.catID);
return(oDAL.getDataTable(" showReportByEvent"));
}
public void updateAllActiveEvent(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_date", DbType.String, BO.DateOfEvent);
oDAL.executeQuery(" updateAllActiveEvent");
}
public DataTable getIngByRecIdOrig(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
return(oDAL.getDataTable(" getIngByRecIdOrig"));
}
public DataTable checkEventIfDone(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_date", DbType.String, BO.DateOfEvent);
return(oDAL.getDataTable("checkEventIfDone"));
}
public DataTable searchIngredientReturnPrice(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ing", DbType.String, BO.ing);
return(oDAL.getDataTable(" searchIngredientReturnPrice"));
}
public DataTable searchIngByID(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ing", DbType.String, BO.ingid);
return(oDAL.getDataTable(" searchIngByID"));
}
public void deleteAllRecIng(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.executeQuery(" deleteAllRecIng");
}
public void makeRecipeAvail(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.executeQuery(" makeRecipeAvail");
}
public DataTable checkRecipeName(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recipe", DbType.String, BO.recipe);
return(oDAL.getDataTable(" checkRecipeName"));
}
public void removeDishes(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catid", DbType.String, BO.catID);
oDAL.executeQuery("removeDishes");
}
public DataTable checkIngByDesc(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ing", DbType.String, BO.ing);
return(oDAL.getDataTable(" checkIngByDesc"));
}
public DataTable getSuppPrices(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
return(oDAL.getDataTable("getSuppPrices"));
}
public DataTable getCatDetail(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catid", DbType.String, BO.catID);
return(oDAL.getDataTable("getCatDetail"));
}
public DataTable getCateringDishWithoutPrice(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catid", DbType.String, BO.catID);
oDAL.addParameter("_cat", DbType.String, BO.category);
return(oDAL.getDataTable(" getCateringDishWithoutPrice"));
}
public void removeNewlyAddedIngToRecipe(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.addParameter("_ingid", DbType.String, BO.ingid);
oDAL.executeQuery(" removeNewlyAddedIngToRecipe");
}
public void removeRecipeIng(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.addParameter("_ingdesc", DbType.String, BO.ingdesc);
oDAL.executeQuery(" removeRecipeIng");
}
public DataTable checkRecipeIng(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.addParameter("_ingid", DbType.String, BO.ingid);
return(oDAL.getDataTable(" checkRecipeIng"));
}
public void addRecipe(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recdesc", DbType.String, BO.recipe);
oDAL.addParameter("_category", DbType.String, BO.cat);
oDAL.executeQuery(" addRecipe");
}
public DataTable ChangeRecipeInuse(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_status", DbType.String, BO.status);
oDAL.addParameter("_recID", DbType.String, BO.recipeid);
return(oDAL.getDataTable(" ChangeRecipeInuse"));
}
public DataTable searchCatOrder(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_date", DbType.String, BO.DateOfEvent);
oDAL.addParameter("_stat", DbType.String, BO.Status);
return(oDAL.getDataTable("searchCatOrder"));
}
public void ChangeEventInuse(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_inuse", DbType.String, BO.inuse);
oDAL.addParameter("_catid", DbType.String, BO.catID);
oDAL.executeQuery("ChangeEventInuse");
}
public void updateStatusCat(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_stat", DbType.String, BO.Status);
oDAL.addParameter("_catid", DbType.String, BO.catID);
oDAL.executeQuery(" updateStatusCat");
}
public DataTable searchRecipeSingle(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recipe", DbType.String, BO.recipe);
oDAL.addParameter("_cat", DbType.String, BO.cat);
return(oDAL.getDataTable(" searchRecipeSingle"));
}
public void updatePrioritySupplier(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_prior", DbType.Int32, BO.prior);
oDAL.addParameter("_supp", DbType.String, BO.supp1);
oDAL.getDataTable(" updatePrioritySupplier");
}
