public JsonResult LoadAllHuyen(HuyenRequestEM request)
        {
            JsonResult jResult = new JsonResult();

            try
            {
                var data = EFNotificationHistory.LoadAllHuyen(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 <HuyenEM> LoadAllHuyen(HuyenRequestEM request)
        {
            List <HuyenEM> lstHuyen = null;

            try
            {
                lstHuyen = (from x in _context.Huyens
                            where string.IsNullOrEmpty(request.TINH_ID) || x.TINH_ID.Value.ToString() == request.TINH_ID
                            select new HuyenEM
                {
                    AutoID = x.AutoID,
                    HUYEN_ID = x.HUYEN_ID,
                    TINH_ID = x.TINH_ID,
                    TENHUYEN = x.TENHUYEN
                }).ToList();
            }
            catch (Exception ex)
            {
            }
            return(lstHuyen);
        }