public List<Person> ReadAll()
{
string queryString = "SELECT * FROM [Table]";
List<Person> pr = new List<Person>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
//using (SqlCommand cmd = new SqlCommand("SELECT * FROM [Table]", connection))
//{
SqlCommand cmd = new SqlCommand(queryString, connection);
cmd.Connection.Open();
SqlDataReader sdr = cmd.ExecuteReader();
try
{
while (sdr.Read())
{
if (sdr.GetValue(3).ToString() == "")
{
Woman woman = new Woman();
woman.Id = sdr.GetInt32(0);
woman.Name = (string)sdr["Name"];
woman.Beauty = sdr.GetInt32(5);
woman.EyeColor = sdr.GetValue(6).ToString();
woman.Smile = sdr.GetValue(7).ToString();
pr.Add(woman);
}
else
{
Man man = new Man();
man.Id = sdr.GetInt32(0);
man.Name = (string)sdr["Name"];
man.Strength = sdr.GetValue(2).ToString();
man.Age = sdr.GetInt32(3);
man.Stamina = sdr.GetInt32(4);
pr.Add(man);
}
}
sdr.Close();
sdr.Dispose();
}
catch (Exception ex)
{
var bb = ex.Message;
}
}
return pr;
}
public Person Read(int id)
{
//SqlDataReader dr = null;
Person pr = new Person();
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM [Table] WHERE Id= "+id, connection))
{
cmd.Connection.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.GetInt32(3)==0)
{
Woman woman = new Woman();
woman.Id = dr.GetInt32(0);
woman.Name = (string)dr["Name"];
woman.Beauty = dr.GetInt32(5);
woman.EyeColor = dr.GetString(6);
woman.Smile = dr.GetString(7);
pr = woman;
}
else
{
Man man = new Man();
man.Id = dr.GetInt32(0);
man.Name = (string)dr["Name"];
man.Strength = dr.GetString(2);
man.Age = dr.GetInt32(3);
man.Stamina = dr.GetInt32(4);
pr = man;
}
}
dr.Close();
}
}
return pr;
}
