public HttpResponseMessage inquiry(MasterInquiryUserRoleParam model)
{
try
{
model.username = model.username.Trim();
model.name = model.name.Trim();
var result = userRoleService.InquiryUserRoles(model);
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString()));
}
}
public CommonSearchView <UserRole> InquiryUserRoles(MasterInquiryUserRoleParam model)
{
using (var ctx = new ConXContext())
{
//define model view
CommonSearchView <UserRole> view = new ModelViews.CommonSearchView <UserRole>()
{
pageIndex = model.pageIndex - 1,
itemPerPage = model.itemPerPage,
totalItem = 0,
datas = new List <UserRole>()
};
//query data
List <UserRole> userRoles = ctx.UserRoles
.Where(x =>
(x.roleName.Contains(model.name) || model.name == null) &&
(x.status == model.status || model.status == null) &&
x.isPC == model.isPC &&
(x.createUser == model.createUser || model.createUser.ToLower() == "admin")
)
.OrderBy(o => o.createDatetime)
.ToList();
//count , select data from pageIndex, itemPerPage
view.totalItem = userRoles.Count;
userRoles = userRoles.Skip(view.pageIndex * view.itemPerPage)
.Take(view.itemPerPage)
.ToList();
//prepare model to modelView
foreach (var i in userRoles)
{
view.datas.Add(i);
}
//return data to contoller
return(view);
}
}
