public static List <clsGetWebLinkOutput> GetWebLinkList(clsGetWebLinkInput input) { try { MySqlParameter[] param = new MySqlParameter[2]; param[0] = new MySqlParameter("?strSearch", string.IsNullOrEmpty(input.SearchText) ? "" : input.SearchText.Replace(' ', '%').Trim()); param[1] = new MySqlParameter("?strGroupID", input.GroupId); var Result = _DBTouchbase.ExecuteStoreQuery <clsGetWebLinkOutput>("CALL WEBGetWebLinkList(?strSearch, ?strGroupID)", param).ToList(); return(Result); } catch (Exception ex) { throw ex; } }
public static List <clsGetWebLinkOutput> GetWebLinkList(clsGetWebLinkInput input) { try { MySqlParameter[] param = new MySqlParameter[2]; param[0] = new MySqlParameter("?strSearch", string.IsNullOrEmpty(input.SearchText) ? "" : input.SearchText.Replace(' ', '%').Trim()); param[1] = new MySqlParameter("?strGroupID", input.GroupId); using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities()) { context.Connection.Open(); var Result = context.ExecuteStoreQuery <clsGetWebLinkOutput>("CALL WEBGetWebLinkList(?strSearch, ?strGroupID)", param).ToList(); return(Result); } } catch (Exception ex) { throw ex; } }
public object GetWebLinksList(clsGetWebLinkInput searchCriteria) { dynamic TBGetWebLinkListResult; try { List <clsGetWebLinkOutput> Result = WebLinks.GetWebLinkList(searchCriteria); if (Result != null) { TBGetWebLinkListResult = new { status = "0", message = "success", WebLinkListResult = Result }; } else { TBGetWebLinkListResult = new { status = "0", message = "Record not found" }; } } catch { TBGetWebLinkListResult = new { status = "1", message = "failed" }; } return(new { TBGetWebLinkListResult }); }