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); }