public CatalogoViewModel GetDettagli(string id)
{
string query = $"SELECT Id, Title, ImagePath, Author, Rating, FullPrice_Amount, FullPrice_Currency, CurrentPrice_Currency, CurrentPrice_Amount FROM Courses WHERE Id={id}";
DataSet dataSet = db.Query(query);
DataTable dataTable = dataSet.Tables[0];
CatalogoViewModel dettaglio = new CatalogoViewModel();
foreach (DataRow riga in dataTable.Rows)
{
dettaglio = CatalogoViewModel.FromDbToView(riga);
}
return(dettaglio);
}
public List <CatalogoViewModel> GetCatalogo()
{
string query = $"SELECT Id, Title, ImagePath, Author, Rating, FullPrice_Amount, FullPrice_Currency, CurrentPrice_Currency, CurrentPrice_Amount FROM Courses";
DataSet dataSet = db.Query(query);
DataTable dataTable = dataSet.Tables[0];
List <CatalogoViewModel> catalogoList = new List <CatalogoViewModel>();
foreach (DataRow catalogoRow in dataTable.Rows)
{
CatalogoViewModel CatalogoViewModel = CatalogoViewModel.FromDbToView(catalogoRow);
catalogoList.Add(CatalogoViewModel);
}
return(catalogoList);
}