public IEnumerable <LitterQuery> GetRecent()
{
using (SqlConnection conn = new SqlConnection())
{
List <LitterQuery> litters = new List <LitterQuery>();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRecentLitters";
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
LitterQuery current = new LitterQuery();
current.LitterId = (int)dr["LitterId"];
current.MamaDogId = (int)dr["MamaDogId"];
current.MamaDogName = dr["MamaDogName"].ToString();
current.PapaDogId = (int)dr["PapaDogId"];
current.PapaDogName = dr["PapaDogName"].ToString();
current.BirthDate = (DateTime)dr["BirthDate"];
current.PuppyCount = (byte)dr["PuppyCount"];
current.BirthDate.ToShortDateString();
litters.Add(current);
}
}
return(litters);
}
}
public LitterQuery GetById(int id)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetLitterById";
cmd.Parameters.AddWithValue("LitterId", id);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
LitterQuery current = new LitterQuery();
current.LitterId = (int)dr["LitterId"];
current.MamaDogId = (int)dr["MamaDogId"];
current.MamaDogName = dr["MamaDogName"].ToString();
current.PapaDogId = (int)dr["PapaDogId"];
current.PapaDogName = dr["PapaDogName"].ToString();
current.BirthDate = (DateTime)dr["BirthDate"];
current.PuppyCount = (byte)dr["PuppyCount"];
return(current);
}
}
}
return(null);
}
