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");
}
public DataTable updateIngSuppOnly(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_supp1", DbType.String, BO.supp1);
oDAL.addParameter("_supp2", DbType.String, BO.supp2);
return(oDAL.getDataTable(" updateIngSuppOnly"));
}
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 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 checkIng(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_id", DbType.String, BO.ingid);
oDAL.addParameter("_ing", DbType.String, BO.ing);
return(oDAL.getDataTable(" checkIng"));
}
public void updateSupplier(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_supp1", DbType.String, BO.supp1);
oDAL.addParameter("_old", DbType.String, BO.old);
oDAL.executeQuery(" updateSupplier");
}
public DataTable delSupp(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_supp1", DbType.String, BO.supp1);
oDAL.addParameter("_new", DbType.String, BO.supp2);
return(oDAL.getDataTable(" deleteSupp"));
}
public DataTable checkRecipe(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.addParameter("_recdesc", DbType.String, BO.recipe);
return(oDAL.getDataTable(" checkRecipe"));
}
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 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 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 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 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 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 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 DataTable getCateringDishDynamic(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catid", DbType.String, BO.catID);
oDAL.addParameter("_cat", DbType.String, BO.category);
oDAL.addParameter("_guestTarget", DbType.String, BO.guestTarget);
return(oDAL.getDataTable(" getCateringDishDynamic"));
}
public DataTable showReport(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_dateF", DbType.String, BO.dateF);
oDAL.addParameter("_dateT", DbType.String, BO.dateT);
oDAL.addParameter("_statu", DbType.String, BO.Status);
return(oDAL.getDataTable(" showReport"));
}
public DataTable getCatDetailByPeriod(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_statu", DbType.String, BO.Status);
oDAL.addParameter("_dateF", DbType.String, BO.dateF);
oDAL.addParameter("_dateT", DbType.String, BO.dateT);
return(oDAL.getDataTable(" getCatDetailByPeriod"));
}
public void UpdateSupplierBudget(SupplierBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_amount", DbType.String, BO.amount);
oDAL.addParameter("_supp", DbType.String, BO.supp1);
oDAL.addParameter("_catid", DbType.String, BO.catid);
oDAL.getDataTable(" UpdateSupplierBudget");
}
public void addRecipeIng(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recipeid", DbType.String, BO.recipeid);
oDAL.addParameter("_ingID", DbType.String, BO.ingid);
oDAL.addParameter("_meas", DbType.String, BO.meas);
oDAL.executeQuery(" addRecipeIng");
}
public void removeDish(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catid", DbType.String, BO.catID);
oDAL.addParameter("_recipeID", DbType.String, BO.recipeid);
oDAL.addParameter("_pax", DbType.String, BO.pax);
oDAL.addParameter("_guest", DbType.String, BO.guest);
oDAL.executeQuery("removeDish");
}
public DataTable getRecipeNameAndFormulaAndPrice(CateringBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_catid", DbType.String, BO.catID);
oDAL.addParameter("_cat", DbType.String, BO.category);
oDAL.addParameter("_guest", DbType.String, BO.guest);
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
return(oDAL.getDataTable(" getRecipeNameAndFormulaAndPrice"));
}
public DataTable searchIng(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_supp1", DbType.String, BO.supp1);
oDAL.addParameter("_supp2", DbType.String, BO.supp2);
oDAL.addParameter("_supp3", DbType.String, BO.supp3);
oDAL.addParameter("_ing", DbType.String, BO.ing);
return(oDAL.getDataTable(" searchIng"));
}
public void addIng(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ingDesc", DbType.String, BO.ing);
oDAL.addParameter("_meas", DbType.String, BO.measurement);
oDAL.addParameter("_sup", DbType.String, BO.sup);
oDAL.addParameter("_price", DbType.String, BO.price);
oDAL.executeQuery(" adding");
}
public DataTable searchIngredientReturnPrice(IngredientBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ing", DbType.String, BO.ing);
return(oDAL.getDataTable(" searchIngredientReturnPrice"));
}
public DataTable getRecipeNameAndFormulaAndPriceByDish(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
return(oDAL.getDataTable(" getRecipeNameAndFormulaAndPriceByDish"));
}
public void deleteAllRecIng(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.executeQuery(" deleteAllRecIng");
}
public DataTable getIngByRecIdOrig(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
return(oDAL.getDataTable(" getIngByRecIdOrig"));
}
public DataTable searchIngByID(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_ing", DbType.String, BO.ingid);
return(oDAL.getDataTable(" searchIngByID"));
}
public void makeRecipeAvail(RecipeBO BO)
{
oDAL = new DataAccessLayer();
oDAL.clearParameter();
oDAL.addParameter("_recid", DbType.String, BO.recipeid);
oDAL.executeQuery(" makeRecipeAvail");
}