public AudioDTO CreateAudio(AudioDTO audioDTO)
{
AudioDTO result = null;
ISession session = null;
try
{
session = DataLayer.GetSession();
Audio audio = new Audio();
audio.Description = audioDTO.Description;
audio.Name = audioDTO.Name;
audio.BelongsTo = session.Load <News>(audioDTO.BelongsToNewsId);
session.Save(audio);
session.Flush();
session.Close();
result = new AudioDTO(audio);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}
public static List <AudioDTO> GetAllAudio()
{
List <AudioDTO> audios = new List <AudioDTO>();
ISession session = null;
try
{
session = DataLayer.GetSession();
IEnumerable <Audio> retData = from a in session.Query <Audio>()
select a;
foreach (Audio a in retData)
{
AudioDTO audioDto = new AudioDTO(a);
audios.Add(audioDto);
}
session.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(audios);
}
public AudioDTO DeleteAudio(int audioId)
{
ISession session = null;
AudioDTO result = null;
try
{
session = DataLayer.GetSession();
Audio audio = session.Load <Audio>(audioId);
session.Delete(audio);
session.Flush();
session.Close();
result = new AudioDTO(audio);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}
public static List <AudioDTO> GetAudiosForNews(int newsId)
{
List <AudioDTO> audios = new List <AudioDTO>();
ISession session = null;
try
{
session = DataLayer.GetSession();
IEnumerable <Audio> retData = from a in session.Query <Audio>()
where a.BelongsTo.Id == newsId
select a;
//IList<Audio> retData = session.QueryOver<Audio>()
// .Where(x => x.BelongsTo.Id == newsId).List();
foreach (Audio a in retData)
{
AudioDTO audioDto = new AudioDTO(a);
audios.Add(audioDto);
}
session.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(audios);
}
public async Task CreateAudioAsync(AudioDTO audioDTO)
{
var audio = _mapper.Map <AudioDTO, Audio>(audioDTO);
await _audioService.CreateAsync(audio);
audioDTO.Id = audio.Id;
}
public async Task <ActionResult> Update(int id, AudioDTO audioDTO)
{
if (audioDTO.Id != id)
{
BadRequest();
}
await _administrationMicroservice.UpdateAudioAsync(id, audioDTO);
return(NoContent());
}
private static Audio MapAudioDtoToAudioEnt(AudioDTO ent)
{
return(new Audio
{
Id = ent.Id,
CategoryId = ent.CategoryId,
FragmentUrl = ent.FragmentUrl,
ImageUrl = ent.ImageUrl,
Name = ent.Name
});
}
public static ApiModel.Audio FromDTO(AudioDTO audioDTO)
{
return(audioDTO == null ? null : new ApiModel.Audio
{
AccessUrl = audioDTO.AccessUrl,
Artist = audioDTO.Artist,
DateAdded = audioDTO.DateAdded,
Id = audioDTO.Id,
Duration = audioDTO.Duration,
Song = audioDTO.Song,
Uploader = UserMapper.ToApi.FromData(audioDTO.Uploader),
});
}
public static Audio FromDTO(AudioDTO audioDTO)
{
return(audioDTO == null ? null : new Audio
{
//TODO use iunterfaces
AccessUrl = Host + audioDTO.AccessUrl,
Artist = audioDTO.Artist,
DateAdded = audioDTO.DateAdded,
Id = audioDTO.Id,
Duration = audioDTO.Duration,
Song = audioDTO.Song,
Uploader = UserMapper.ToApi.FromData(audioDTO.Uploader)
});
}
public bool DeleteAudio(int audioId)
{
bool result = false;
AudioDTO resultData = audioDataAccess.DeleteAudio(audioId);
if (resultData.AudioData != null)
{
result = loader.SaveMedia(resultData.Id, resultData.BelongsToNewsId, resultData.GetAudioBytes());
MessageQueueManager manager = MessageQueueManager.Instance;
manager.PublishMessage(resultData.BelongsToNewsId, resultData.Id, resultData, MessageOperation.Delete);
}
return(result);
}
public void AddNewAudioReturnsNewAudioWithId()
{
var audio = new AudioDTO
{
CategoryId = 1,
Name = "Audio van een banaan",
ImageUrl = "AudioUrl1",
FragmentUrl = "FragmentUrl1"
};
_audioServiceMock.Setup(service => service.Add(audio)).Returns(1);
var toPost = new ResponseObject {
Data = audio
};
var result = (OkObjectResult)_controller.AddNewAudio(toPost);
var responseObject = (ResponseObject)result.Value;
Assert.Equal(_audio1, responseObject.Data);
}
public ActionResult Detalle(string nombre)
{
using (DocumentClient client = new DocumentClient(new Uri(ConfigurationManager.AppSettings["CosmosdbURL"]), ConfigurationManager.AppSettings["CosmosdbKey"]))
{
FeedOptions queryOptions = new FeedOptions {
MaxItemCount = 1
};
var collectionLink = UriFactory.CreateDocumentCollectionUri(ConfigurationManager.AppSettings["CosmosdbDatabaseId"], ConfigurationManager.AppSettings["CosmosdbCollectionId"]);
AudioDTO audio = client.CreateDocumentQuery <AudioDTO>(collectionLink, "SELECT * FROM AudioProcesado WHERE AudioProcesado.Nombre = '" + nombre + "'", queryOptions).ToList().SingleOrDefault();
//var childrenSqlQuery = client.CreateDocumentQuery<EntidadDTO>(collectionLink,
//"SELECT c " +
//"FROM c IN f.Children WHERE c.Nombre = '" + nombre + "'").ToList();
//audio.Entidades = childrenSqlQuery;
DetalleViewModel model = new DetalleViewModel();
model.Audio = audio;
return(View(model));
}
}
public static AudioDTO GetAudio(int audioId)
{
ISession session = null;
AudioDTO result = null;
try
{
session = DataLayer.GetSession();
Audio user = session.Load <Audio>(audioId);
result = new AudioDTO(user);
session.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}
public async Task <ActionResult <AudioDTO> > Create(AudioDTO audioDTO)
{
await _administrationMicroservice.CreateAudioAsync(audioDTO);
return(CreatedAtAction(nameof(GetById), new { id = audioDTO.Id }, audioDTO));
}
public long Add(AudioDTO addDto)
{
return(_audioRepository.Add(MapAudioDtoToAudioEnt(addDto)));
}
public AudioDTO Update(AudioDTO entityDTO)
{
return(MapAudioEntToAudioDto(_audioRepository.Update(MapAudioDtoToAudioEnt(entityDTO))));
}
public async Task UpdateAudioAsync(int id, AudioDTO audioDTO)
{
var audio = _mapper.Map <AudioDTO, Audio>(audioDTO);
await _audioService.UpdateAsync(id, audio);
}
public bool PutAudio(AudioDTO audio)
{
service = Service.AudioService;
return(service.CreateAudio(audio));
}
public bool UpdateAudio(AudioDTO audio)
{
service = Service.AudioService;
return(service.UpdateAudio(audio));
}
