public ActionResult SearchAdvancePreference(SearchAdvancePreferenceParametersVM model)
        {
            try
            {
                var preferences = preferenceRepository.SearchAdvancePreference(model);

                return(Json(new
                {
                    IsSuccess = true,
                    data = preferences
                }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception e)
            {
                Utility.Utility.LogError(e, "SearchAdvancePreference");
                return(Json(new { IsSuccess = false, errorMessage = e.Message }));
            }
        }
        public List <SearchAdvancePreferenceResultVM> SearchAdvancePreference(SearchAdvancePreferenceParametersVM model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter {
                    ParameterName = "@PreferenceGroupId", Value = model.PreferenceGroupId
                },
                new SqlParameter {
                    ParameterName = "@Preference", Value = model.Preference
                }
            };

            var dt = DALHelper.GetDataTableWithExtendedTimeOut("SearchAdvancePreference", parameters);

            var preferences = new List <SearchAdvancePreferenceResultVM>();

            preferences = DALHelper.CreateListFromTable <SearchAdvancePreferenceResultVM>(dt);

            return(preferences);
        }