public HttpResponseMessage SetupMenu(Int32 StoreId, Int32 MenuId, Int32 CategoryId, Int32 ProductId) { MenuSetupModel model = new MenuSetupModel(); model.StoreId = StoreId; model.MenuId = MenuId; model.CategoryId = CategoryId; model.ProductId = ProductId; ResponseStatus response = new ResponseStatus(); try { var data = _repository.SetupMenu(model); if (data != null) { //response.isSuccess = true; //response.serverResponseTime = System.DateTime.Now; return(Request.CreateResponse(HttpStatusCode.OK, new { data })); } else { //response.isSuccess = false; //response.serverResponseTime = System.DateTime.Now; return(Request.CreateResponse(HttpStatusCode.BadRequest, new { data })); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something Worng !", ex)); } }
public IEnumerable <MenuSetUpMasterModel> SetupMenu(MenuSetupModel model) { ResponseStatus response = new ResponseStatus(); List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>(); using (storefeedback_androidEntities context = new storefeedback_androidEntities()) { var data = context.menusetupmasters.Where(w => w.menuid == model.MenuId && w.categoryid == model.CategoryId && w.Productid == model.ProductId).FirstOrDefault(); if (data != null) { } else { menusetupmaster m = new menusetupmaster(); m.menuid = model.MenuId; m.categoryid = model.CategoryId; m.Productid = model.ProductId; m.StoreId = model.StoreId; context.menusetupmasters.Add(m); var result = context.SaveChanges(); if (result > 0) { resultdata = (from ms in context.menusetupmasters join me in context.menumasters on ms.menuid equals me.MenuId into j1 from j2 in j1.DefaultIfEmpty() join cat in context.categorymasters on ms.categoryid equals cat.CategoryId into j3 from j4 in j3.DefaultIfEmpty() join pro in context.productmasters on ms.Productid equals pro.ProductId into j5 from j6 in j5.DefaultIfEmpty() orderby ms.createdon descending select new MenuSetUpMasterModel() { id = ms.id, MenuName = j2.MenuName, CategoryName = j4.CategoryName, ProductName = j6.ProductName, CreatedOn = (DateTime)ms.createdon }).ToList(); } } } return(resultdata); }