private int?GetNowOrderStatus(int?orderStatusID)
{
List <SelectListModel> selectList = (from r in _entities.OrderStatuses
orderby r.ID
select new SelectListModel
{
ID = r.ID,
Name = r.Status,
}).ToList();
if (!orderStatusID.HasValue)
{
orderStatusID = allStatusID;
}
ViewData["OrderStatuses"] = InternationalGMApplicationController.GetSelectListItem(allStatusID, allStatusID, null, selectList);
return(orderStatusID);
}
public ActionResult GMPast6MonthsHistory(int eventTypeID, string searchContent)
{
ViewData["searchContent"] = searchContent;
int memberNO = 0;
EventSignatureController erc = new EventSignatureController();
if (!string.IsNullOrEmpty(searchContent) && erc.IsInteger(searchContent))
{
memberNO = int.Parse(searchContent);
}
var querys = (from r in _entities.GroupMeditationAttendances
where (r.MemberInfo.Name.Contains(searchContent) ||
searchContent == null || r.MemberInfo.MemberNo == memberNO) &&
r.MemberInfo.MemberNo.HasValue && r.MemberInfo.MemberNo.Value < 1000 &&
!r.MemberInfo.Name.Contains("tester")
orderby r.MemberInfo.MemberNo
group r by new
{
memberInfo = r.MemberInfo,
} into result
select new GMAttendanceCountViewModel()
{
MemberInfo = result.Key.memberInfo,
TotalCount = result.Count(),
}).OrderBy(a => a.MemberInfo.MemberNo).ToList();
InternationalGMApplicationController igmac = new InternationalGMApplicationController();
List <GMAttendanceCountViewModel> viewModel = new List <GMAttendanceCountViewModel>();
foreach (GMAttendanceCountViewModel query in querys)
{
GMAttendanceCountViewModel gmAttendanceCountViewModel = igmac.GetGMAttendanceMonthlyCounts(6, query.MemberInfo);
viewModel.Add(gmAttendanceCountViewModel);
}
return(View(viewModel));
}
