public JsonResult LoadAllXa(XaRequestEM request)
        {
            JsonResult jResult = new JsonResult();

            try
            {
                var data = EFNotificationHistory.LoadAllXa(request);
                jResult = Json(new { code = "0", data = data }, JsonRequestBehavior.AllowGet);
            }
            catch (Exception)
            {
                jResult = Json(new { code = "1", message = CoreVar.sMessageError }, JsonRequestBehavior.AllowGet);
            }
            return(jResult);
        }
        public List <XaEM> LoadAllXa(XaRequestEM request)
        {
            List <XaEM> lstXa = null;

            try
            {
                lstXa = (from x in _context.Xas
                         where string.IsNullOrEmpty(request.HUYEN_ID) || x.HUYEN_ID.Value.ToString() == request.HUYEN_ID
                         select new XaEM
                {
                    AutoID = x.AutoID,
                    HUYEN_ID = x.HUYEN_ID,
                    TENXA = x.TENXA,
                    XA_ID = x.XA_ID,
                }).ToList();
            }
            catch (Exception)
            {
            }
            return(lstXa);
        }