public HttpResponseMessage postSearch(MasterBranchGroupSearchView model) { try { model.branchGroupCode = model.branchGroupCode.Trim(); model.branchGroupName = model.branchGroupName.Trim(); var result = branchGroupSvc.Search(model); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString())); } }
public CommonSearchView <MasterBranchGroupView> Search(MasterBranchGroupSearchView model) { using (var ctx = new ConXContext()) { //define model view CommonSearchView <MasterBranchGroupView> view = new ModelViews.CommonSearchView <ModelViews.MasterBranchGroupView>() { pageIndex = model.pageIndex - 1, itemPerPage = model.itemPerPage, totalItem = 0, datas = new List <ModelViews.MasterBranchGroupView>() }; //query data List <BranchGroup> branchGroups = ctx.BranchGroups .Where(x => (x.branchGroupCode.Contains(model.branchGroupCode) || model.branchGroupCode == "") && (x.branchGroupName.Contains(model.branchGroupName) || model.branchGroupName == "") ) .OrderBy(o => o.branchGroupCode) .ToList(); //count , select data from pageIndex, itemPerPage view.totalItem = branchGroups.Count; branchGroups = branchGroups.Skip(view.pageIndex * view.itemPerPage) .Take(view.itemPerPage) .ToList(); //prepare model to modelView foreach (var i in branchGroups) { view.datas.Add(new ModelViews.MasterBranchGroupView() { branchGroupId = i.branchGroupId, branchGroupCode = i.branchGroupCode, branchGroupName = i.branchGroupName, createUser = i.createUser, createDatetime = i.createDatetime, updateUser = i.updateUser, updateDatetime = i.updateDatetime ?? DateTime.Now }); } //return data to contoller return(view); } }