/// <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;
}