private static async Task ProcessMessageAsync(Message msg, CancellationToken token)
{
string data = Encoding.UTF8.GetString(msg.Body);
msgList.Add(data);
await subscriptionClient.CompleteAsync(msg.SystemProperties.LockToken);
if (msgList.Count == 4)
{
stockInfo = _searchRepository.ItemInStock(int.Parse(msgList[0]), int.Parse(msgList[1]));
if (stockInfo.quantity >= Int16.Parse(msgList[3]))
{
ItemValue = "ItemInStock";
}
else if (stockInfo.quantity < Int16.Parse(msgList[3]))
{
ItemValue = "ItemOutOfStock";
}
msg = new Message(Encoding.UTF8.GetBytes(ItemValue));
await topicClient.SendAsync(msg);
msgList = new List <string>();
}
}
public TblMenu ItemInStock(int restaurantID, int menuID)
{
try
{
TblMenu menuObj = new TblMenu();
if (db != null)
{
// menuObj = (from m in db.TblMenu
// join offer in db.TblOffer on m.Id equals offer.TblMenuId
// join restaurant in db.TblRestaurantDetails on offer.TblRestaurantId equals restaurant.TblRestaurantId
// where restaurant.TblRestaurantId == restaurantID && m.Id == menuID
// select new TblMenu
// {
// quantity = m.quantity
// }).FirstOrDefault();
//}
menuObj = (from offer in db.TblOffer
join menu in db.TblMenu
on offer.TblMenuId equals menu.Id
join rest in db.TblRestaurantDetails
on offer.TblRestaurantId equals rest.TblRestaurantId
where rest.TblRestaurantId == restaurantID && menu.Id == menuID
select new TblMenu
{
quantity = menu.quantity
}).FirstOrDefault();
}
return(menuObj);
}
catch (Exception ex)
{
throw ex;
}
}
static async Task ProcessMessagesAsync(Message message, CancellationToken token)
{
// Process the message.
string s = Encoding.UTF8.GetString(message.Body);
listOfMessagesfromQueue.Add(s);
// Complete the message so that it is not received again.
// This can be done only if the subscriptionClient is created in ReceiveMode.PeekLock mode (which is the default).
await subscriptionClient.CompleteAsync(message.SystemProperties.LockToken);
if (listOfMessagesfromQueue.Count == 2)
{
StockDeails = _searchRepository.GetStockDetails(int.Parse(listOfMessagesfromQueue[0]), int.Parse(listOfMessagesfromQueue[1]));
CallBackMessagetoBeSent = StockDeails.quantity.ToString();
message = new Message(Encoding.UTF8.GetBytes(CallBackMessagetoBeSent));
// Send the message to the topic
await topicClient.SendAsync(message);
listOfMessagesfromQueue = new List <string>();
}
// Note: Use the cancellationToken passed as necessary to determine if the subscriptionClient has already been closed.
// If subscriptionClient has already been closed, you can choose to not call CompleteAsync() or AbandonAsync() etc.
// to avoid unnecessary exceptions.
}
public static bool Deactivate(int id)
{
try
{
if (id != 0)
{
using (RoundTheCornerEntities rc = new RoundTheCornerEntities())
{
TblMenu tblMenu = rc.TblMenus.FirstOrDefault(u => u.MenuID == id);
if (tblMenu != null)
{
tblMenu.IsActive = false;
rc.SaveChanges();
return(true);
}
else
{
throw new Exception("Menu was not found");
}
}
}
else
{
throw new Exception("Must have a valid id");
}
}
catch (Exception ex)
{
throw ex;
}
}
public int ItemOutOfStock(ItemStockMessage stock)
{
RestaurantMenu menuObj = new RestaurantMenu();
DataLayer.DataEntity.Stockitems _stock = new DataLayer.DataEntity.Stockitems()
{
RestaurantId = stock.TblRestaurantId,
CustomerId = stock.TblCustomerId,
MenuId = stock.TblMenuId
};
TblMenu menu = search_Repository.ItemOutOfStock(_stock.RestaurantId, _stock.MenuId);
menuObj.quantity = menu.quantity;
ItemStockMessage restaurantStock = new ItemStockMessage
{
TblRestaurantId = stock.TblRestaurantId,
TblMenuId = stock.TblMenuId,
TblCustomerId = stock.TblCustomerId,
Message = "Item Out of Stock"
};
if (menuObj.quantity == 0)
{
messageSend.SendMessagesAsync(restaurantStock);
}
return(menuObj.quantity);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,DisplayName,Icon,Type,Ordinal,Path,ParentId,IsEnable")] TblMenu tblMenu)
{
if (id != tblMenu.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tblMenu);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblMenuExists(tblMenu.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tblMenu));
}
public int ItemInStock(int restaurantID, int menuID)
{
RestaurantMenu menuObj = new RestaurantMenu();
TblMenu menu = search_Repository.ItemInStock(restaurantID, menuID);
menuObj.quantity = menu.quantity;
return(0);
}
public int ItemInStock(int menuID)
{
RestaurantMenu menuObj = new RestaurantMenu();
TblMenu menu = search_Repository.ItemInStock(menuID);
menuObj.quantity = menu.quantity;
menuObj.price = menu.price;
return(menuObj.quantity);
}
public TblMenu GetStockDetails(int restaurantID, int menuID)
{
TblMenu menuObj = new TblMenu();
try
{
var StockItems = new List <TblMenu>();
if (db != null)
{
// menuObj = (from m in db.TblMenu
// join offer in db.TblOffer on m.Id equals offer.TblMenuId
// join restaurant in db.TblRestaurantDetails on offer.TblRestaurantId equals restaurant.TblRestaurantId
// where restaurant.TblRestaurantId == restaurantID && m.Id == menuID
// select new TblMenu
// {
// quantity = m.quantity
// }).FirstOrDefault();
//}
StockItems = (from offer in db.TblOffer
join menu in db.TblMenu
on offer.TblMenuId equals menu.Id
join rest in db.TblRestaurantDetails
on offer.TblRestaurantId equals rest.TblRestaurantId
where rest.TblRestaurantId == restaurantID && menu.Id == menuID
select new TblMenu
{
Id = menu.Id,
Item = menu.Item,
quantity = menu.quantity
}).ToList();
if (StockItems.Count == 0)
{
return(menuObj);
}
else
{
TblMenu tblMenu = db.TblMenu.SingleOrDefault(x => x.Id == StockItems.FirstOrDefault().Id);
var UpdateData = tblMenu.quantity;
if (tblMenu.quantity > 0)
{
UpdateData = tblMenu.quantity - 1;
tblMenu.quantity = UpdateData;
db.SaveChanges();
menuObj.Id = tblMenu.Id;
menuObj.Item = tblMenu.Item;
menuObj.quantity = UpdateData;
return(menuObj);
}
}
}
return(menuObj);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Create([Bind("Id,DisplayName,Icon,Type,Ordinal,Path,ParentId,IsEnable")] TblMenu tblMenu)
{
if (ModelState.IsValid)
{
_context.Add(tblMenu);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblMenu));
}
/// <summary>
/// Menu Price Change
/// </summary>
/// <param name="menuID"></param>
/// <param name="price"></param>
public TblMenu MenuPriceUpdate(int menuID, int price)
{
try
{
TblMenu tblobj = new TblMenu();
tblobj = menupricerepo.MenuPriceUpdate(menuID, price);
return(tblobj);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> MenuPriceUpdate([FromQuery] int menuID, int price)
{
TblMenu tblmenu = new TblMenu();
tblmenu = business_Repo.MenuPriceUpdate(menuID, price);
if (tblmenu != null)
{
var pricechange = JsonConvert.SerializeObject(tblmenu);
await ItemPriceMessage.SendMessagesAsync(pricechange);
return(Ok("Item Price Updated"));
}
return(BadRequest("Failed to price Updated, Please try again later"));
}
public object UpdateMenuSubMenu(MenuSubMenuParam ObjMenu)
{
TblRoleMaster objrole = db.TblRoleMasters.SingleOrDefault(r => r.RoleId == ObjMenu.RoleId);
objrole.Role = ObjMenu.Role;
objrole.Status = 1;
objrole.ModifiedBy = 1;
objrole.ModifiedDate = DateTime.Now;
db.SaveChanges();
TblMenu objSubmenu = new TblMenu();
objSubmenu.RoleId = ObjMenu.RoleId;
string[] sbno = ObjMenu.selectedid.Split(',');
for (int i = 0; i < sbno.Length; i++)
{
if (sbno[i] != "0")
{
objSubmenu.ModuleId = int.Parse(sbno[i]);
objSubmenu.CreatedBy = 1;
objSubmenu.CreatedDate = DateTime.Now;
objSubmenu.Status = 1;
db.TblMenus.Add(objSubmenu);
db.SaveChanges();
}
}
string[] sbuncheck = ObjMenu.Unselectedid.Split(',');
for (int i = 0; i < sbuncheck.Length; i++)
{
if (sbuncheck[i] != "0")
{
int MenuId = int.Parse(sbuncheck[i]);
TblMenu objmenu = db.TblMenus.SingleOrDefault(r => r.RoleId == ObjMenu.RoleId && r.ModuleId == MenuId);
objmenu.Status = 0;
db.SaveChanges();
}
}
return("");
}
public StockItems GetStockDetails(int restaurantID, int menuID)
{
TblMenu StockQuantity = search_Repository.GetStockDetails(restaurantID, menuID);
StockItems stockItem = new StockItems()
{
Item = StockQuantity.Item,
RestaurantID = restaurantID,
MenuId = StockQuantity.Id,
Quantity = StockQuantity.quantity
};
return(stockItem);
}
public int Updateitemstock(int quantity, int menuid)
{
TblMenu tblobj = new TblMenu();
tblobj = db.TblMenu.Where(m => m.Id == menuid).FirstOrDefault();
if (tblobj.quantity > 0)
{
int updatedQuantity = tblobj.quantity - quantity;
tblobj.quantity = updatedQuantity;
db.Set <TblMenu>().Update(tblobj);
db.SaveChanges();
return(updatedQuantity);
}
return(tblobj.quantity);
}
public object SaveMenu(MenuSubMenuParam ObjMenu)
{
TblRoleMaster objrole = new TblRoleMaster();
objrole.Role = ObjMenu.Role;
objrole.Status = 1;
objrole.CreatedBy = 1;
objrole.CreatedDate = DateTime.Now;
db.TblRoleMasters.Add(objrole);
db.SaveChanges();
TblMenu objSubmenu = new TblMenu();
objSubmenu.RoleId = objrole.RoleId;
string[] sbno = ObjMenu.selectedid.Split(',');
for (int i = 0; i < sbno.Length; i++)
{
if (sbno[i] != "0")
{
objSubmenu.ModuleId = int.Parse(sbno[i]);
objSubmenu.CreatedBy = 1;
objSubmenu.CreatedDate = DateTime.Now;
objSubmenu.Status = 1;
db.TblMenus.Add(objSubmenu);
db.SaveChanges();
}
}
TblUserRole objuserrole = new TblUserRole();
objuserrole.RoleId = objrole.RoleId;
objuserrole.AllowInsert = ObjMenu.AllowInsert;
objuserrole.AllowEdit = ObjMenu.AllowEdit;
objuserrole.AllowDelete = ObjMenu.AllowDelete;
objuserrole.AllowView = ObjMenu.AllowView;
objuserrole.CreatedBy = 1;
objuserrole.CreatedDate = DateTime.Now;
objuserrole.Status = 1;
db.TblUserRoles.Add(objuserrole);
db.SaveChanges();
return("");
}
public int ItemInStock(int restaurantID, int menuID, int customerID)
{
RestaurantMenu menuObj = new RestaurantMenu();
TblMenu menu = search_Repository.ItemInStock(restaurantID, menuID);
menuObj.quantity = menu.quantity;
ItemStockMessage restaurantStock = new ItemStockMessage
{
TblRestaurantId = restaurantID,
TblMenuId = menuID,
TblCustomerId = customerID,
Message = "Item Out of Stock"
};
if (menuObj.quantity == 0)
{
messageSend.SendMessagesAsync(restaurantStock);
}
return(menuObj.quantity);
}
public TblMenu ItemInStock(int menuID)
{
try
{
TblMenu menuObj = new TblMenu();
if (db != null)
{
menuObj = (from menu in db.TblMenu
where menu.Id == menuID
select new TblMenu
{
price = menu.price,
quantity = menu.quantity
}).FirstOrDefault();
}
return(menuObj);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Menu Price Change
/// </summary>
/// <param name="menuID"></param>
public TblMenu MenuPriceUpdate(int menuID, int price)
{
try
{
TblMenu tblobj = new TblMenu();
if (db != null)
{
tblobj = db.TblMenu.Where(m => m.Id == menuID).FirstOrDefault();
if (tblobj != null)
{
tblobj.price = price;
db.Set <TblMenu>().Update(tblobj);
db.SaveChanges();
}
}
return(tblobj);
}
catch (Exception ex)
{
throw ex;
}
}
public static MenuModel Insert(int vendor)
{
try
{
using (RoundTheCornerEntities rc = new RoundTheCornerEntities())
{
PL.TblMenu newRow = new TblMenu()
{
MenuID = rc.TblMenus.Any() ? rc.TblMenus.Max(u => u.MenuID) + 1 : 1,
VendorID = vendor,
IsActive = true
};
rc.TblMenus.Add(newRow);
rc.SaveChanges();
MenuModel menuModel = new MenuModel();
menuModel.MenuID = newRow.MenuID;
return(menuModel);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool ValidateOffer(int menuID, bool offer)
{
try
{
if (offer == true)
{
TblMenu menuObj = new TblMenu();
if (db != null)
{
menuObj = (from ofr in db.TblOffer
join menu in db.TblMenu
on ofr.TblMenuId equals menu.Id
where menu.Id == menuID && ofr.FromDate <DateTime.Now &&
ofr.ToDate> DateTime.Now
select new TblMenu
{
quantity = menu.quantity
}).FirstOrDefault();
if (menuObj != null)
{
return(true);
}
return(false);
}
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static IList <MenuItem> GenerateTree(IEnumerable <TblMenu> collection, TblMenu rootItem)
{
IList <MenuItem> lst = new List <MenuItem>();
var tblIEnumerable = collection as TblMenu[] ?? collection.ToArray();
foreach (TblMenu c in tblIEnumerable.Where(c => c.ParentId == rootItem.Id))
{
lst.Add(new MenuItem
{
displayName = c.DisplayName,
icon = c.Icon,
ordinal = c.Ordinal,
path = c.Path,
type = c.Type,
childItems = GenerateTree(tblIEnumerable.ToList(), c).ToList()
});
}
return(lst);
}
public static void ExtUpdate(this TblMenu value, MenuModel obj)
{
value.Title = obj.Title;
value.IdGroupMenu = obj.IdGroupMenu;
}
/// <summary>
/// Function GetMenuAdminByParentCode
/// Haihm
/// </summary>
/// <param name="ParentCode"></param>
/// <returns></returns>
private object GetMenuAdminByParentCode(string ParentCode)
{
int index = 0;
try
{
List <MenuAndRoleViewModel> lstResult = new List <MenuAndRoleViewModel>();
TblMenu menuParent = db.TblMenu.Where(m => m.ParentCode.Equals(AccountConstant.MENU_PARENT_CODE) &&
m.MenuCode.Equals(ParentCode) &&
m.IsActive == true && m.IsDelete == false).OrderBy(o => o.MenuIndex).FirstOrDefault();
if (menuParent != null)
{
List <TblMenu> lst = db.TblMenu.Where(mChild => mChild.IsActive == true && mChild.IsDelete == false &&
mChild.ParentCode.Equals(ParentCode) &&
!mChild.MenuCode.Equals(AccountConstant.MENU_ADMIN_DEPART) &&
!mChild.MenuCode.Equals(AccountConstant.MENU_ATTR_RELATION)).OrderBy(o => o.MenuIndex).ToList <TblMenu>();
if (lst.Count() > 0)
{
foreach (var itemChild in lst)
{
MenuAndRoleViewModel model = new MenuAndRoleViewModel();
index += 1;
model.index += index;
model.MenuCode = itemChild.MenuCode;
model.MenuName = itemChild.MenuName;
model.ParentCode = itemChild.ParentCode;
model.AuthorityId = null;
model.IsEncypt = false;
model.IsShowAll = false;
model.IsShow = false;
model.IsAdd = false;
model.IsEditAll = false;
model.IsEdit = false;
model.IsDeleteAll = false;
model.IsDelete = false;
model.IsImport = false;
model.IsExport = false;
model.IsPrint = false;
model.IsApprove = false;
model.IsEnable = false;
model.IsPermission = false;
model.IsFirstExtend = false;
model.IsSecondExtend = false;
model.IsThirdExtend = false;
model.IsFouthExtend = false;
lstResult.Add(model);
}
}
else
{
MenuAndRoleViewModel model = new MenuAndRoleViewModel();
index += 1;
model.index += index;
model.MenuCode = menuParent.MenuCode;
model.MenuName = menuParent.MenuName;
model.ParentCode = menuParent.MenuCode;
model.AuthorityId = null;
model.IsEncypt = false;
model.IsShowAll = false;
model.IsShow = false;
model.IsAdd = false;
model.IsEditAll = false;
model.IsEdit = false;
model.IsDeleteAll = false;
model.IsDelete = false;
model.IsImport = false;
model.IsExport = false;
model.IsPrint = false;
model.IsApprove = false;
model.IsEnable = false;
model.IsPermission = false;
model.IsFirstExtend = false;
model.IsSecondExtend = false;
model.IsThirdExtend = false;
model.IsFouthExtend = false;
lstResult.Add(model);
}
}
return(lstResult);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(ex.Message);
}
}
public ActionResult Save(MenuViewModel menuViewModel)
{
try
{
if (ModelState.IsValid)
{
//add
if (menuViewModel.MenuId == 0 && menuViewModel.ActionName == "Add")
{
var model = new TblMenu()
{
MenuId = menuViewModel.MenuId,
MenuName = menuViewModel.MenuName,
MenuCaption = menuViewModel.MenuCaption,
MenuCaptionBng = menuViewModel.MenuCaptionBng,
PageUrl = menuViewModel.PageUrl,
SerialNo = menuViewModel.SerialNo,
OrderNo = menuViewModel.OrderNo,
ParentMenuId = menuViewModel.ParentMenuId,
ApplicationId = menuViewModel.ApplicationId,
ModuleId = menuViewModel.ModuleId
};
_menuRepository.Insert(model);
}
else if (menuViewModel.ActionName == "Edit") //edit
{
TblMenu menu = _menuRepository.GetById(menuViewModel.MenuId);
if (menu != null)
{
menu.MenuId = menuViewModel.MenuId;
menu.MenuName = menuViewModel.MenuName;
menu.MenuCaption = menuViewModel.MenuCaption;
menu.MenuCaptionBng = menuViewModel.MenuCaptionBng;
menu.PageUrl = menuViewModel.PageUrl;
menu.SerialNo = menuViewModel.SerialNo;
menu.OrderNo = menuViewModel.OrderNo;
menu.ParentMenuId = menuViewModel.ParentMenuId;
menu.ApplicationId = menuViewModel.ApplicationId;
menu.ModuleId = menuViewModel.ModuleId;
_menuRepository.Update(menu);
}
else
{
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.FalseString, menuViewModel.ActionName, MessageType.warning.ToString(), ExceptionHelper.ExceptionMessageForNullObject())));
}
}
_menuRepository.Save();
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.TrueString, menuViewModel.ActionName, MessageType.success.ToString(), "Saved Successfully.")));
}
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.FalseString, menuViewModel.ActionName, MessageType.warning.ToString(), ExceptionHelper.ModelStateErrorFormat(ModelState))));
}
catch (Exception ex)
{
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.FalseString, menuViewModel.ActionName, MessageType.warning.ToString(), ExceptionHelper.ExceptionMessageFormat(ex))));
}
}
