public static List <Club> GetClubList(ClubDayInput search) { try { MySqlParameter[] param = new MySqlParameter[5]; param[0] = new MySqlParameter("?clubName", string.IsNullOrEmpty(search.keyword) ? "" : search.keyword.Replace(" ", "%")); param[1] = new MySqlParameter("?countryId", string.IsNullOrEmpty(search.country) ? "0" : search.country); param[2] = new MySqlParameter("?meetingDay", string.IsNullOrEmpty(search.meetingDay) ? "" : search.meetingDay.Replace(" ", "%")); param[3] = new MySqlParameter("?districtNo", string.IsNullOrEmpty(search.district) ? "0" : search.district); param[4] = new MySqlParameter("?state", string.IsNullOrEmpty(search.stateProvinceCity) ? "" : search.stateProvinceCity.Replace(" ", "%")); var Result = _DBTouchbase.ExecuteStoreQuery <Club>(" CALL V1_USPFindClubOnMeetingDay(?clubName,?countryId,?meetingDay,?districtNo,?state)", param).ToList(); return(Result); } catch (Exception ex) { throw ex; } }
public object GetClubList(ClubDayInput searchCriteria) { dynamic TBGetClubResult; try { List <Club> Result = FindClub.GetClubList(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 }); }