public IActionResult Add(ModelYear modelYear)
{
var result = _modelYearService.Add(modelYear);
if (!result.IsSuccees)
{
return(BadRequest(result));
}
return(Ok(result));
}
public JsonResult CreateCarBody(CarBodyViewModel carBodyViewModel)
{
try
{
var data = Db.ModelYear.FirstOrDefault(my => my.Year == carBodyViewModel.Year && my.ModelId == carBodyViewModel.ModelId);
if (data == null)
{
data = new ModelYear
{
Year = carBodyViewModel.Year,
ModelId = carBodyViewModel.ModelId
};
Db.ModelYear.Add(data);
}
List <object> front = new List <object>
{
new { tire_width = new List <object> {
int.Parse(carBodyViewModel.Width)
}, tire_aspect_ratio = new List <object> {
int.Parse(carBodyViewModel.Height)
}, rim_diameter = new List <object> {
int.Parse(carBodyViewModel.Radius)
} }
};
var frontjs = new List <object> {
new { front = front }
};
var wheel = new List <object> {
new { wheel = frontjs }
};
var javaScriptSerializer = new
System.Web.Script.Serialization.JavaScriptSerializer();
string jsonWheel = javaScriptSerializer.Serialize(wheel);
var carBody = new CarBody
{
Name = carBodyViewModel.Name,
ModelYearId = data.Id,
Wheels = jsonWheel,
Description = carBodyViewModel.Description
};
Db.CarBody.Add(carBody);
Db.SaveChanges();
return(Json(new { Result = "OK", Record = carBodyViewModel }));
}
catch (Exception ex)
{
Response.StatusCode = 400;
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public void Vehicle_IsCreated_InValidState()
{
// todo(dca): mock this out
Model model = new Model("Sbuaru", 1);
Color color = new Color("World Rally Blue", "123");
Transmission transmission = new Transmission("6-Spd Manual");
ModelYear modelYear = new ModelYear(2015, model.Id);
string userIdentityGuid = "1235acb";
//Vehicle vehicle = _vehicleFactory.CreateVehicle(_vin, modelYear, color, transmission, userIdentityGuid);
//Assert.IsNotNull(vehicle);
}
public IResult Add(ModelYear modelYear)
{
var result = BusinessRules.Run(CheckModelYearExist(modelYear.Year));
if (result != null)
{
return(result);
}
_modelYearDal.Add(modelYear);
return(new SuccessResult(Messages.Added));
}
/// <summary>
/// Delete the given modelyear
/// </summary>
/// <param name="modelyear">The modelyear to delete</param>
public void Delete(ModelYear modelyear)
{
try
{
this.BeforeDeleteModelYear(modelyear);
this.DeleteAirtableRow <ModelYear>("ModelYears", modelyear);
this.AfterDeleteModelYear(modelyear);
}
catch (SkipOperationException soe)
{
// Ignore soe exceptions
}
}
public JsonResult UpdateModelYear(ModelYear modelYear)
{
try
{
Db.ModelYear.AddOrUpdate(modelYear);
Db.SaveChanges();
return(Json(new { Result = "OK", Record = modelYear }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
/// <summary>
/// Insert a new modelyear into the airtable
/// </summary>
/// <param name="modelyear">The modelyear to insert into the airtable</param>
/// <returns></returns>
public ModelYear Insert(ModelYear modelyear)
{
try
{
this.BeforeAddModelYear(modelyear);
modelyear = base.AddAirtableRow <ModelYear>("ModelYears", modelyear);
this.AfterAddModelYear(modelyear);
}
catch (SkipOperationException soe)
{
// Ignore soe exceptions
}
return(modelyear);
}
private static IEnumerable <ModelYear> GetDefaultModelYears()
{
var modelYears = new List <ModelYear>();
// Subaru BRZ and Toyota GT86
for (int year = 2013; year <= 2018; year++)
{
var brz = new ModelYear(year, 1);
var gt86 = new ModelYear(year, 3);
modelYears.Add(brz);
modelYears.Add(gt86);
}
// Scion FR-S
for (int year = 2013; year < 2017; year++)
{
var frs = new ModelYear(year, 2);
modelYears.Add(frs);
}
return(modelYears);
}
public string AddVehicleToDatabase()
{
SqlConnection connection;
SqlCommand command;
string query, vehicleID;
Customer Owner = new Customer();
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["PeninsulaRV"].ConnectionString);
query = "INSERT INTO Vehicle(ModelYear, Make, Model, StockNumber, VIN, VehicleType, Mileage, Description, Sale, Sold, Active, CustomerRef) Values(@ModelYear, @Make, @Model, @StockNumber, @VIN, @RVType, @Mileage, @Description, @Sale, @Sold, @Active, @CustomerRef) SELECT Scope_Identity()";
//query = "INSERT INTO Vehicle(ModelYear, Make, Model, StockNumber, VIN, VehicleType, Mileage, Description, Sale, Sold, Active, CustomerRef) Values(@ModelYear, @Make, @Model, @StockNumber, @VIN, @RVType, @Mileage, @Description, @Sale, @Sold, @Active, @CustomerRef) SELECT Scope_Identity()";
//query = "INSERT INTO Vehicle(ModelYear, Make, Model, VIN, VehicleType, Mileage, Description, Sale, Sold, Active, CustomerRef) Values(@ModelYear, @Make, @Model, @VIN, @RVType, @RVType, @Description, @Sale, @Sold, @Active, @CustomerRef) SELECT Scope_Identity()";
connection.Open();
command = new SqlCommand(query, connection);
command.Parameters.Add(SetDBNullIfEmpty("@ModelYear", ModelYear.ToString()));
command.Parameters.Add(SetDBNullIfEmpty("@Make", Make));
command.Parameters.Add(SetDBNullIfEmpty("@Model", Model));
command.Parameters.Add(SetDBNullIfEmpty("@StockNumber", Stocknumber));
command.Parameters.Add(SetDBNullIfEmpty("@VIN", VIN));
command.Parameters.Add(SetDBNullIfEmpty("@RVType", RVType));
command.Parameters.Add(SetDBNullIfEmpty("@Mileage", Mileage.ToString()));
command.Parameters.Add(SetDBNullIfEmpty("@Description", Description));
command.Parameters.AddWithValue("@Sale", ForSale);
command.Parameters.AddWithValue("@Sold", Sold);
command.Parameters.AddWithValue("@Active", Active);
command.Parameters.AddWithValue("@CustomerRef", this.Owner.CustomerID);
vehicleID = command.ExecuteScalar().ToString();
connection.Close();
return(vehicleID);
}
/// <summary> /// Called after a modelyear is deleted /// </summary> /// <param name="modelyear">The modelyear which was deleted</param> partial void AfterDeleteModelYear(ModelYear modelyear);
/// <summary> /// Called before a modelyear is deleted. Throw a SkipOperationException /// if the update should not happen /// </summary> /// <param name="modelyear">The modelyear to add</param> partial void BeforeDeleteModelYear(ModelYear modelyear);
/// <summary> /// Called after a modelyear is added /// </summary> /// <param name="modelyear">The modelyear which was added</param> partial void AfterAddModelYear(ModelYear modelyear);
/// <summary> /// Called before a modelyear is added. Throw a SkipOperationException /// if the update should not happen /// </summary> /// <param name="modelyear">The modelyear to add</param> partial void BeforeAddModelYear(ModelYear modelyear);
/// <summary> /// Called after a modelyear is updated /// </summary> /// <param name="modelyear">The modelyear which was updated</param> partial void AfterUpdateModelYear(ModelYear modelyear);
/// <summary> /// Called before a modelyear is updated. Throw a SkipOperationException /// if the update should not happen /// </summary> /// <param name="modelyear">The modelyear to update</param> partial void BeforeUpdateModelYear(ModelYear modelyear);
public IVehicle CreateVehicle(string vin, ModelYear modelYear, Color colorId, Transmission transmissionId, string userIdentityGuid)
{
IVehicle vehicle = new Vehicle(vin, modelYear, colorId, transmissionId, userIdentityGuid);
return(vehicle);
}
