private void CheckVehicleExists(TachographContext context, TachographDocument entity)
{
if (entity == null)
{
return;
}
var vehicleMakes = context.VehicleMakes.Include("Models").ToList();
VehicleMake vehicleMake = vehicleMakes.FirstOrDefault(v => string.Equals(v.Name, entity.VehicleMake));
if (vehicleMake != null)
{
bool vehicleModelExists = vehicleMakes.First(m => string.Equals(m.Name, entity.VehicleMake)).Models.Any(c => string.Equals(c.Name, entity.VehicleModel));
if (!vehicleModelExists && !string.IsNullOrEmpty(entity.VehicleModel))
{
VehicleModel vehicleModel = new VehicleModel {
Name = entity.VehicleModel
};
vehicleMake.Models.Add(vehicleModel);
}
}
else
{
vehicleMake = context.VehicleMakes.Add(new VehicleMake {
Name = entity.VehicleMake
});
if (!string.IsNullOrEmpty(entity.VehicleModel))
{
vehicleMake.Models.Add(new VehicleModel {
Name = entity.VehicleModel
});
}
}
}
public EditVehicleMake(VehicleMake vehicleMake, ObservableCollection <VehicleMake> lVehicleMake)
{
InitializeComponent();
editVM = new EditVehicleMakeViewModel(vehicleMake, lVehicleMake);
BindingContext = editVM;
this.vehicleMake = vehicleMake;
}
// Get single Vehicle Make from DB
public VehicleMake FindVehicleMake(int Id)
{
VehicleMake vehicleMake = new VehicleMake();
vehicleMake = db.VehicleMakes.Find(Id);
return(vehicleMake);
}
public async Task <IActionResult> Edit(VehicleMakeDTO vehicleMakeDTO)
{
VehicleMake make = Mapper.Map <VehicleMake>(vehicleMakeDTO);
await MakeService.UpdateAsync(make);
return(RedirectToAction(nameof(Index)));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Abrv")] VehicleMake vehicle)
{
if (id != vehicle.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
DbContext.Update(vehicle);
await DbContext.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VehicleMakeExists(vehicle.Id))
{
return(NotFound());
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(vehicle));
}
// Insert new Vehicle Make in DB
public void InsertVehicleMake(VehicleMake vehicleMake)
{
VehicleMake data = vehicleMake;
db.VehicleMakes.Add(data);
db.SaveChanges();
}
// Make
public async Task <ActionResult <VehicleMake> > CreateVehicleMake(VehicleMake newVehicleMake)
{
_context.VehicleMakes.Add(newVehicleMake);
await _context.SaveChangesAsync();
return(newVehicleMake);
}
public ActionResult Delete(int id)
{
VehicleMake vehicleMake = client.GetVehicleMakeId(id);
client.DeleteVehicleMake(vehicleMake);
return(RedirectToAction("Index"));
}
public async Task <int> UpdateVehicleMakeAsync(VehicleMake vehicleMake)
{
_db.Update(vehicleMake);
var numberOfChanges = await _db.SaveChangesAsync();
return(numberOfChanges);
}
public async Task <VehicleResponse <VehicleMake> > UpdateAsync(Guid id, VehicleMake vehicleMake)
{
var existingVehicleMake = await _vehicleMakeRepository.FindMakeByIdAsync(id);
if (existingVehicleMake == null)
{
return(new VehicleResponse <VehicleMake>("VehicleMake not found."));
}
existingVehicleMake.Name = vehicleMake.Name;
existingVehicleMake.Abrv = vehicleMake.Abrv;
try
{
await _vehicleMakeRepository.UpdateMakeAsync(existingVehicleMake);
await _unitOfWork.CompleteAsync();
return(new VehicleResponse <VehicleMake>(existingVehicleMake));
}
catch (Exception ex)
{
return(new VehicleResponse <VehicleMake>($"An error occurred when updating the vehicleMake: {ex.Message}"));
}
}
public async Task <int> CreateVehicleMakeAsync(VehicleMake vehicleMake)
{
_db.Add(vehicleMake);
var numberOfCreated = await _db.SaveChangesAsync();
return(numberOfCreated);
}
public async Task DeleteMake(Guid?id)
{
VehicleMake vehicle = await context.VehicleMakes.AsNoTracking().FirstOrDefaultAsync(p => p.Id == id);
context.VehicleMakes.Remove(vehicle);
await context.SaveChangesAsync();
}
public async Task UpdateMake(IVehicleMake vehicle)
{
VehicleMake update = mapper.Map <VehicleMake>(vehicle);
context.VehicleMakes.Update(update);
await context.SaveChangesAsync();
}
public async Task InsertMake(IVehicleMake vehicle)
{
VehicleMake create = mapper.Map <VehicleMake>(vehicle);
context.VehicleMakes.Add(create);
await context.SaveChangesAsync();
}
public static List <VehicleMake> GetVehicleMakes(string dataFile)
{
var list = new List <VehicleMake>();
var xmlDOC = new XmlDocument();
xmlDOC.Load(dataFile);
var nodeList = xmlDOC.DocumentElement.SelectNodes("/makes/make");
foreach (XmlNode node in nodeList)
{
try
{
int id = Int32.Parse(node.Attributes.GetNamedItem("id").InnerText);
string description = node.Attributes.GetNamedItem("description").InnerText;
var make = new VehicleMake()
{
ID = id,
Description = description
};
list.Add(make);
}
catch (Exception)
{
}
}
return(list);
}
public static Vehicle CreateVehicle(string vinNumber, VehicleMake make, string model, int year,
string color, int weight, decimal price, int miles)
{
Vehicle vehicle = null;
switch (make)
{
case VehicleMake.BMW:
vehicle = new VehicleBmw(vinNumber, make, model, year,
color, weight, price, miles);
break;
case VehicleMake.Subaru:
vehicle = new VehicleSubaru(vinNumber, make, model, year,
color, weight, price, miles);
break;
case VehicleMake.Tesla:
vehicle = new VehicleTesla(vinNumber, make, model, year,
color, weight, price, miles);
break;
case VehicleMake.Volkswagen:
vehicle = new VehicleVolkswagen(vinNumber, make, model, year,
color, weight, price, miles);
break;
default:
vehicle = new Vehicle(vinNumber, make, model, year,
color, weight, price, miles);
break;
}
return(vehicle);
}
/// <summary>
/// UPDATE VEHICLE MAKE
/// </summary>
/// <param name="UpdateVehicleMake"></param>
public async Task UpdateVehicleMakeAsync(VehicleMake UpdateVehicleMake)
{
if (UpdateVehicleMake != null)
{
await _repository.UpdateVehicleMakeAsync(AutoMapper.Mapper.Map <VehicleMakeEntity>(UpdateVehicleMake));
}
}
public void UpdateVehicleMake(int id, string name, string abrv, VehicleMake vehicleMake)
{
vehicleMake.name = name;
vehicleMake.abrv = abrv;
int itemIndex;
foreach (VehicleMake vm in lVehicleMake.ToList())
{
if (vm.id == id)
{
/*
* Nije radilo pa sam morao raditi na pokušaj iznad
*
* vm.name = name;
* vm.abrv = abrv;
*
*/
itemIndex = lVehicleMake.IndexOf(vm);
lVehicleMake.Remove(vm);
lVehicleMake.Insert(itemIndex, new VehicleMake(id, name, abrv));
}
}
lVehicleMake = new ObservableCollection <VehicleMake>(lVehicleMake);
}
public static void Initialize(VehicleContext context)
{
context.Database.EnsureCreated();
if (context.vehicleMakes.Any())
{
return;
}
var vehicleMake = new VehicleMake[]
{
new VehicleMake {
id = 1, name = "Audi", abrv = "Audi"
}
};
foreach (VehicleMake v in vehicleMake)
{
context.vehicleMakes.Add(v);
}
var vehicleModel = new VehicleModel[]
{
new VehicleModel {
id = 1, name = "audi", abrv = "audi"
}
};
foreach (VehicleModel a in vehicleModel)
{
context.vehicleModels.Add(a);
}
context.SaveChanges();
}
public void DeleteMake(int id)
{
VehicleMake m = _ctx.VehicleMakes.Find(id);
_ctx.VehicleMakes.Remove(m);
_ctx.SaveChanges();
}
public async Task <VehicleMake> AddVehicleMakeAsync(VehicleMake make)
{
_uow.VehicleMakes.Add(make);
await _uow.SaveChangesAsync();
return(make);
}
public void GetByName_ShouldReturnNeededMake()
{
string testName = "FoRd";
var makes = new List <VehicleMake>()
{
new VehicleMake()
{
Name = "Fiat"
},
new VehicleMake()
{
Name = "Mercedes"
},
new VehicleMake()
{
Name = "FORD", Id = 1
},
new VehicleMake()
{
Name = "Audi"
}
}.AsQueryable();
var repositoryMock = new Mock <IInternalDbRepository <VehicleMake> >();
repositoryMock.Setup(x => x.All()).Returns(() => makes);
VehicleMakesService service = new VehicleMakesService(repositoryMock.Object);
VehicleMake response = service.GetByName(testName);
Assert.AreEqual(response.Id, 1);
repositoryMock.VerifyAll();
}
/// <summary>
/// Get Vehicle Type record as per the recordid and UserID
/// Created By : Jasmine Kaur Sethi
/// Created On : 29 APR 2013
/// </summary>
/// <param name="RecordID"></param>
/// /// <param name="UserID"></param>
public VehicleMake GetVehicleMakeRecord(int recordID, string UserID)
{
VehicleMake ba = new VehicleMake();
SqlParameter[] Parameters = { new SqlParameter("@SNo", Convert.ToInt32(recordID)),
new SqlParameter("@UserID", Convert.ToInt32(UserID)) };
SqlDataReader dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordVehicleMake", Parameters);
if (dr.Read())
{
// DateTime? d = null;
ba.SNo = Convert.ToInt32(dr["SNo"]);
ba.vehiclemake = dr["vehiclemake"].ToString();
ba.Capacity = Convert.ToInt64(dr["Capacity"]);
ba.VehicleTypeSNo = dr["VehicleTypeSNo"].ToString();
ba.Text_VehicleTypeSNo = dr["vehicletype"].ToString();
ba.IsActive = Convert.ToBoolean(dr["IsActive"]);
ba.Active = dr["Active"].ToString();
ba.CreatedUser = dr["CreatedUser"].ToString();
ba.UpdatedUser = dr["UpdatedUser"].ToString();
}
dr.Close();
return(ba);
}
public void EditVehicleMake(ViewVehicleMake viewVehicleMake)
{
VehicleMake vehicleMakes = Db.VehicleMakes.Find(viewVehicleMake.VehicleMakeId);
Mapper.Map(viewVehicleMake, vehicleMakes);
Db.SaveChanges();
}
public void DeleteVehicleMake(Guid?id)
{
VehicleMake vehicleMakes = Db.VehicleMakes.Find(id);
Db.VehicleMakes.Remove(vehicleMakes);
Db.SaveChanges();
}
public override int GetHashCode()
{
unchecked
{
int hashCode = base.GetHashCode();
hashCode = (hashCode * 397) ^ (VIN != null ? VIN.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (VehicleMake != null ? VehicleMake.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (VehicleModel != null ? VehicleModel.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (TyreSize != null ? TyreSize.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (VehicleType != null ? VehicleType.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (WFactor != null ? WFactor.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (KFactor != null ? KFactor.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (LFactor != null ? LFactor.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (OdometerReading != null ? OdometerReading.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ Tampered.GetHashCode();
hashCode = (hashCode * 397) ^ (InvoiceNumber != null ? InvoiceNumber.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (InspectionInfo != null ? InspectionInfo.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ TachographHasAdapter.GetHashCode();
hashCode = (hashCode * 397) ^ (TachographAdapterSerialNumber != null ? TachographAdapterSerialNumber.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (TachographAdapterLocation != null ? TachographAdapterLocation.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (TachographCableColor != null ? TachographCableColor.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (MinorWorkDetails != null ? MinorWorkDetails.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (TachographType != null ? TachographType.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (CardSerialNumber != null ? CardSerialNumber.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ CalibrationTime.GetHashCode();
hashCode = (hashCode * 397) ^ IsDigital.GetHashCode();
hashCode = (hashCode * 397) ^ NewBattery.GetHashCode();
hashCode = (hashCode * 397) ^ (NewInspectionInfo != null ? NewInspectionInfo.GetHashCode() : 0);
return(hashCode);
}
}
public void DeleteVehicleMake(Guid id)
{
VehicleMake vehicleMake = db.VehicleMakes.Find(id);
db.VehicleMakes.Remove(vehicleMake);
db.SaveChanges();
}
public void DeleteVehicleMake(int id)
{
VehicleMake Make = context.VehicleMakes.Find(id);
context.VehicleMakes.Remove(Make);
context.SaveChanges();
}
public async Task <VehicleMake> CreateMakeAsync(VehicleMake newMake)
{
context.VehicleMakes.Add(newMake);
await context.SaveChangesAsync();
return(newMake);
}
public static void Main(string[] args)
{
var host = CreateWebHostBuilder(args).Build();
using (var serviceScope = host.Services.CreateScope())
{
var context = serviceScope.ServiceProvider.GetRequiredService <VehicleContext>();
context.Database.Migrate();
}
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
// Requires using RazorPagesMovie.Models;
var context = services.GetService <VehicleContext>();
if (context.Vehicles.Count() == 0)
{
context.Add(new VehicleMake
{
Name = "Renault",
Abrv = "REN",
});
context.Add(new VehicleMake
{
Name = "Ford",
Abrv = "FOR",
});
context.Add(new VehicleMake
{
Name = "Citroen",
Abrv = "CIT",
});
var peugot = new VehicleMake
{
Name = "Peugeot",
Abrv = "PEU",
};
context.Add(peugot);
context.VehicleModels.Add(new VehicleModel
{
Name = "3008",
Abrv = "3008",
VehicleMakeId = peugot.Id
});
}
context.SaveChanges();
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred seeding the DB.");
}
}
host.Run();
}
