// แสดงรายการสมาชิกทั้งหมด
public GetMemberModel GetMembers([FromUri] MemberFilterOptions filters)
{
if (ModelState.IsValid)
{
return(this.memberService.GetMembers(filters));
}
throw new HttpResponseException(Request.CreateResponse(
HttpStatusCode.BadRequest,
new { Message = ModelState.GetErrorModelState() }
));
}
public GetMemberModel GetMembers(MemberFilterOptions filters)
{
var items = this.MemberItem.Select(m => new GetMember
{
id = m.id,
email = m.email,
firstname = m.firstname,
lastname = m.lastname,
position = m.position,
role = m.role,
updated = m.updated
}).OrderByDescending(m => m.updated);
var memberItems = new GetMemberModel
{
items = items
.Skip((filters.startPage - 1) * filters.limitPage)
.Take(filters.limitPage)
.ToArray(),
totalItems = items.Count()
};
if (!string.IsNullOrEmpty(filters.searchType) && filters.searchType.Equals("updated"))
{
var paramItem = HttpContext.Current.Request.Params;
var fromDate = paramItem.Get("searchText[from]").Replace(" GMT+0700 (Indochina Time)", "");
var toDate = paramItem.Get("searchText[To]").Replace(" GMT+0700 (Indochina Time)", "");
filters.searchText = $"{fromDate},{toDate}";
}
if (!string.IsNullOrEmpty(filters.searchType) && !string.IsNullOrEmpty(filters.searchText))
{
string searchText = filters.searchText;
string searchType = filters.searchType;
IEnumerable <GetMember> searchItem = new GetMember[] { };
switch (searchType)
{
case "updated":
var searchTexts = searchText.Split(',');
DateTime FromDate = DateTime.Parse(searchTexts[0]);
DateTime ToDate = DateTime.Parse(searchTexts[1]);
searchItem = from m in items
where FromDate <= m.updated && ToDate >= m.updated
select m;
break;
case "role":
searchItem = from m in items
where Convert.ToInt16(m.GetType()
.GetProperty(filters.searchType)
.GetValue(m)) == Convert.ToInt16(searchText)
select m;
break;
default:
searchItem = from m in items
where m.GetType()
.GetProperty(filters.searchType)
.GetValue(m)
.ToString()
.ToLower()
.Contains(searchText.ToLower())
select m;
break;
}
memberItems.items = searchItem
.Skip((filters.startPage - 1) * filters.limitPage)
.Take(filters.limitPage)
.ToArray();
memberItems.totalItems = searchItem.Count();
}
return(memberItems);
}
// แสดงรายการสมาชิก Pagination และ Filter
public GetMemberModel GetMembers(MemberFilterOptions filters)
{
// ดึงข้อมูล และ คัดข้อมูลที่ต้องการแสดง
var items = this.MemberItems.Select(m => new GetMember
{
id = m.id,
firstname = m.firstname,
lastname = m.lastname,
email = m.email,
position = m.position,
role = m.role,
updated = m.updated
})
.OrderByDescending(m => m.updated);
// เรียบเรียงข้อมูลให้อยู่ในรูปแบบที่ Frontend ต้องการ
var memberItems = new GetMemberModel
{
items = items
.Skip((filters.startPage - 1) * filters.limitPage)
.Take(filters.limitPage)
.ToArray(),
totalItems = items.Count()
};
// ตรวจสอบการ ค้นหาข้อมูลจากวันที่ หากมีข้อมูลมาก็ทำการ เรียบเรียงข้อมูลใหม่
if (!string.IsNullOrEmpty(filters.searchType) && filters.searchType.Equals("updated"))
{
var paramItem = HttpContext.Current.Request.Params;
var fromDate = paramItem.Get("searchText[from]").Replace(" GMT+0700 (Indochina Time)", "");
var toDate = paramItem.Get("searchText[to]").Replace(" GMT+0700 (Indochina Time)", "");
filters.searchText = $"{fromDate},{toDate}";
}
// หากว่ามีการค้นหาข้อมูลเข้ามาในระบบ
if (!string.IsNullOrEmpty(filters.searchType) && !string.IsNullOrEmpty(filters.searchText))
{
string searchText = filters.searchText;
string searchType = filters.searchType;
IEnumerable <GetMember> searchItem = new GetMember[] { };
switch (searchType)
{
// ค้นหาจากวันที่
case "updated":
var searchTexts = searchText.Split(',');
DateTime fromDate = DateTime.Parse(searchTexts[0]);
DateTime toDate = DateTime.Parse(searchTexts[1]);
searchItem = from m in items
where m.updated >= fromDate && m.updated <= toDate
select m;
break;
// ค้นหาจากสิทธิ์ผู้ใช้งาน
case "role":
searchItem = from m in items
where Convert.ToInt16(m.GetType()
.GetProperty(filters.searchType)
.GetValue(m)) == Convert.ToInt16(searchText)
select m;
break;
// ค้นหาทั่วไป
default:
searchItem = from m in items
where m.GetType()
.GetProperty(filters.searchType)
.GetValue(m)
.ToString()
.ToUpper()
.Contains(searchText.ToUpper())
select m;
break;
}
memberItems.items = searchItem
.Skip((filters.startPage - 1) * filters.limitPage)
.Take(filters.limitPage)
.ToArray();
memberItems.totalItems = searchItem.Count();
}
return(memberItems);
}
