//GET LIST EVENT public static List <EventViewModel> GetListEvent(EventViewModel paramSearch) { List <EventViewModel> result = new List <EventViewModel>(); if (paramSearch.statusName != null) { paramSearch.status = GetIntStatus(paramSearch.statusName); } using (var context = new MarkomApplicationDBEntities()) { var res = context.spEventSearch(paramSearch.code, paramSearch.requestByName, paramSearch.requestDate2, paramSearch.status, paramSearch.createDate, paramSearch.createBy); List <EventViewModel> comList = res.Select(c => new EventViewModel { id = c.id, code = c.code, requestByName = c.first_name + " " + c.last_name, requestDate = c.request_date, status = c.status, statusName = GetStringStatus(c.status), createDate = c.create_date, createBy = c.create_by }).ToList(); result = comList; } return(result); }