private void AddPerson()
{
people.Add(newPerson);
db.add(new PersonDataBase()
{
LastName = newPerson.LastName,
DateOfBirth = newPerson.DateOfBirth,
Height = newPerson.Height,
});
NewPerson = new Person("", new DateTime(2001, 01, 01), 0);
}
private void DownloadFromDateBaseF()
{
var conn = new SqlConnection("server = SMSK01DB09\\DEV; " + "Trusted_Connection=yes;" + "database=TrainingDatabase; ");
try
{
string ID = null;
conn.Open();
var cmdFindFirst = new SqlCommand("SELECT * FROM FirstTable WHERE PrevID IS NULL", conn);
var reader = cmdFindFirst.ExecuteReader(); reader.Read();
ID = reader.HasRows ? reader["PersonID"].ToString() : null;
if (ID != null)
{
Person temp = new Person(reader["LastName"].ToString(), DateTime.Parse(reader["DateOfBirth"].ToString()), uint.Parse(reader["Height"].ToString()));
people.Add(temp);
}
do
{
conn.Close();
conn.Open();
var cmd = new SqlCommand("SELECT * FROM FirstTable WHERE PrevID=" + ID, conn);
reader = cmd.ExecuteReader(); reader.Read();
ID = reader.HasRows ? reader["PersonID"].ToString() : null;
if (ID != null)
{
Person temp = new Person(reader["LastName"].ToString(), DateTime.Parse(reader["DateOfBirth"].ToString()), uint.Parse(reader["Height"].ToString()));
people.Add(temp);
}
} while (ID != null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
