public JObject Get()
 {
     try
     {
         List <Location> collection = LocationCollection.Find(new BsonDocument()).ToList();
         JObject         returnJson = JObject.FromObject(
             new
         {
             status = "success",
             result = collection
         }
             );
         return(returnJson);
     }
     catch (Exception ex)
     {
         return
             (JObject.FromObject(
                  new
         {
             status = "Exception Thrown",
             result = false,
             message = ex.Message
         }
                  ));
     }
 }
        public List <string> GetAllProvince()
        {
            var listLocation        = LocationCollection.Find(it => true).ToList();
            var listProvinceGroupBy = listLocation.OrderBy(it => it.LocationCode).GroupBy(it => it.Province).ToList();
            var listProvinceName    = new List <string>();

            foreach (var data in listProvinceGroupBy)
            {
                listProvinceName.Add(data.Key.ToString());
            }
            return(listProvinceName);
        }
        public List <LocationModel> GetAllLocation()
        {
            var listLocation = LocationCollection.Find(it => true).ToList();

            return(listLocation);
        }
        public LocationModel GetLocationCode(string LocationId)
        {
            var getLoation = LocationCollection.Find(it => it.LocationCode == LocationId).FirstOrDefault();

            return(getLoation);
        }
        public List <LocationModel> GetLocation(string nameProvince)
        {
            var listLocation = LocationCollection.Find(it => it.Province == nameProvince).ToList();

            return(listLocation);
        }