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);
}
}
