//private static TouchBaseWebAPI.Data.row_productionEntities _DBTouchbase = new TouchBaseWebAPI.Data.row_productionEntities(); public static List <RotarianResult> GetRotarian(FindRotarianInput search) { try { MySqlParameter[] param = new MySqlParameter[4]; param[0] = new MySqlParameter("?MemberName", string.IsNullOrEmpty(search.name) ? "" : search.name.Replace(" ", "%")); param[1] = new MySqlParameter("?classification", string.IsNullOrEmpty(search.classification) ? "" : search.classification.Replace(" ", "%")); param[2] = new MySqlParameter("?club", string.IsNullOrEmpty(search.club) ? "" : search.club.Replace(" ", "%")); param[3] = new MySqlParameter("?districtNo", string.IsNullOrEmpty(search.district_number) ? "0" : search.district_number.Replace(" ", "%")); using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities()) { context.Connection.Open(); var Result = context.ExecuteStoreQuery <RotarianResult>("CALL V1_USPFindRotarian(?MemberName,?classification,?club,?districtNo)", param).ToList(); foreach (RotarianResult Mem in Result) { if (!string.IsNullOrEmpty(Mem.pic) && Mem.pic != "profile_photo.png") { string ImageName = Mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; Mem.pic = path + ImageName; } else { Mem.pic = ConfigurationManager.AppSettings["imgPath"] + "images/profile_pic.png"; } } return(Result); } } catch (Exception ex) { throw ex; } }
public object GetRotarianList(FindRotarianInput searchCriteria) { dynamic TBGetRotarianResult; try { List <RotarianResult> Result = FindRotarian.GetRotarian(searchCriteria); if (Result != null) { TBGetRotarianResult = new { status = "0", message = "success", RotarianResult = Result }; } else { TBGetRotarianResult = new { status = "0", message = "Record not found" }; } } catch { TBGetRotarianResult = new { status = "1", message = "failed" }; } return(new { TBGetRotarianResult }); }