public IActionResult Post(CatCommodityGroupEditModel model) { if (!ModelState.IsValid) { return(BadRequest()); } var checkExistMessage = CheckExist(0, model); if (checkExistMessage.Length > 0) { return(BadRequest(new ResultHandle { Status = false, Message = checkExistMessage })); } var catCommodityGroup = mapper.Map <CatCommodityGroupModel>(model); catCommodityGroup.UserCreated = currentUser.UserID; catCommodityGroup.DatetimeCreated = catCommodityGroup.DatetimeModified = DateTime.Now; catCommodityGroup.Active = true; var hs = catComonityGroupService.Add(catCommodityGroup); var message = HandleError.GetMessage(hs, Crud.Insert); ResultHandle result = new ResultHandle { Status = hs.Success, Message = stringLocalizer[message].Value }; if (!hs.Success) { return(BadRequest(result)); } catComonityGroupService.ClearCache(); catComonityGroupService.Get(); return(Ok(result)); }
public IQueryable <CatCommodityModel> Query(CatCommodityCriteria criteria) { Expression <Func <CatCommodityModel, bool> > query = null; var commodities = Get(); if (commodities == null) { return(null); } var catCommonityGroups = catCommodityGroupService.Get(); IQueryable <CatCommodityModel> results = from com in commodities join grCom in catCommonityGroups on com.CommodityGroupId equals grCom.Id into grpComs from grp in grpComs.DefaultIfEmpty() select new CatCommodityModel { Id = com.Id, Code = com.Code, CommodityNameVn = com.CommodityNameVn, CommodityNameEn = com.CommodityNameEn, CommodityGroupId = com.CommodityGroupId, Note = com.Note, UserCreated = com.UserCreated, DatetimeCreated = com.DatetimeCreated, UserModified = com.UserModified, DatetimeModified = com.DatetimeModified, Active = com.Active, InactiveOn = com.InactiveOn, CommodityGroupNameEn = grp != null ? grp.GroupNameEn : string.Empty, CommodityGroupNameVn = grp != null ? grp.GroupNameVn : string.Empty }; if (criteria.All == null) { query = x => (x.CommodityNameVn ?? "").IndexOf(criteria.CommodityNameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.CommodityNameEn ?? "").IndexOf(criteria.CommodityNameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.CommodityGroupNameEn ?? "").IndexOf(criteria.CommodityGroupNameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.CommodityGroupNameVn ?? "").IndexOf(criteria.CommodityGroupNameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.Code ?? "").IndexOf(criteria.Code ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.Active == criteria.Active || criteria.Active == null); } else { query = x => ((x.CommodityNameVn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.CommodityNameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.CommodityGroupNameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.CommodityGroupNameVn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.Code ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1) && (x.Active == criteria.Active || criteria.Active == null); } if (results == null) { return(null); } results = results.Where(query); return(results); }