public List <ServizioViewModel> Get()
{
FormattableString query = $"SELECT * FROM Servizio";
DataSet dataSet = _db.Query(query);
var dataTable = dataSet.Tables[0];
var eleServizi = new List <ServizioViewModel>();
foreach (DataRow row in dataTable.Rows)
{
FormattableString query2 = $"Select AVG(f.rating) as RatingMedio FROM feedback f INNER JOIN servizio s ON f.servizio = s.id WHERE s.id = {(int)row["Id"]}";
DataSet dataSet2 = _db.Query(query2);
var dataTable2 = dataSet2.Tables[0];
var dataRow2 = dataTable2.Rows[0];
ServizioViewModel servizio;
if (dataRow2.ItemArray[0] == DBNull.Value)
{
servizio = new ServizioViewModel((int)row["Id"], (string)row["Titolo"], (string)row["Descrizione"], 0);
}
else
{
servizio = new ServizioViewModel((int)row["Id"], (string)row["Titolo"], (string)row["Descrizione"], (decimal)dataRow2["RatingMedio"]);
}
eleServizi.Add(servizio);
}
return(eleServizi);
}
public List <Feedback> Get()
{
FormattableString query = $"SELECT * FROM Feedback";
DataSet dataSet = _db.Query(query);
var dataTable = dataSet.Tables[0];
var eleFeedback = new List <Feedback>();
foreach (DataRow row in dataTable.Rows)
{
var feedback = new Feedback((int)row["Id"], (string)row["Titolo"], (string)row["Commento"],
(int)row["Rating"], (DateTime)row["Data_ins"], (int)row["Utente"], (int)row["Servizio"]);
eleFeedback.Add(feedback);
}
return(eleFeedback);
}