public static List <Club> GetClubsNearMe(NearMeInput club)
{
try
{
if (club.distanceUnit == "Miles" && !string.IsNullOrEmpty(club.distance))
{
club.distance = (Convert.ToDouble(club.distance) * converter).ToString();
}
MySqlParameter[] param = new MySqlParameter[5];
param[0] = new MySqlParameter("?dist", string.IsNullOrEmpty(club.distance) ? "0" : club.distance);
param[1] = new MySqlParameter("?currentLat", string.IsNullOrEmpty(club.currentLat) ? "0" : club.currentLat);
param[2] = new MySqlParameter("?currentLong", string.IsNullOrEmpty(club.currentLong) ? "0" : club.currentLong);
param[3] = new MySqlParameter("?meetingDay", string.IsNullOrEmpty(club.meetingDay) ? "" : club.meetingDay.Replace(" ", "%"));
param[4] = new MySqlParameter("?meetingTime", string.IsNullOrEmpty(club.meetingTime) ? "0" : club.meetingTime);
var Result = _DBTouchbase.ExecuteStoreQuery <Club>("CALL V1_GetClubNearMe(?dist,?meetingDay,?meetingTime,?currentLat,?currentLong)", param).ToList();
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public object GetClubsNearMe(NearMeInput searchCriteria)
{
dynamic TBGetClubResult;
try
{
List <Club> Result = FindClub.GetClubsNearMe(searchCriteria);
if (Result != null)
{
TBGetClubResult = new { status = "0", message = "success", ClubResult = Result };
}
else
{
TBGetClubResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBGetClubResult = new { status = "1", message = "failed" };
}
return(new { TBGetClubResult });
}
