private void EmphasizeCurrentSearch(RecipeDisplayEnum currentDisplay)
{
ReciepesSearchControl1.EmphasizeCurrentSearch(currentDisplay);
//this.lnkAllRecipes.Style["background-color"] = "Transparent";
//this.lnkMyRecipes.Style["background-color"] = "Transparent";
//this.lnkFavRecipes.Style["background-color"] = "Transparent";
//this.lnkSearch.Style["background-color"] = "Transparent";
//this.lnkAdvancedSearch.Style["background-color"] = "Transparent";
//this.lnkCategories.Style["background-color"] = "Transparent";
//switch (currentDisplay)
//{
// case RecipeDisplayEnum.All:
// this.lnkAllRecipes.Style["background-color"] = "#A4CB3A";
// break;
// case RecipeDisplayEnum.MyRecipes:
// this.lnkMyRecipes.Style["background-color"] = "#A4CB3A";
// break;
// case RecipeDisplayEnum.MyFavoriteRecipes:
// this.lnkFavRecipes.Style["background-color"] = "#A4CB3A";
// break;
// case RecipeDisplayEnum.BySearchSimple:
// this.lnkSearch.Style["background-color"] = "#A4CB3A";
// break;
// case RecipeDisplayEnum.BySearchAdvanced:
// this.lnkAdvancedSearch.Style["background-color"] = "#A4CB3A";
// break;
// case RecipeDisplayEnum.ByCategory:
// this.lnkCategories.Style["background-color"] = "#A4CB3A";
// break;
//}
}
private void EmphasizeCurrentSearch(RecipeDisplayEnum currentDisplay)
{
MenusSearchControl1.EmphasizeCurrentSearch(currentDisplay);
//this.lnkAllMenus.Style["text-decoration"] = "none";
//this.lnkMyMenus.Style["text-decoration"] = "none";
//this.lnkFavMenus.Style["text-decoration"] = "none";
//this.lnkAllMenus.Style["background-color"] = "Transparent";
//this.lnkMyMenus.Style["background-color"] = "Transparent";
//this.lnkFavMenus.Style["background-color"] = "Transparent";
//this.lnkSearch.Style["background-color"] = "Transparent";
//this.lnkAdvancedSearch.Style["background-color"] = "Transparent";
//this.lnkCategories.Style["background-color"] = "Transparent";
switch (currentDisplay)
{
case RecipeDisplayEnum.All:
//this.lnkAllMenus.Style["background-color"] = "#FBAB14";
//this.lnkAllMenus.Style["text-decoration"] = "underline";
break;
case RecipeDisplayEnum.MyRecipes:
//this.lnkMyMenus.Style["background-color"] = "#FBAB14";
//this.lnkMyMenus.Style["text-decoration"] = "underline";
break;
case RecipeDisplayEnum.MyFavoriteRecipes:
//this.lnkFavMenus.Style["background-color"] = "#FBAB14";
//this.lnkFavMenus.Style["text-decoration"] = "underline";
break;
//case RecipeDisplayEnum.BySearchSimple:
// this.lnkSearch.Style["background-color"] = "#FBAB14";
// break;
//case RecipeDisplayEnum.BySearchAdvanced:
// this.lnkAdvancedSearch.Style["background-color"] = "#FBAB14";
// break;
//case RecipeDisplayEnum.ByCategory:
// this.lnkCategories.Style["background-color"] = "#FBAB14";
// break;
}
}
public void EmphasizeCurrentSearch(RecipeDisplayEnum currentDisplay)
{
this.lnkAllMenus.Style["text-decoration"] = "none";
this.lnkMyMenus.Style["text-decoration"] = "none";
this.lnkFavMenus.Style["text-decoration"] = "none";
switch (currentDisplay)
{
case RecipeDisplayEnum.All:
this.lnkAllMenus.Style["text-decoration"] = "underline";
break;
case RecipeDisplayEnum.MyRecipes:
this.lnkMyMenus.Style["text-decoration"] = "underline";
break;
case RecipeDisplayEnum.MyFavoriteRecipes:
this.lnkFavMenus.Style["text-decoration"] = "underline";
break;
}
}
public IEnumerable <Menu> GetMenusEx(RecipeDisplayEnum display, int userId, string freeText, int?categoryId, int?diners, int[] menuCats, RecipeOrderEnum orderBy, int page, int pageSize, out int totalPages, out int numMenus)
{
return(new MenusDA().GetMenusEx(display, userId, freeText, categoryId, diners, menuCats, orderBy, page, pageSize, out totalPages, out numMenus));
}
public IEnumerable <Recipe> GetRecipesEx(RecipeDisplayEnum display, int userId, string freeText, int?categoryId, int?servings, int[] recipeCats, RecipeOrderEnum orderBy, int page, int pageSize, out int totalPages, out int numRecipes)
{
return(new RecipesDA().GetRecipesEx(display, userId, freeText, categoryId, servings, recipeCats, orderBy, page, pageSize, out totalPages, out numRecipes));
}
internal List <Recipe> GetRecipesEx(RecipeDisplayEnum display, int userId, string freeText, int?categoryId, int?servings, int[] recipeCats, RecipeOrderEnum orderBy, int page, int pageSize, out int totalPages, out int numRecipes)
{
using (MyBuyListDBContext context = new MyBuyListDBContext(DBUtils.GetConnection()))
{
try
{
List <Recipe> recipesList = null;
switch (display)
{
case RecipeDisplayEnum.All:
recipesList = GetAllRecipes(userId).ToList();
break;
case RecipeDisplayEnum.MyRecipes:
if (!string.IsNullOrEmpty(freeText))
{
recipesList = GetUserRecipesList(userId).Where(r => r.RecipeName.Contains(freeText)).ToList();
}
else
{
recipesList = GetUserRecipesList(userId).ToList();
}
break;
case RecipeDisplayEnum.MyFavoriteRecipes:
if (!string.IsNullOrEmpty(freeText))
{
recipesList = GetUserFavoritesRecipes(userId).Where(r => r.RecipeName.Contains(freeText)).ToList();
}
else
{
recipesList = GetUserFavoritesRecipes(userId).ToList();
}
break;
case RecipeDisplayEnum.ByCategory:
if (categoryId.HasValue)
{
recipesList = this.GetRecipesByCategory(categoryId.Value, userId).ToList();
}
else
{
recipesList = this.GetAllRecipes(userId).ToList();
}
break;
case RecipeDisplayEnum.BySearchSimple:
recipesList = GetRecipesListByFreeText(freeText).ToList();
break;
case RecipeDisplayEnum.BySearchAdvanced:
recipesList = this.GetRecipesListByComplexSearch(freeText, servings, recipeCats, userId).ToList();
break;
}
var count = (from r in recipesList
select r).Count();
numRecipes = count;
totalPages = count / pageSize + (count % pageSize > 0 ? 1 : 0);
var list = from r in recipesList
select r;
switch (orderBy)
{
case RecipeOrderEnum.Name:
list = list.OrderBy(r => r.RecipeName);
break;
case RecipeOrderEnum.Publisher:
list = list.OrderBy(r => r.User.DisplayName);
break;
case RecipeOrderEnum.LastUpdate:
list = list.OrderByDescending(r => r.ModifiedDate);
break;
}
// paging
var list2 = list.Skip((page - 1) * pageSize).Take(pageSize);
return(list2.ToList());
}
catch
{
totalPages = 0;
numRecipes = 0;
return(null);
}
}
}
internal IEnumerable <Menu> GetMenusEx(RecipeDisplayEnum display, int userId, string freeText, int?categoryId, int?diners, int[] menuCats, RecipeOrderEnum orderBy, int page, int pageSize, out int totalPages, out int numMenus)
{
return(DataFacade.Instance.GetMenusEx(display, userId, freeText, categoryId, diners, menuCats, orderBy, page, pageSize, out totalPages, out numMenus));
}
internal IEnumerable <Recipe> GetRecipesEx(RecipeDisplayEnum display, int userId, string freeText, int?categoryId, int?servings, int[] recipeCats, RecipeOrderEnum orderBy, int page, int pageSize, out int totalPages, out int numRecipes)
{
return(DataFacade.Instance.GetRecipesEx(display, userId, freeText, categoryId, servings, recipeCats, orderBy, page, pageSize, out totalPages, out numRecipes));
}
