Esempio n. 1
0
        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));
            }
        }
Esempio n. 2
0
        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);
        }