public IEnumerable <MakeModels> GetModelsForMake(int makeId)
{
List <MakeModels> models = new List <MakeModels>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("ModelsGetByMake", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MakeId", makeId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
MakeModels currentRow = new MakeModels();
currentRow.MakeId = (int)dr["MakeId"];
currentRow.MakeDescription = dr["MakeDescription"].ToString();
currentRow.ModelId = (int)dr["ModelId"];
currentRow.UserName = dr["UserName"].ToString();
currentRow.ModelDescription = dr["ModelDescription"].ToString();
currentRow.ModelDateAdded = (DateTime)dr["ModelDateAdded"];
models.Add(currentRow);
}
}
}
return(models);
}
public IEnumerable <MakeModels> GetAllModels()
{
List <MakeModels> list = new List <MakeModels>();
foreach (var model in _Models)
{
MakeModels currentRow = new MakeModels();
currentRow.MakeId = model.MakeId;
currentRow.MakeDescription = _Makes.FirstOrDefault(m => m.MakeId == model.MakeId).MakeDescription.ToString();
currentRow.UserName = "******";
currentRow.ModelId = model.ModelId;
currentRow.ModelDescription = model.ModelDescription;
currentRow.ModelDateAdded = model.ModelDateAdded;
list.Add(currentRow);
}
return(list);
}
