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 });
}
