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