public IEnumerable <MakesQuery> GetAllMakes()
{
List <MakesQuery> makes = new List <MakesQuery>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("MakesSelectAll", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
MakesQuery currentRow = new MakesQuery();
currentRow.MakeId = (int)dr["MakeId"];
currentRow.UserName = dr["UserName"].ToString();
currentRow.MakeDescription = dr["MakeDescription"].ToString();
currentRow.MakeDateAdded = (DateTime)dr["MakeDateAdded"];
makes.Add(currentRow);
}
}
}
return(makes);
}
public IEnumerable <MakesQuery> GetAllMakes()
{
List <MakesQuery> list = new List <MakesQuery>();
foreach (var make in _Makes)
{
MakesQuery currentRow = new MakesQuery();
currentRow.MakeId = make.MakeId;
currentRow.UserName = "******";
currentRow.MakeDescription = make.MakeDescription;
currentRow.MakeDateAdded = make.MakeDateAdded;
list.Add(currentRow);
}
return(list);
}
