Beispiel #1
0
        //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);
        }