public List <ListManagementInfo> GetEntriesByNameParentKeyAndPortalID(string ListName, string ParentKey, int PortalID, string Culture) { SqlDataReader reader = null; try { SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@ListName", ListName)); ParamCollInput.Add(new KeyValuePair <string, object>("@ParentKey", ParentKey)); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); ParamCollInput.Add(new KeyValuePair <string, object>("@Culture", Culture)); reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetListEntriesByNameParentKeyAndPortalID]", ParamCollInput); List <ListManagementInfo> lstList = new List <ListManagementInfo>(); while (reader.Read()) { ListManagementInfo objList = new ListManagementInfo(); objList.ParentID = int.Parse(reader["ParentID"].ToString()); objList.Level = int.Parse(reader["Level"].ToString()); objList.DefinitionID = int.Parse(reader["DefinitionID"].ToString()); objList.PortalID = int.Parse(reader["PortalID"].ToString()); lstList.Add(objList); } return(lstList);; } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }
/// <summary> /// Connects to a database and returns list entry detais by list name, value and entryID. /// </summary> /// <param name="ListName">List name.</param> /// <param name="Value">Value</param> /// <param name="EntryID">List entryID.</param> /// <param name="Culture">Current culture name</param> /// <returns>returns list detais</returns> public ListManagementInfo GetListEntryDetails(string ListName, string Value, int EntryID, string Culture) { SqlDataReader reader = null; try { SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@ListName", ListName)); ParamCollInput.Add(new KeyValuePair <string, object>("@Value", Value)); ParamCollInput.Add(new KeyValuePair <string, object>("@EntryID", EntryID)); ParamCollInput.Add(new KeyValuePair <string, object>("@Culture", Culture)); reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetListEntrybyNameValueAndEntryID]", ParamCollInput); ListManagementInfo objList = new ListManagementInfo(); while (reader.Read()) { objList.ListName = reader["ListName"].ToString(); objList.Value = reader["Value"].ToString(); objList.CurrencyCode = reader["CurrencyCode"].ToString(); objList.DisplayLocale = reader["DisplayLocale"].ToString(); objList.IsActive = bool.Parse(reader["IsActive"].ToString()); objList.Text = reader["Text"].ToString(); } return(objList); } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }
/// <summary> /// Connects to database and returns entries by list name , parentkey, portalID and culture. /// </summary> /// <param name="ListName">List name.</param> /// <param name="ParentKey">Parent list key.</param> /// <param name="PortalID">Portal ID.</param> /// <param name="Culture">Current culture.</param> /// <returns>Returns list of ListManagementInfo object containing the details</returns> public List<ListManagementInfo> GetEntriesByNameParentKeyAndPortalID(string ListName, string ParentKey, int PortalID, string Culture) { SqlDataReader reader = null; try { SQLHandler SQLH = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@ListName", ListName)); ParamCollInput.Add(new KeyValuePair<string, object>("@ParentKey", ParentKey)); ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); ParamCollInput.Add(new KeyValuePair<string, object>("@Culture", Culture)); reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetListEntriesByNameParentKeyAndPortalID]", ParamCollInput); List<ListManagementInfo> lstList = new List<ListManagementInfo>(); while (reader.Read()) { ListManagementInfo objList = new ListManagementInfo(); objList.ParentID = int.Parse(reader["ParentID"].ToString()); objList.Level = int.Parse(reader["Level"].ToString()); objList.DefinitionID = int.Parse(reader["DefinitionID"].ToString()); objList.PortalID = int.Parse(reader["PortalID"].ToString()); lstList.Add(objList); } return lstList; ; } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }
/// <summary> /// Connects to a database and returns list entry detais by list name, value and entryID. /// </summary> /// <param name="ListName">List name.</param> /// <param name="Value">Value</param> /// <param name="EntryID">List entryID.</param> /// <param name="Culture">Current culture name</param> /// <returns>returns list detais</returns> public ListManagementInfo GetListEntryDetails(string ListName, string Value, int EntryID, string Culture) { SqlDataReader reader = null; try { SQLHandler SQLH = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@ListName", ListName)); ParamCollInput.Add(new KeyValuePair<string, object>("@Value", Value)); ParamCollInput.Add(new KeyValuePair<string, object>("@EntryID", EntryID)); ParamCollInput.Add(new KeyValuePair<string, object>("@Culture", Culture)); reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetListEntrybyNameValueAndEntryID]", ParamCollInput); ListManagementInfo objList = new ListManagementInfo(); while (reader.Read()) { objList.ListName = reader["ListName"].ToString(); objList.Value = reader["Value"].ToString(); objList.CurrencyCode = reader["CurrencyCode"].ToString(); objList.DisplayLocale = reader["DisplayLocale"].ToString(); objList.IsActive = bool.Parse(reader["IsActive"].ToString()); objList.Text = reader["Text"].ToString(); } return objList; } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }