public List <CastigTotalConsultatii> GetCastigConsultatiiMedic()
{
this.conn.Open();
SqlCommand cmd = new SqlCommand("SELECT M.Nume, M.Prenume, A.CastigTotal " +
"FROM Medici M, (SELECT MedicID, Sum(C.Pret) AS CastigTotal " +
"FROM Consultatii C " +
"GROUP BY MedicID " +
"HAVING SUM(C.Pret) > 100) AS A " +
"WHERE M.id = A.MedicID ", conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
var medici = new List <CastigTotalConsultatii>();
while (reader.Read())
{
var p = new CastigTotalConsultatii
{
Nume = reader.GetString(0),
Prenume = reader.GetString(1),
CastigTotal = reader.GetInt32(2)
};
medici.Add(p);
}
return(medici);
}
}
public List <CastigTotalConsultatii> GetNrReteteMedic()
{
this.conn.Open();
SqlCommand cmd = new SqlCommand("SELECT Nume, Prenume " +
"FROM Medici WHERE ID IN (SELECT MedicID FROM Consultatii WHERE ID IN (SELECT ConsultatieID FROM Retete) GROUP BY MedicID HAVING COUNT(*) > 1 )", conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
var medici = new List <CastigTotalConsultatii>();
while (reader.Read())
{
var p = new CastigTotalConsultatii
{
Nume = reader.GetString(0),
Prenume = reader.GetString(1),
};
medici.Add(p);
}
return(medici);
}
}
