public List <Option> GetLevelOptions(EOptionsLevel level) { List <Option> options = new List <Option>(); using (SqlConnection connection = DatabaseHelper.Instance.GetConnection()) { string sql = "select id, [option], price from Options where level = '" + level.ToString() + "'"; SqlCommand command = new SqlCommand(sql, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int optionId = (int)reader["id"]; string option = (string)reader["option"]; float price = float.Parse(reader["price"].ToString()); Option optionObj = new Option(optionId, option, price, level); options.Add(optionObj); } reader.Close(); } return(options); }
public List <Option> GetAllOptions() { List <Option> options = new List <Option>(); using (SqlConnection connection = DatabaseHelper.Instance.GetConnection()) { string sql = "select * from Options"; SqlCommand command = new SqlCommand(sql, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int optionId = (int)reader["id"]; string option = (string)reader["option"]; float price = float.Parse(reader["price"].ToString()); string level = (string)reader["level"]; EOptionsLevel eLevel = EOptionsLevel.Basic; switch (level) { case "Entry": eLevel = EOptionsLevel.Entry; break; case "Premium": eLevel = EOptionsLevel.Premium; break; case "Luxury": eLevel = EOptionsLevel.Luxury; break; } Option optionObj = new Option(optionId, option, price, eLevel); options.Add(optionObj); } reader.Close(); } return(options); }
public CarInventory( int id, Model model, Color color, Engine engine, DateTime buildDate, int mileage, float initialPrice ) { Id = id; Model = model; Color = color; Engine = engine; BuildDate = buildDate; Mileage = mileage; InitialPrice = initialPrice; OptionsLevel = EOptionsLevel.Basic; }
public float GetLevelCost(EOptionsLevel level) { float price = 0; using (SqlConnection connection = DatabaseHelper.Instance.GetConnection()) { string sql = "select price from Options where level = '" + level.ToString() + "'"; SqlCommand command = new SqlCommand(sql, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { price += float.Parse(reader["price"].ToString()); } reader.Close(); } return(price); }
public List <CarInventory> GetAllCars() { List <CarInventory> cars = new List <CarInventory>(); using (SqlConnection connection = DatabaseHelper.Instance.GetConnection()) { connection.Open(); string sql = "select * from CarsInventory"; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int id = (int)reader["id"]; int modelId = (int)reader["modelId"]; int colorId = (int)reader["colorId"]; DateTime buildDate = (DateTime)reader["buildDate"]; int mileage = (int)reader["mileage"]; float initialPrice = float.Parse(reader["initialPrice"].ToString()); float finalPrice = float.Parse(reader["finalPrice"].ToString()); string optionsLevel = (string)reader["optionsLevel"]; int engineId = (int)reader["engineId"]; IModelDAO modelDAO = new ModelDAO(); Model model = modelDAO.GetModel(modelId); IColorDAO colorDAO = new ColorDAO(); Color color = colorDAO.GetColor(colorId); IEngineDAO engineDAO = new EngineDAO(); Engine engine = engineDAO.GetEngine(engineId); CarInventory car = new CarInventory(id, model, color, engine, buildDate, mileage, initialPrice); EOptionsLevel eLevel = EOptionsLevel.Basic; switch (optionsLevel) { case "basic": eLevel = EOptionsLevel.Luxury; break; case "Entry": eLevel = EOptionsLevel.Entry; break; case "Premium": eLevel = EOptionsLevel.Premium; break; case "Luxury": eLevel = EOptionsLevel.Luxury; break; } IOptionDAO optionDAO = new OptionDAO(); List <Option> options = optionDAO.GetLevelOptions(eLevel); car.OptionsLevel = eLevel; car.Options = options; car.FinalPrice = finalPrice; cars.Add(car); } reader.Close(); } return(cars); }