public ExteriorColor GetExteriorColorById(int?id) { ExteriorColor exteriorColor = null; using (var conn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("ExteriorColorsSelect", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ExteriorColorID", id); conn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { exteriorColor = new ExteriorColor(); exteriorColor.ExteriorColorID = (int)dr["ExteriorColorID"]; exteriorColor.Color = dr["Color"].ToString(); } } return(exteriorColor); } }
public List <ExteriorColor> GetExteriorColors() { List <ExteriorColor> extColors = new List <ExteriorColor>(); using (var conn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("ExteriorColorsSelectAll", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { ExteriorColor row = new ExteriorColor(); row.ExteriorColorID = (int)dr["ExteriorColorID"]; row.Color = dr["Color"].ToString(); extColors.Add(row); } } } return(extColors); }
public IEnumerable <ExteriorColor> GetAllExterior() { var exteriorColors = new List <ExteriorColor>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { var cmd = new SqlCommand("ExteriorColorsSelectAll", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var row = new ExteriorColor(); row.ExteriorColorId = (int)dr["ExteriorColorId"]; row.Name = dr["Name"].ToString(); exteriorColors.Add(row); } } } return(exteriorColors); }
// An overload tu support the params public CarConfiguration( ExteriorColor exteriorColor, AlloyWheels alloyWheels, Upholstery upholstery, InteriorTrims interiorTrims, params OptionalEquipment[] optionalEquipment) : this(exteriorColor, alloyWheels, upholstery, interiorTrims, optionalEquipment.AsEnumerable()) { }
public void CanAddExteriorColor(ExteriorColor exterior) { if (_exteriorColors.Count == 0) { exterior.ExteriorColorId = 1; } else { exterior.ExteriorColorId = _exteriorColors.Max(v => v.ExteriorColorId); } _exteriorColors.Add(exterior); }
public CarConfiguration( ExteriorColor exteriorColor, AlloyWheels alloyWheels, Upholstery upholstery, InteriorTrims interiorTrims, IEnumerable <OptionalEquipment> optionalEquipment) { ExteriorColor = exteriorColor; AlloyWheels = alloyWheels; Upholstery = upholstery; InteriorTrims = interiorTrims; OptionalEquipment = optionalEquipment; }
public void ConstructorSetsCorrectEfenkaContext() //done by checking if getbyid works { EfenkaContextTestFactory.Create(); _sut = new ExteriorColorRepository(EfenkaContextTestFactory.EfenkaContext); var exteriorColor = new ExteriorColor { BrandId = 1 }; _sut.Add(exteriorColor); var exteriorColorFromDatabase = _sut.GetById(exteriorColor.Id); Assert.That(exteriorColorFromDatabase, Is.EqualTo(exteriorColor)); }
public void InsertExteriorColor(ExteriorColor exteriorColor) { using (var conn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("ExteriorColorsInsert", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@ExteriorColorID", SqlDbType.Int); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@Color", exteriorColor.Color); conn.Open(); cmd.ExecuteNonQuery(); exteriorColor.ExteriorColorID = (int)param.Value; } }
public void CanDeleteExterior(ExteriorColor exterior) { throw new NotImplementedException(); }
public void GetAllIncludesAllRelationsOfRecord() { var brand = new Brand(); var model = new Model { Brand = brand }; var fuelType = new FuelType(); var engineType = new EngineType { Brand = brand }; var series = new Series { Brand = brand }; var doorType = new DoorType(); var category = new Category(); var country = new Country(); var exteriorColor = new ExteriorColor { Brand = brand }; var interiorColor = new InteriorColor { Brand = brand }; var person = new Person(); var driver = new Driver { Person = person }; var vehicle = new Vehicle { Brand = brand, Model = model, FuelType = fuelType, EngineType = engineType, Series = series, DoorType = doorType, Category = category, Country = country, ExteriorColor = exteriorColor, InteriorColor = interiorColor }; var fuelCard = new FuelCard { Driver = driver, Vehicle = vehicle }; var costAllocation = new CostAllocation(); var company = new Company(); var corporation = new Corporation { Company = company }; var record = new Record { FuelCard = fuelCard, CostAllocation = costAllocation, Corporation = corporation }; _sut.Add(record); var records = _sut.GetAll(); Assert.That(records, Is.Not.Null); var recordFromDatabase = records.FirstOrDefault(r => r.Id == record.Id); Assert.That(recordFromDatabase.CostAllocation, Is.EqualTo(costAllocation)); Assert.That(recordFromDatabase.Corporation, Is.EqualTo(corporation)); Assert.That(recordFromDatabase.Corporation.Company, Is.EqualTo(company)); Assert.That(recordFromDatabase.FuelCard.Vehicle.Brand, Is.EqualTo(brand)); Assert.That(recordFromDatabase.FuelCard.Vehicle.Model, Is.EqualTo(model)); Assert.That(recordFromDatabase.FuelCard.Vehicle.FuelType, Is.EqualTo(fuelType)); Assert.That(recordFromDatabase.FuelCard.Vehicle.EngineType, Is.EqualTo(engineType)); Assert.That(recordFromDatabase.FuelCard.Vehicle.Series, Is.EqualTo(series)); Assert.That(recordFromDatabase.FuelCard.Vehicle.DoorType, Is.EqualTo(doorType)); Assert.That(recordFromDatabase.FuelCard.Vehicle.Category, Is.EqualTo(category)); Assert.That(recordFromDatabase.FuelCard.Vehicle.Country, Is.EqualTo(country)); Assert.That(recordFromDatabase.FuelCard.Vehicle.ExteriorColor, Is.EqualTo(exteriorColor)); Assert.That(recordFromDatabase.FuelCard.Vehicle.InteriorColor, Is.EqualTo(interiorColor)); Assert.That(recordFromDatabase.FuelCard.Vehicle.FuelCard, Is.EqualTo(fuelCard)); Assert.That(recordFromDatabase.FuelCard.Driver, Is.EqualTo(driver)); Assert.That(recordFromDatabase.FuelCard.Driver.Person, Is.EqualTo(person)); }
public void InsertExteriorColor(ExteriorColor exteriorColor) { _context.ExteriorColors.Add(exteriorColor); _context.SaveChanges(); }
public void CanDeleteExterior(ExteriorColor exterior) { _exteriorColors.RemoveAll(e => e.ExteriorColorId == exterior.ExteriorColorId); }
public void Init() { _sut = new ExteriorColor(); }
public void FindIncludesAllRelationsOfVehicle() { var brand = new Brand(); var model = new Model { Brand = brand }; var fuelType = new FuelType(); var engineType = new EngineType { Brand = brand }; var series = new Series { Brand = brand }; var doorType = new DoorType(); var category = new Category(); var country = new Country(); var exteriorColor = new ExteriorColor { Brand = brand }; var interiorColor = new InteriorColor { Brand = brand }; var person = new Person(); var driver = new Driver { Person = person }; var fuelCard = new FuelCard { Driver = driver }; var vehicle = new Vehicle { Brand = brand, Model = model, FuelType = fuelType, EngineType = engineType, Series = series, DoorType = doorType, Category = category, Country = country, ExteriorColor = exteriorColor, InteriorColor = interiorColor, FuelCard = fuelCard }; _sut.Add(vehicle); var vehicleFromDatabase = _sut.Find(v => v.Id == vehicle.Id).FirstOrDefault(); Assert.That(vehicleFromDatabase.Brand, Is.EqualTo(brand)); Assert.That(vehicleFromDatabase.Model, Is.EqualTo(model)); Assert.That(vehicleFromDatabase.FuelType, Is.EqualTo(fuelType)); Assert.That(vehicleFromDatabase.EngineType, Is.EqualTo(engineType)); Assert.That(vehicleFromDatabase.Series, Is.EqualTo(series)); Assert.That(vehicleFromDatabase.DoorType, Is.EqualTo(doorType)); Assert.That(vehicleFromDatabase.Category, Is.EqualTo(category)); Assert.That(vehicleFromDatabase.Country, Is.EqualTo(country)); Assert.That(vehicleFromDatabase.ExteriorColor, Is.EqualTo(exteriorColor)); Assert.That(vehicleFromDatabase.InteriorColor, Is.EqualTo(interiorColor)); Assert.That(vehicleFromDatabase.FuelCard, Is.EqualTo(fuelCard)); Assert.That(vehicleFromDatabase.FuelCard.Driver, Is.EqualTo(driver)); Assert.That(vehicleFromDatabase.FuelCard.Driver.Person, Is.EqualTo(person)); }
public void InsertExteriorColor(ExteriorColor exteriorColor) { throw new NotImplementedException(); }
public static CarConfiguration WithExteriorColor(this CarConfiguration carConfiguration, ExteriorColor exteriorColor) { return(carConfiguration.With(exteriorColor)); }