private void cbFeedr_SelectedIndexChanged(object sender, EventArgs e)
{
currentFeedr = owner.Feedrs.Find(x => x.id == Convert.ToInt32(cbFeedr.Text));
if (currentFeedr.dog != null)
{
cbDog.SelectedItem = currentFeedr.dog.Name;
}
}
public Account GetAcountInfo(int id)
{
//get account table
string Query = $"SELECT * FROM Account WHERE ID = {id}";
MySqlCommand mySqlCommand = new MySqlCommand(Query, con);
con.Open();
MySqlDataReader myReader = mySqlCommand.ExecuteReader();
myReader.Read();
//myReader.Close();
int Account_id = myReader.GetInt32("Id");
string name = myReader.GetString("Name");
string email = String.Empty;
try
{
email = myReader.GetString("Email");
}
catch
{
}
string password = myReader.GetString("Password");
Account account = new Account(Account_id, name, password, email);
myReader.Close();
//get dogs info
string DogQuery = $"SELECT * FROM Dog WHERE accountId = {id}";
mySqlCommand = new MySqlCommand(DogQuery, con);
myReader = mySqlCommand.ExecuteReader();
while (myReader.Read())
{
int dogId = myReader.GetInt32("Id");
string dogName = myReader.GetString("Name");
int weight = myReader.GetInt32("Weight");
int stageOfLife = myReader.GetInt32("StageOfLife");
DateTime dateOfBirth = Convert.ToDateTime(myReader.GetString("DateOfBirth"));
account.addDog(new Dog(dogId, dogName, dateOfBirth, stageOfLife, weight));
}
myReader.Close();
//get foods
string foodQuery = $"SELECT * FROM Food Where accountId = {id}";
mySqlCommand = new MySqlCommand(foodQuery, con);
myReader = mySqlCommand.ExecuteReader();
while (myReader.Read())
{
int foodid = myReader.GetInt32("Id");
string foodName = myReader.GetString("Name");
int energy = myReader.GetInt32("Energy");
account.addFood(new Food(foodid, foodName, energy));
}
myReader.Close();
//get feedrs
string feedrQuery = $"SELECT * FROM Feedr Where accountId = {id}";
mySqlCommand = new MySqlCommand(feedrQuery, con);
myReader = mySqlCommand.ExecuteReader();
while (myReader.Read())
{
int feedrId = 0;
try
{
feedrId = myReader.GetInt32("Id");
}
catch
{
}
int dogId = myReader.GetInt32("DogId");
Dog feedrDog = new Dog();
foreach (Dog dog in account.Dogs)
{
if (dog.Id == dogId)
{
feedrDog = dog;
}
}
int foodId = myReader.GetInt32("FoodId");
Food feedrFood = new Food();
foreach (Food accountFood in account.Foods)
{
if (accountFood.Id == foodId)
{
feedrFood = accountFood;
}
}
int foodPerMeal = myReader.GetInt32("FoodPerMeal");
int puzzle = myReader.GetInt32("Puzzle");
int level = myReader.GetInt32("level");
bool active = myReader.GetBoolean("active");
List <DateTime> mealtimes = new List <DateTime>();
Feedr feedr = new Feedr(feedrId, level, mealtimes, feedrDog, feedrFood, puzzle, active);
account.addFeedr(feedr);
}
con.Close();
return(account);
}
public void addFeedr(Feedr feedr)
{
Feedrs.Add(feedr);
}