public static List <Diet> GetAll()
{
List <Diet> allDiets = new List <Diet> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM Diets;";
var rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
DateTime DietDate = new DateTime(0);
double DietCalories = rdr.GetDouble(1);
int personId = rdr.GetInt32(2);
Diet newDiet = new Diet(DietDate, DietCalories, personId);
allDiets.Add(newDiet);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allDiets);
}
public static Diet Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM Diets WHERE person_id = @searchId;";
cmd.Parameters.Add(new MySqlParameter("@searchId", id));
var rdr = cmd.ExecuteReader() as MySqlDataReader;
DateTime DietDate = new DateTime(1000, 11, 11);;
double DietCalories = 0;
int personId = 0;
while (rdr.Read())
{
DietDate = rdr.GetDateTime(0);
personId = rdr.GetInt32(2);
DietCalories = rdr.GetDouble(1);
}
Diet foundDiet = new Diet(DietDate, DietCalories, personId);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundDiet);
}
public override bool Equals(System.Object otherDiet)
{
if (!(otherDiet is Diet))
{
return(false);
}
else
{
Diet newDiet = (Diet)otherDiet;
bool areDietNameEqual = this._dietDate.Equals(newDiet._dietDate);
bool areDietCalEqual = this._dietCalories.Equals(newDiet._dietCalories);
return(areDietNameEqual);
}
}
