/// <summary> /// Get_StringsLocation /// </summary> /// <param name="IDMember">ID of item</param> /// <param name="MemberTable">Table of item</param> /// <returns>return localised strings list of ID/MemberTable | NULL if error</returns> public static List<TextTypeWrapper> Get_LocalisedStrings(int IDMember, string MemberTable) { DataWrapper dtw = new DataWrapper(DataWrapper.ECONNECTIONTYPE.SQL, DataAccess.SQLConnString_DB.ConnectionString); if (dtw.TestConnection()) { dtw.DBConnection.Open(); try { System.Data.IDbCommand cmd = dtw.DBConnection.CreateCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "dbo.proc_GET_LOCATION_ALL"; System.Data.IDbDataParameter param_ID = cmd.CreateParameter(); param_ID.DbType = System.Data.DbType.Int32; param_ID.ParameterName = "IDMember"; param_ID.Value = IDMember; cmd.Parameters.Add(param_ID); System.Data.IDbDataParameter param_Table = cmd.CreateParameter(); param_Table.DbType = System.Data.DbType.String; param_Table.ParameterName = "MemberTable"; param_Table.Value = MemberTable; cmd.Parameters.Add(param_Table); System.Data.IDataReader reader = cmd.ExecuteReader(); List<TextTypeWrapper> listResult = new List<TextTypeWrapper>(); while (reader.Read()) { TextTypeWrapper text = new TextTypeWrapper(reader.GetString(reader.GetOrdinal("TwoLetterIso")), reader.GetString(reader.GetOrdinal("Value"))); listResult.Add(text); } dtw.DBConnection.Close(); return listResult; } catch { dtw.DBConnection.Close(); return null; } } return null; }
/// <summary> /// Get_Codelist /// </summary> /// <param name="code">Code of codelist</param> /// <param name="isDimensionCode">true if is code of dimension or false if is attribute</param> /// <returns>Return list of codelist items | null if error</returns> public static List<Code> Get_Codelist(string code, bool isDimensionCode = true) { DataWrapper dtw = new DataWrapper(DataWrapper.ECONNECTIONTYPE.SQL, DataAccess.SQLConnString_DB.ConnectionString); if (dtw.TestConnection()) { dtw.DBConnection.Open(); try { //////////////////////// string memberTable = string.Empty; System.Data.IDbCommand cmd = dtw.DBConnection.CreateCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; if (isDimensionCode) { cmd.CommandText = "dbo.proc_GET_CODES_DIMENSION"; memberTable = "Dim"; } else { cmd.CommandText = "dbo.proc_GET_CODES_ATTRIBUTE"; memberTable = "Att"; } System.Data.IDbDataParameter _param_code = cmd.CreateParameter(); _param_code.DbType = System.Data.DbType.String; _param_code.ParameterName = "Code"; _param_code.Value = code; cmd.Parameters.Add(_param_code); System.Data.IDbDataParameter _param_twoLeter = cmd.CreateParameter(); _param_twoLeter.DbType = System.Data.DbType.String; _param_twoLeter.ParameterName = "TwoLetterISO"; _param_twoLeter.Value = DataAccess.TwoLetterIso; cmd.Parameters.Add(_param_twoLeter); System.Data.IDataReader _reader = cmd.ExecuteReader(); List<Code> _codes = new List<Code>(); while (_reader.Read()) { Code _code = new Code(); _code.Id = _reader.GetString(_reader.GetOrdinal("Code")); _code.ParentCode = _reader.GetString(_reader.GetOrdinal("BaseCode")); _code.Names = new List<TextTypeWrapper>(); TextTypeWrapper name = new TextTypeWrapper(DataAccess.TwoLetterIso, _reader.GetString(_reader.GetOrdinal("Value"))); _code.Names.Add(name); _codes.Add(_code); } //////////////////////// dtw.DBConnection.Close(); return _codes; } catch { dtw.DBConnection.Close(); return null; } } return null; }