public TruckModelSaveUpdateViewModel SearchTruckModel(TruckModelSaveUpdateViewModel model)
{
var modelSearchResult = new TruckModel();
if (!string.IsNullOrEmpty(model.Description))
{
//Search for model in DB only if numbers and letters in model name
if (!_validate.Alphanumeric(model.Description))
{
model.IsValid = false;
}
else
{
modelSearchResult = _truckModelContext.Collection().Where(m => m.ModelDescription == model.Description).FirstOrDefault();
if (modelSearchResult == null)
{
model.ExistInDB = false;
}
else
{
model.Id = modelSearchResult.Id;
model.Description = modelSearchResult.ModelDescription;
model.ManufacturerId = modelSearchResult.TruckManufacturerId;
var manufacturer = _truckManufacturerContext.Collection().Where(m => m.Id == modelSearchResult.TruckManufacturerId).FirstOrDefault();
model.ManufacturerDescription = manufacturer.ManufacturerDescription;
}
}
}
return(model);
}
public TruckModelSaveUpdateViewModel RetrieveAllTruckManufacturers()
{
//Get a list of Manufacturers
var truckModel = new TruckModelSaveUpdateViewModel();
truckModel.ManufacturerDropDownList = RetrieveManufacturersFromDatabase();
return(truckModel);
}
public void PostNewTruckModelToDB(TruckModelSaveUpdateViewModel truckModel)
{
var truckModelToInsert = new TruckModel();
truckModelToInsert.ModelDescription = truckModel.Description;
truckModelToInsert.TruckManufacturerId = truckModel.ManufacturerId;
_truckModelContext.Insert(truckModelToInsert);
_truckModelContext.Commit();
_logger.Info("Inserted record Id " + truckModelToInsert.Id + " into Table " + tableNameUsedByLogger);
}
public JsonResult Add(TruckModelSaveUpdateViewModel truckModel)
{
try
{
var truckModelAddResult = _truckModelService.AddTruckModel(truckModel);
return(Json(truckModelAddResult, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public TruckModelSaveUpdateViewModel RetrieveModelById(string Id)
{
var modelRetrievedFromDB = _truckModelContext.Find(Id);
var modelViewModel = new TruckModelSaveUpdateViewModel();
modelViewModel.Id = modelRetrievedFromDB.Id;
modelViewModel.Description = modelRetrievedFromDB.ModelDescription;
modelViewModel.ManufacturerId = modelRetrievedFromDB.TruckManufacturerId;
modelViewModel.ManufacturerDropDownList = RetrieveManufacturersFromDatabase();
return(modelViewModel);
}
public void UpdateTruckModelData(TruckModelSaveUpdateViewModel truckModel)
{
var truckModelToUpdate = _truckModelContext.Find(truckModel.Id);
if (truckModelToUpdate != null)
{
_logger.Info("Found record Id " + truckModelToUpdate.Id + " in Table " + tableNameUsedByLogger);
truckModelToUpdate.ModelDescription = truckModel.Description;
truckModelToUpdate.TruckManufacturerId = truckModel.ManufacturerId;
_truckModelContext.Commit();
_logger.Info("Updated record Id " + truckModelToUpdate.Id + " in Table " + tableNameUsedByLogger);
}
}
public TruckModelSaveUpdateViewModel AddTruckModel(TruckModelSaveUpdateViewModel truckModel)
{
if (!string.IsNullOrEmpty(truckModel.Description))
{
//Verify that only letters and numbers in string model entered by user
if (!_validate.Alphanumeric(truckModel.Description))
{
truckModel.IsValid = false;
}
else
{
//Verify whether the model is already in DB
truckModel.ExistInDB = RetrieveTruckModelName(truckModel.Description);
if (!truckModel.ExistInDB)
{
PostNewTruckModelToDB(truckModel);
}
}
}
return(truckModel);
}
public TruckModelSaveUpdateViewModel UpdateTruckModel(TruckModelSaveUpdateViewModel truckModel)
{
if (!string.IsNullOrEmpty(truckModel.Description))
{
//Verify that only letters and numbers in string model entered by user
if (!_validate.Alphanumeric(truckModel.Description))
{
truckModel.IsValid = false;
}
else
{
//Verify whether the model is already in DB and save value
//in object to return to View for validation purposes
truckModel.ExistInDB = RetrieveTruckModelName(truckModel.Description);
if (!truckModel.ExistInDB)
{
UpdateTruckModelData(truckModel);
}
}
}
return(truckModel);
}
