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); }