public TruckSaveUpdateViewModel SearchTruck(TruckSaveUpdateViewModel truck)
{
var truckSearchResult = new Truck();
var truckViewModel = new TruckViewModel();
if (!string.IsNullOrEmpty(truck.TruckNumber))
{
if (!_validate.Numeric(truck.TruckNumber))
{
truck.TruckNumberIsValid = false;
}
else
{
int truckNumberConvertedToInt = 0;
Int32.TryParse(truck.TruckNumber, out truckNumberConvertedToInt);
truckSearchResult = _truckContext.Collection().Where(t => t.TruckNumber == truckNumberConvertedToInt).FirstOrDefault();
if (truckSearchResult == null)
{
truck.ExistInDB = false;
}
else
{
truck.Id = truckSearchResult.Id;
truck.TruckNumber = truckSearchResult.TruckNumber.ToString();
truck.VIN = truckSearchResult.VIN;
truck.Manufacturer = truckSearchResult.TruckManufacturer.ManufacturerDescription;
truck.Model = truckSearchResult.TruckModel.ModelDescription;
truck.Year = truckSearchResult.TruckYear.ModelYear.ToString();
truck.Status = truckSearchResult.Status;
truck.StatusLabel = truckSearchResult.MessageBasedOnStatusSelection;
}
}
}
return(truck);
}
public TruckSaveUpdateViewModel AddTruck(TruckSaveUpdateViewModel truck)
{
//Validate truck number contains only digits and VIN only alphanumeric
if (!_validate.Numeric(truck.TruckNumber))
{
truck.TruckNumberIsValid = false;
}
else
if (!_validate.Alphanumeric(truck.VIN))
{
truck.VinNumberIsValid = false;
}
if (truck.TruckNumberIsValid == true && truck.VinNumberIsValid == true)
{
//Verify whether the truck number is already in DB
int truckNumberConvertedToInt = 0;
Int32.TryParse(truck.TruckNumber, out truckNumberConvertedToInt);
truck.ExistInDB = RetrieveTruckNumber(truckNumberConvertedToInt);
if (!truck.ExistInDB)
{
PostNewTruckModelToDB(truck);
}
}
return(truck);
}
public TruckSaveUpdateViewModel RetrieveAllTruckManufacturers()
{
//Get a list of Manufacturers
var trucks = new TruckSaveUpdateViewModel();
trucks.ManufacturerDropDownList = RetrieveManufacturersFromDatabase();
return(trucks);
}
public TruckSaveUpdateViewModel RetrieveModelAndYearListsFromDB(string Id)
{
var truckViewModel = new TruckSaveUpdateViewModel();
truckViewModel.ModelDropDownList = RetrieveModelsFromDatabaseBasedOnManufacturerID(Id);
truckViewModel.YearDropDownList = RetrieveYearsFromDatabase();
return(truckViewModel);
}
public JsonResult Add(TruckSaveUpdateViewModel truck)
{
try
{
var truckAddResult = _truckService.AddTruck(truck);
return(Json(truckAddResult, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public JsonResult SearchTruckNumber(TruckSaveUpdateViewModel truck)
{
try
{
var truckModelSearchResult = _truckService.SearchTruck(truck);
return(Json(truckModelSearchResult, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public void PostNewTruckModelToDB(TruckSaveUpdateViewModel truck)
{
var truckToInsert = new Truck();
int truckNumberConvertedToInt = 0;
Int32.TryParse(truck.TruckNumber, out truckNumberConvertedToInt);
truckToInsert.TruckNumber = truckNumberConvertedToInt;
truckToInsert.VIN = truck.VIN;
truckToInsert.TruckManufacturerId = truck.Manufacturer;
truckToInsert.TruckModelId = truck.Model;
truckToInsert.TruckYearId = truck.Year;
truckToInsert.Status = truck.Status;
_truckContext.Insert(truckToInsert);
_truckContext.Commit();
_logger.Info("Inserted record Id " + truckToInsert.Id + " into Table " + tableNameUsedByLogger);
}
public TruckSaveUpdateViewModel UpdateTruck(TruckSaveUpdateViewModel truck)
{
//Validate truck number contains only digits and VIN only alphanumeric
if (!_validate.Numeric(truck.TruckNumber))
{
truck.TruckNumberIsValid = false;
}
else
if (!_validate.Alphanumeric(truck.VIN))
{
truck.VinNumberIsValid = false;
}
if (truck.TruckNumberIsValid == true && truck.VinNumberIsValid == true)
{
UpdateTruckData(truck);
}
return(truck);
}
public TruckSaveUpdateViewModel RetrieveTruckById(string Id)
{
var truckRetrievedFromDB = _truckContext.Find(Id);
var truckViewModel = new TruckSaveUpdateViewModel();
truckViewModel.Id = truckRetrievedFromDB.Id;
truckViewModel.VIN = truckRetrievedFromDB.VIN;
truckViewModel.TruckNumber = truckRetrievedFromDB.TruckNumber.ToString();
truckViewModel.Manufacturer = truckRetrievedFromDB.TruckManufacturerId;
truckViewModel.Model = truckRetrievedFromDB.TruckModelId;
truckViewModel.Year = truckRetrievedFromDB.TruckYearId;
truckViewModel.Status = truckRetrievedFromDB.Status;
truckViewModel.StatusLabel = truckRetrievedFromDB.MessageBasedOnStatusSelection;
truckViewModel.ManufacturerDropDownList = RetrieveManufacturersFromDatabase();
truckViewModel.ModelDropDownList = RetrieveModelsFromDatabase();
truckViewModel.YearDropDownList = RetrieveYearsFromDatabase();
return(truckViewModel);
}
public void UpdateTruckData(TruckSaveUpdateViewModel truck)
{
var truckToUpdate = _truckContext.Find(truck.Id);
if (truckToUpdate != null)
{
_logger.Info("Found record Id " + truckToUpdate.Id + " in Table " + tableNameUsedByLogger);
truckToUpdate.VIN = truck.VIN;
int truckNumberConvertedToInt = 0;
Int32.TryParse(truck.TruckNumber, out truckNumberConvertedToInt);
truckToUpdate.TruckNumber = truckNumberConvertedToInt;
truckToUpdate.Status = truck.Status;
truckToUpdate.TruckManufacturerId = truck.Manufacturer;
truckToUpdate.TruckModelId = truck.Model;
truckToUpdate.TruckYearId = truck.Year;
_truckContext.Commit();
_logger.Info("Updated record Id " + truckToUpdate.Id + " in Table " + tableNameUsedByLogger);
}
}
