public IEnumerable <ProfileMme> GetMmeProfiles(long mmeCodeId)
{
lock (_locker)
{
var list = new List <ProfileMme>();
if (_connection == null || _connection.State != ConnectionState.Open)
{
return(list);
}
list = _profilesService.GetProfileItems().Select(p => new ProfileMme {
Id = p.ProfileId, Name = p.ProfileName
}).ToList();
var codesSelectCommand = new SQLiteCommand("SELECT PROFILE_ID FROM MME_CODES_TO_PROFILES where MME_CODE_ID=@MME_CODE_ID", _connection);
codesSelectCommand.Parameters.Add("@MME_CODE_ID", DbType.Int64);
codesSelectCommand.Prepare();
codesSelectCommand.Parameters["@MME_CODE_ID"].Value = mmeCodeId;
using (var reader = codesSelectCommand.ExecuteReader())
{
while (reader.Read())
{
var id = (long)reader[0];
var item = list.FirstOrDefault(p => p.Id.Equals(id));
if (!ReferenceEquals(item, null))
{
item.IsSelected = true;
}
}
}
return(list);
}
}
public List <ProfileItem> GetProfiles()
{
try
{
return(_profilesService.GetProfileItems());
}
catch (Exception ex)
{
throw ex;
}
}
public List <ProfileItem> GetProfileItems()
{
return(_profilesService.GetProfileItems());
}
