public void AddUpdateSageFrameSearchSetting(SageFrameSearchSettingInfo objSearchSettingInfo, int PortalID, string CultureName, string AddedBy) { try { string SettingKeys = string.Empty; string SettingValues = string.Empty; //Pre pare Key value for the save; SettingKeys = "SearchButtonType#SearchButtonText#SearchButtonImage#SearchResultPerPage#SearchResultPageName#MaxSearchChracterAllowedWithSpace"; SettingValues = objSearchSettingInfo.SearchButtonType.ToString() + "#" + objSearchSettingInfo.SearchButtonText + "#" + objSearchSettingInfo.SearchButtonImage + "#" + objSearchSettingInfo.SearchResultPerPage.ToString() + "#" + objSearchSettingInfo.SearchResultPageName + "#" + objSearchSettingInfo.MaxSearchChracterAllowedWithSpace.ToString(); List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingKeys", SettingKeys)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingValues", SettingValues)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@CultureName", CultureName)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString())); ParaMeterCollection.Add(new KeyValuePair<string, string>("@AddedBy", AddedBy)); SQLHandler sagesql = new SQLHandler(); sagesql.ExecuteNonQuery("dbo.sp_SageFrameSearchSettingValueAddUpdate", ParaMeterCollection); } catch (Exception e) { throw e; } }
private void SaveSearchSettings() { try { if (txtSearchResultPageName.Text.Trim() != string.Empty && txtSearchResultPerPage.Text.Trim() != string.Empty && txtMaxSearchChracterAllowedWithSpace.Text.Trim() != string.Empty) { SageFrameSearchSettingInfo objSearchSettingInfo = new SageFrameSearchSettingInfo(); objSearchSettingInfo.SearchButtonType = Int32.Parse(rdblSearchButtonType.SelectedValue); objSearchSettingInfo.SearchButtonText = txtSearchButtonText.Text; objSearchSettingInfo.SearchButtonImage = txtSearchButtonImage.Text.Trim(); objSearchSettingInfo.SearchResultPageName = txtSearchResultPageName.Text.Trim(); objSearchSettingInfo.SearchResultPerPage = Int32.Parse(txtSearchResultPerPage.Text.Trim()); objSearchSettingInfo.MaxSearchChracterAllowedWithSpace = Int32.Parse(txtMaxSearchChracterAllowedWithSpace.Text.Trim()); objSearchSettingInfo.MaxResultChracterAllowedWithSpace = Int32.Parse(txtMaxResultCharacter.Text.Trim()); SageFrameSearch con = new SageFrameSearch(); con.AddUpdateSageFrameSearchSetting(objSearchSettingInfo, GetPortalID, GetCurrentCultureName, GetUsername); ShowMessage("", GetSageMessage("SageFrameSearch", "SearchSettingSavedSuccessfully"), "", SageMessageType.Success); } else { ShowMessage("", GetSageMessage("SageFrameSearch", "BlankValueNotAllowed"), "", SageMessageType.Alert); } } catch (Exception ex) { ProcessException(ex); } }
/// <summary> /// Connects to database and returns search settings by portal ID and culture name. /// </summary> /// <param name="PortalID">Portal ID.</param> /// <param name="CultureName">Culture name.</param> /// <returns>List of setting values.</returns> public SageFrameSearchSettingInfo LoadSearchSettings(int PortalID, string CultureName) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@CultureName", CultureName)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", PortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_SageFrameSearchSettingValueGet", ParaMeterCollection); SageFrameSearchSettingInfo objSearchSettingInfo = new SageFrameSearchSettingInfo(); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string strKey = dt.Rows[i]["SettingKey"].ToString(); switch (strKey) { case "SearchButtonType": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.SearchButtonType = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; case "SearchButtonText": objSearchSettingInfo.SearchButtonText = dt.Rows[i]["SettingValue"].ToString(); break; case "SearchButtonImage": objSearchSettingInfo.SearchButtonImage = dt.Rows[i]["SettingValue"].ToString(); break; case "SearchResultPerPage": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.SearchResultPerPage = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; case "SearchResultPageName": objSearchSettingInfo.SearchResultPageName = dt.Rows[i]["SettingValue"].ToString(); break; case "MaxSearchChracterAllowedWithSpace": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.MaxSearchChracterAllowedWithSpace = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; case "MaxResultChracterAllowedWithSpace": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.MaxResultChracterAllowedWithSpace = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; } } } return(objSearchSettingInfo); } catch (Exception e) { throw e; } }
public SageFrameSearchSettingInfo LoadSearchSettings(int PortalID, string CultureName) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@CultureName", CultureName)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_SageFrameSearchSettingValueGet", ParaMeterCollection); SageFrameSearchSettingInfo objSearchSettingInfo = new SageFrameSearchSettingInfo(); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string strKey = dt.Rows[i]["SettingKey"].ToString(); switch (strKey) { case "SearchButtonType": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.SearchButtonType = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; case "SearchButtonText": objSearchSettingInfo.SearchButtonText = dt.Rows[i]["SettingValue"].ToString(); break; case "SearchButtonImage": objSearchSettingInfo.SearchButtonImage = dt.Rows[i]["SettingValue"].ToString(); break; case "SearchResultPerPage": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.SearchResultPerPage = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; case "SearchResultPageName": objSearchSettingInfo.SearchResultPageName = dt.Rows[i]["SettingValue"].ToString(); break; case "MaxSearchChracterAllowedWithSpace": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.MaxSearchChracterAllowedWithSpace = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; } } } return objSearchSettingInfo; } catch (Exception e) { throw e; } }