public LookupFacility GetFacility()
        {
            ILookupFacility facilityRepository = new LookupFacilityRepository();

            var deleteFlag = 0;
            var facility   = facilityRepository.FindBy(x => x.DeleteFlag == deleteFlag).FirstOrDefault();

            //var list = myList.GroupBy(x => x.FacilityID).Select(x => x.First()).OrderBy(x => x.FacilityName);
            return(facility);
        }
        public LookupFacility GetFacilityByMflCode(string mflCode)
        {
            ILookupFacility facilityRepository = new LookupFacilityRepository();

            var deleteFlag = 0;
            var facility   = _context.LookupFacility.Where(x => x.DeleteFlag == deleteFlag && mflCode == x.MFLCode).FirstOrDefault();

            //var list = myList.GroupBy(x => x.FacilityID).Select(x => x.First()).OrderBy(x => x.FacilityName);
            return(facility);
        }