public void CreateMenuDetail(AdaptiveCardDataFactory dataFactory, Guid MenuId)
{
var Data = JObject.FromObject(dataFactory.Request.Data);
var name = Data.Properties().Where(x => x.Name.Contains("name")).ToList();
var price = Data.Properties().Where(x => x.Name.Contains("price")).ToList();
for (int i = 0; i < name.Count(); i++)
{
if (name[i].Value.ToString().Equals("") || price[i].Value.ToString().Equals("0"))
{
break;
}
else
{
var menuDetail = new MenuDetail()
{
MenuDetailId = Guid.NewGuid(),
ProductName = name[i].Value.ToString(),
Amount = decimal.Parse(price[i].Value.ToString()),
MenuId = MenuId
};
context.MenuDetail.Add(menuDetail);
context.SaveChanges();
}
}
;
}
private void Traverse(MenuItem menu, StringBuilder menuHtml, int level, int index, MenuDetail detail)
{
var menuDetail = new MenuDetail
{
MenuItem = menu,
Level = level,
HasChild = menu.SubMenuItems != null &&
menu.SubMenuItems.Count > 0,
IsHome = IsHome(level),
IsImmediateChildofHome = IsHomeImmediateChild(level),
Index = index,
Parent = detail
};
menuDetail.IsCurrentPage = IsCurrentPage(menuDetail);
menuHtml.Append(ItemStartHtml(menuDetail));
menuHtml.Append(GetItemHtml(menuDetail));
if (menuDetail.HasChild)
{
menuHtml.Append(LevelStartHtml(menuDetail));
var itemNumber = 0;
foreach (var subMenuItem in menuDetail.MenuItem.SubMenuItems)
{
itemNumber++;
Traverse(subMenuItem, menuHtml, level + 1, itemNumber, menuDetail);
}
menuHtml.Append(LevelEndHtml(menuDetail));
}
menuHtml.Append(ItemEndHtml(menuDetail));
}
public void DeleteMenuDetail(MenuDetail MenuDetail)
{
int status;
databaseContext.MenuDetail.Remove(MenuDetail);
databaseContext.SaveChangesAsync();
}
public static MenuDetailDto ToViewModel(this MenuDetail entity)
{
return(entity == null ? null : new MenuDetailDto
{
Id = entity.Id,
MenuId = entity.MenuId,
MainMenuId = entity.Menu != null ? entity.Menu.MainMenuId : 0,
MainMenuName = entity.Menu?.MainMenu?.Name,
MenuName = entity.Menu?.Name,
Name = entity.Name,
Description = entity.Description,
Ingredients = entity.Ingredients,
Receipe = entity.Receipe,
Discount = entity.Discount,
IsSpecial = entity.IsSpecial,
IsVeg = entity.IsVeg,
Quantity = entity.Quantity,
Rate = entity.Rate,
ServePeoples = entity.ServePeoples,
Guid = entity.Guid,
IsActive = entity.IsActive,
ImagePath = entity.ImagePath,
ImageDetails = (from imagedetails in entity?.ImageDetails
select new MenuImageDetailDto
{
ImageDesc = imagedetails?.ImageDesc,
ImagePath = imagedetails?.ImagePath,
MenuDetailId = imagedetails.Id
}).ToList()
});
}
internal List <MenuDetail> getRecipe(string menuName, List <MenuDetail> menuDetailList)
{
string procedure = "SelectByRecipesJoinToInventryTypeNSalesMenu"; // 저장 프로시져 이름
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("menuName", menuName);
try
{
SqlDataReader sdr = new DBConnection().Select(procedure, parameters);
while (sdr.Read())
{
MenuDetail menuDetail = new MenuDetail();
menuDetail.RecipeCode = sdr["recipeNo"].ToString();
menuDetail.Amount = int.Parse(sdr["ingredientAmount"].ToString());
menuDetail.MenuCode = sdr["menuCode"].ToString();
menuDetail.InventoryTypeCode = sdr["inventoryTypeCode"].ToString();
menuDetail.Compulsory = bool.Parse(sdr["necessary"].ToString());
menuDetail.InventoryName = sdr["InventoryName"].ToString();
menuDetail.Division = sdr["MaterialClassification"].ToString();
menuDetail.MenuName = sdr["menuName"].ToString();
menuDetail.DiscountRatio = float.Parse(sdr["discountRatio"].ToString());
menuDetailList.Add(menuDetail);
}
}
catch (SqlException)
{
throw;
}
return(menuDetailList);
}
public ActionResult DeleteConfirmed(int id)
{
MenuDetail menuDetail = db.MenuDetails.Find(id);
db.MenuDetails.Remove(menuDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 显示商品详情商品详情
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public MenuDetail GetMenuDetail(int menuid)
{
string sql = $@"select * from [dbo].[MenuInfo] as m where m.Id=" + menuid;
List <MenuDetail> infos = OrmDBHelper.GetToList <MenuDetail>(sql);
MenuDetail menu = infos.FirstOrDefault();
return(menu);
}
public void AddMenuDetail(MenuDetail menuDetail)
{
using (var db = new FoodContext())
{
db.MenuDetails.Add(menuDetail);
db.SaveChanges();
}
}
public MenuDetail getMenuDetail(String foodID)
{
SqlConnection conn = new SqlConnection(DataHelper.GetConnectionString());
DataSet ds = new DataSet();
MenuDetail res = new MenuDetail();
conn.Open();
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("select menu.menu_id,LV1.category_lv1_id,LV1.category_lv1_name");
sqlstr.Append(",LV2.category_lv2_id,LV2.category_lv2_name");
sqlstr.Append(",menu.restaurant_id,menu.menu_category_lv1,menu.menu_category_lv2");
sqlstr.Append(",menu.menu_name,menu.menu_description,menu.menu_price");
sqlstr.Append(",menu.menu_price_S,menu.menu_price_M,menu.menu_price_L");
sqlstr.Append(",menu.menu_picture,menu.menu_flag_recommend,menu.menu_activate,menu.menu_remark");
sqlstr.Append(" from tb_Menu as menu");
sqlstr.Append(" inner join tb_Category_LV1 as [LV1] on LV1.category_lv1_id = menu.menu_category_lv1");
sqlstr.Append(" inner join tb_Category_LV2 as [LV2] on LV2.category_lv2_id = menu.menu_category_lv2");
sqlstr.Append(" where menu.menu_id = " + foodID);
SqlDataAdapter adp = new SqlDataAdapter(sqlstr.ToString(), conn);
adp.SelectCommand.CommandType = CommandType.Text;
adp.Fill(ds);
DataTable dt = new DataTable();
//eMenuFood res = new eMenuFood();
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
MODEL.MenuDetail resMenu = new MODEL.MenuDetail();
resMenu.MenuCategoryLV1ID = dt.Rows[0]["menu_category_lv1"].ToString();
resMenu.MenuCategoryLV2ID = dt.Rows[0]["menu_category_lv2"].ToString();
resMenu.restaurantID = dt.Rows[0]["restaurant_id"].ToString();
resMenu.MenuName = dt.Rows[0]["menu_name"].ToString();
resMenu.MenuDescription = dt.Rows[0]["menu_description"].ToString();
resMenu.MenuPicture = dt.Rows[0]["menu_picture"].ToString();
resMenu.MenuPrice = dt.Rows[0]["menu_price"].ToString();
resMenu.MenuPriceS = dt.Rows[0]["menu_price_S"].ToString();
resMenu.MenuPriceM = dt.Rows[0]["menu_price_M"].ToString();
resMenu.MenuPriceL = dt.Rows[0]["menu_price_L"].ToString();
resMenu.MenuRemark = dt.Rows[0]["menu_remark"].ToString();
resMenu.MenuActivate = dt.Rows[0]["menu_activate"].ToString();
resMenu.MenuRecommend = dt.Rows[0]["menu_flag_recommend"].ToString();
return(resMenu);
}
else
{
return(null);
}
}
public override string LevelEndHtml(MenuDetail menuDetail)
{
if (!menuDetail.IsHome)
{
return("</ul>");
}
return(string.Empty);
}
public void RemoveMenuDetail(MenuDetail menuDetail)
{
using (var db = new FoodContext())
{
var menuDetailToRemove = db.MenuDetails.FirstOrDefault(m => m.Id == menuDetail.Id);
db.MenuDetails.Remove(menuDetailToRemove);
db.SaveChanges();
}
}
public virtual string ItemStartHtml(MenuDetail menuDetail)
{
if (!menuDetail.IsHome)
{
return(string.Format("<li class=\"push-menu-level{0}\">", menuDetail.Level.ToString(CultureInfo.CurrentCulture)));
}
return(string.Empty);
}
public void EditMenuDetail(MenuDetail menuDetail)
{
using (var db = new FoodContext())
{
db.MenuDetails.Attach(menuDetail);
db.Entry(menuDetail).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public override string LevelStartHtml(MenuDetail menuDetail)
{
if (!menuDetail.IsHome)
{
return(string.Format("<ul class=\"{0}ma5-ul{1}\">", menuDetail.IsCurrentPage ? "ma5-active-ul " : "", GetClassSuffix(menuDetail)));
}
return(string.Empty);
}
public virtual string LevelStartHtml(MenuDetail menuDetail)
{
if (!menuDetail.IsHome)
{
return("<ul>");
}
return(string.Empty);
}
public override string ItemEndHtml(MenuDetail menuDetail)
{
if (!menuDetail.IsHome)
{
return("</li>");
}
return(string.Empty);
}
public ActionResult Edit([Bind(Include = "Id,MenuId,FoodId")] MenuDetail menuDetail)
{
if (ModelState.IsValid)
{
db.Entry(menuDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FoodId = new SelectList(db.Foods, "Id", "Name", menuDetail.FoodId);
ViewBag.MenuId = new SelectList(db.Menus, "Id", "Name", menuDetail.MenuId);
return(View(menuDetail));
}
public void AddOrEditMenuDetail(MenuDetail menuDetail)
{
var menuDetailRepo = new MenuDetailRepo();
var detail = menuDetailRepo.GetMenuDetailById(menuDetail.Id);
if (detail == null)
{
menuDetailRepo.AddMenuDetail(menuDetail);
}
else
{
menuDetailRepo.EditMenuDetail(menuDetail);
}
}
// GET: MenuDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuDetail menuDetail = db.MenuDetails.Find(id);
if (menuDetail == null)
{
return(HttpNotFound());
}
return(View(menuDetail));
}
public override string ItemStartHtml(MenuDetail menuDetail)
{
if (!menuDetail.IsHome)
{
var result = new StringBuilder();
result.Append(string.Format("<li class=\"ma5-li{0}\">", GetClassSuffix(menuDetail)));
if (menuDetail.Index == 1 && !menuDetail.IsHome && !menuDetail.IsImmediateChildofHome)
{
result.Append("<div class=\"ma5-leave-bar\"><span class=\"ma5-btn-leave\"><i aria-hidden=\"true\" class=\"fa fa-arrow-left menu-arrow\"></i></span>Back</div>");
}
return(result.ToString());
}
return(string.Empty);
}
public void CreateMenuDetail(ModifyGroup SelectObject)
{
foreach (var lists in SelectObject.AllModifyMultiple)
{
var detail = new MenuDetail
{
MenuDetailId = Guid.NewGuid(),
ProductName = lists.ProductName,
Amount = decimal.Parse(lists.Amount),
MenuId = Guid.Parse(lists.MenuId)
};
context.MenuDetail.Add(detail);
}
context.SaveChanges();
}
public IActionResult Upsert(int?id)
{
MenuDetail = new MenuDetail();
if (id == null || id == 0)
{
return(View(MenuDetail));
}
MenuDetail = _MenuDetailService.FindMenuDetail(id);
if (MenuDetail == null)
{
return(NotFound());
}
return(View(MenuDetail));
//return View("Upsert");
}
private static string GetClassSuffix(MenuDetail menuDetail)
{
var level = string.Empty;
if (menuDetail != null && menuDetail.Parent != null && !menuDetail.IsHome)
{
var md = menuDetail;
do
{
level = "-" + md.Index.ToString(CultureInfo.InvariantCulture) + level;
md = md.Parent;
} while (md != null && md.Parent != null && !md.IsHome);
}
return(level);
}
// [ValidateAntiForgeryToken]
public IActionResult Delete(int id)
{
MenuDetail = new MenuDetail();
MenuDetail = _MenuDetailService.FindMenuDetail(id);
if (MenuDetail == null)
{
return(RedirectToAction("ListMenuDetail"));
// return Json(new { success = false, message = "Error while Deleting" });
}
else
{
_MenuDetailService.DeleteMenuDetail(MenuDetail);
return(RedirectToAction("ListMenuDetail"));
// return Json(new { success = true, message = "Delete Successful" });
}
}
// GET: MenuDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuDetail menuDetail = db.MenuDetails.Find(id);
if (menuDetail == null)
{
return(HttpNotFound());
}
ViewBag.FoodId = new SelectList(db.Foods, "Id", "Name", menuDetail.FoodId);
ViewBag.MenuId = new SelectList(db.Menus, "Id", "Name", menuDetail.MenuId);
return(View(menuDetail));
}
private bool IsCurrentPage(MenuDetail menuDetail)
{
var id = Context.Item.ID.ToString();
if (menuDetail.MenuItem.Id.Equals(id) && menuDetail.HasChild)
{
return(true);
}
if (menuDetail.MenuItem.SubMenuItems != null)
{
var submenu = menuDetail.MenuItem.SubMenuItems.FirstOrDefault(i => i.Id.Equals(id));
return(submenu != null && (submenu.SubMenuItems == null || submenu.SubMenuItems.Count <= 0));
}
return(false);
}
public virtual string GetItemHtml(MenuDetail menuDetail)
{
var stringBuilder = new StringBuilder();
var iconHtml = string.Format("<i class=\"fa fa-tags {0}\"></i>", menuDetail.MenuItem.CssClass);
if (!menuDetail.IsHome)
{
stringBuilder.Append(string.Format("<a href=\"{0}\">{1}{2}</a>", menuDetail.MenuItem.Url, iconHtml, menuDetail.MenuItem.GetText()));
}
if (menuDetail.HasChild)
{
stringBuilder.Append(string.Format("<h2 {2}>{0}{1}</h2>", iconHtml, menuDetail.MenuItem.GetText(), menuDetail.IsCurrentPage ? "class=\"init-menu\"" : ""));
}
return(stringBuilder.ToString());
}
public IActionResult Add([FromBody] CreateMenuDetailViewModel model, int menuID)
{
DataClaim.GetClaim(Request);
if (model is null)
{
return(BadRequest("Menu is null"));
}
if (!ModelState.IsValid)
{
return(BadRequest());
}
var newMenuDetail = new MenuDetail();
newMenuDetail.MenuId = menuID;
_mapper.Map(model, newMenuDetail);
_menuDetailProvider.Add(newMenuDetail);
return(Ok(newMenuDetail));
}
public override string GetItemHtml(MenuDetail menuDetail)
{
var stringBuilder = new StringBuilder();
if (!menuDetail.IsHome)
{
stringBuilder.Append(string.Format("<a class=\"ma5-path-to-active\" href=\"{0}\">{1}</a>",
menuDetail.MenuItem.Url,
menuDetail.MenuItem.GetText()));
if (menuDetail.HasChild)
{
stringBuilder.Append(
"<span class=\"ma5-btn-enter\"><i aria-hidden=\"true\" class=\"fa fa-arrow-right menu-arrow\"></i></span>");
}
}
return(stringBuilder.ToString());
}
public override string GetItemHtml(MenuDetail menuDetail)
{
var stringBuilder = new StringBuilder();
if (!menuDetail.IsHome)
{
stringBuilder.Append(string.Format("<a class=\"ma5-path-to-active{0}\" href=\"{1}\">{2}</a>",
menuDetail.HasChild ? " ma5-has-submenu" : string.Empty,
menuDetail.MenuItem.Url,
menuDetail.MenuItem.GetText()));
if (menuDetail.HasChild)
{
stringBuilder.Append(
"<span class=\"ma5-btn-enter\"><span class=\"glyphicon glyphicon-menu-right\" aria-hidden=\"true\"></span></span>");
}
}
return(stringBuilder.ToString());
}
