public List <InteriorColor> GetAll()
{
List <InteriorColor> interiorColors = new List <InteriorColor>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("InteriorColorSelectAll", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
InteriorColor currentRow = new InteriorColor();
currentRow.InteriorColorID = (int)dr["InteriorColorID"];
currentRow.InteriorColorName = dr["InteriorColorName"].ToString();
interiorColors.Add(currentRow);
}
}
}
return(interiorColors);
}
public InteriorColor GetById(byte interiorColorId)
{
InteriorColor interiorColor = null;
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("InteriorColorsSelectById", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InteriorColorId", interiorColorId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
interiorColor = new InteriorColor();
interiorColor.InteriorColorId = (byte)dr["InteriorColorId"];
interiorColor.Name = dr["Name"].ToString();
interiorColor.ColorCode = dr["ColorCode"].ToString();
}
}
}
return(interiorColor);
}
public void ResetCarFilter()
{
RefreshContext();
if (Session.UserController.IsAuthorized)
{
_BrandFilter = null;
_ModelFilter = null;
_YearOfIssueMinFilter = 1975;
_YearOfIssueMaxFilter = 2020;
_BodyTypeFilter = 0;
_EngineVolumeMinFilter = 0.8f;
_EngineVolumeMaxFilter = 10.0f;
_EngineTypeFilter = 0;
_TransmissionTypeFilter = 0;
_WheelDriveTypeFilter = 0;
_MileageMinFilter = 0;
_MileageMaxFilter = 1000000M;
_BodyColorFilter = 0;
_InteriorMaterialFilter = 0;
_InteriorColorFilter = 0;
_PriceMinFilter = 0;
_PriceMaxFilter = 1000000M;
_BinaryFormatter.Serialize(_NetworkStream, MessageType.Success);
IsFilteringEnabled = false;
}
else
{
Session.SendErrorMessage("Для этого действия требуется авторизация!");
}
RefreshContext();
}
public IEnumerable <InteriorColor> GetAllInterior()
{
var interiorColors = new List <InteriorColor>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("InteriorColorsSelectAll", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var row = new InteriorColor();
row.InteriorColorId = (int)dr["InteriorColorId"];
row.Name = dr["Name"].ToString();
interiorColors.Add(row);
}
}
}
return(interiorColors);
}
public void SetCarFilter()
{
RefreshContext();
_BrandFilter = (string)_BinaryFormatter.Deserialize(_NetworkStream);
_ModelFilter = (string)_BinaryFormatter.Deserialize(_NetworkStream);
_YearOfIssueMinFilter = (int)_BinaryFormatter.Deserialize(_NetworkStream);
_YearOfIssueMaxFilter = (int)_BinaryFormatter.Deserialize(_NetworkStream);
_BodyTypeFilter = (BodyType)_BinaryFormatter.Deserialize(_NetworkStream);
_EngineVolumeMinFilter = (float)_BinaryFormatter.Deserialize(_NetworkStream);
_EngineVolumeMaxFilter = (float)_BinaryFormatter.Deserialize(_NetworkStream);
_EngineTypeFilter = (EngineType)_BinaryFormatter.Deserialize(_NetworkStream);
_TransmissionTypeFilter = (TransmissionType)_BinaryFormatter.Deserialize(_NetworkStream);
_WheelDriveTypeFilter = (WheelDriveType)_BinaryFormatter.Deserialize(_NetworkStream);
_MileageMinFilter = (decimal)_BinaryFormatter.Deserialize(_NetworkStream);
_MileageMaxFilter = (decimal)_BinaryFormatter.Deserialize(_NetworkStream);
_BodyColorFilter = (BodyColor)_BinaryFormatter.Deserialize(_NetworkStream);
_InteriorMaterialFilter = (InteriorMaterial)_BinaryFormatter.Deserialize(_NetworkStream);
_InteriorColorFilter = (InteriorColor)_BinaryFormatter.Deserialize(_NetworkStream);
_PriceMinFilter = (decimal)_BinaryFormatter.Deserialize(_NetworkStream);
_PriceMaxFilter = (decimal)_BinaryFormatter.Deserialize(_NetworkStream);
if (Session.UserController.IsAuthorized)
{
_BinaryFormatter.Serialize(_NetworkStream, MessageType.Success);
IsFilteringEnabled = true;
}
else
{
Session.SendErrorMessage("Для этого действия требуется авторизация!");
}
RefreshContext();
}
public List <InteriorColor> GetInteriorColors()
{
List <InteriorColor> interiorColors = new List <InteriorColor>();
using (var conn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("InteriorColorsSelectAll", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
InteriorColor row = new InteriorColor();
row.InteriorColorID = (int)dr["InteriorColorID"];
row.Color = dr["Color"].ToString();
interiorColors.Add(row);
}
}
}
return(interiorColors);
}
public InteriorColor GetInteriorColorById(int?id)
{
InteriorColor interiorColor = null;
using (var conn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("InteriorColorsSelect", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InteriorColorID", id);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
interiorColor = new InteriorColor();
interiorColor.InteriorColorID = (int)dr["InteriorColorID"];
interiorColor.Color = dr["Color"].ToString();
}
}
return(interiorColor);
}
}
public void CanAddColor(InteriorColor interior)
{
if (_interiorColors.Count == 0)
{
interior.InteriorColorId = 1;
}
else
{
interior.InteriorColorId = _interiorColors.Max(v => v.InteriorColorId);
}
_interiorColors.Add(interior);
}
public void ConstructorSetsCorrectEfenkaContext() //done by checking if getbyid works
{
EfenkaContextTestFactory.Create();
_sut = new InteriorColorRepository(EfenkaContextTestFactory.EfenkaContext);
var interiorColor = new InteriorColor
{
BrandId = 1
};
_sut.Add(interiorColor);
var interiorColorFromDatabase = _sut.GetById(interiorColor.Id);
Assert.That(interiorColorFromDatabase, Is.EqualTo(interiorColor));
}
public void InsertInteriorColor(InteriorColor interiorColor)
{
using (var conn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("InteriorColorsInsert", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter param = new SqlParameter("@InteriorColorID", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@Color", interiorColor.Color);
conn.Open();
cmd.ExecuteNonQuery();
interiorColor.InteriorColorID = (int)param.Value;
}
}
public void InsertInteriorColor(InteriorColor interiorColor)
{
throw new NotImplementedException();
}
public void CanDeleteColor(InteriorColor interior)
{
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 CanDeleteColor(InteriorColor interior)
{
_interiorColors.RemoveAll(i => i.InteriorColorId == interior.InteriorColorId);
}
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 InsertInteriorColor(InteriorColor interiorColor)
{
_context.InteriorColors.Add(interiorColor);
_context.SaveChanges();
}
public void Init()
{
_sut = new InteriorColor();
}
