public IEnumerable <Sonnet> SelectSonnets(SonnetParams params_)
{
IEnumerable <Sonnet> sonnets;
using (var sqlConnection = new SqlConnection(_config.GetConnectionString("mssql")))
{
// TODO: Add guest logic
if (params_.UserId == "guest")
{
sonnets = sqlConnection.Query <Sonnet>(SonnetCommand.SELECT_ALL);
}
else
{
sonnets = sqlConnection.Query <Sonnet>(
SonnetCommand.SELECT_SONNETS_BYUSER,
new
{
userId = params_.UserId
});
}
}
return(sonnets);
}
//public List<Sonnet> GetSonnetsFromDirectory()
//{
// if (_sonnets == null)
// {
// var sonnets = new List<SonnetDto>();
// foreach (string fileName in _fileNames)
// {
// using (StreamReader sr = File.OpenText(fileName))
// {
// // Parse filename
// string baseName = Path.GetFileNameWithoutExtension(fileName);
// int sonnetId = Int32.Parse(baseName.Split("_")[0]);
// string sonnetTitle = baseName.Split("_")[1];
// int sonnetWordCount = 0;
// List<string> sonnetContent = new List<string>();
// // Load file
// string line = "";
// while ((line = sr.ReadLine()) != null)
// {
// sonnetWordCount += line.Split().Length;
// sonnetContent.Add(line);
// }
// // Instantiate Sonnet and add to list
// SonnetDto sonnet = new SonnetDto
// {
// Id = sonnetId,
// Title = sonnetTitle,
// WordCount=sonnetWordCount,
// Lines=sonnetContent
// };
// sonnets.Add(sonnet);
// }
// }
// // Cache sonnets
// _sonnets = sonnets;
// }
// return _sonnets;
//}
public IEnumerable <SonnetDto> GetSonnets(SonnetParams params_)
{
return(ConvertSonnets(_sonnetSqlDao.SelectSonnets(params_)));
}
public IActionResult GetSonnets(SonnetParams params_)
{
return(Ok(_service.GetSonnets(params_)));
}
