public string AddVehicleMake(VehicleMake vehicleMake) { string result = ""; try { SqlCommand cmd = new SqlCommand(); string Query = @"INSERT INTO VehicleMake (Name,Abrv) Values(@Name,@Abrv)"; cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@Name", vehicleMake.Name); cmd.Parameters.AddWithValue("@Abrv", vehicleMake.Abrv); con.Open(); cmd.ExecuteNonQuery(); con.Close(); result = "Record Added Successfully !"; } catch (FaultException fex) { throw new FaultException <string>("Error: " + fex); } return(result); }
// delete public void DeleteVehicleMake(int id) { VehicleMake vehicleMake = db.VehicleMake.Find(id); db.VehicleMake.Remove(vehicleMake); db.SaveChanges(); }
public void DeleteMake(Guid id) { VehicleMake vehicleMake = db.VehiclMakes.Find(id); db.VehiclMakes.Remove(vehicleMake); db.SaveChanges(); }
public VehicleMake DeleteVehicleMake(int makeId) { VehicleMake make = context.VehicleMakers.Find(makeId); if (make != null) { context.Remove(make); context.SaveChanges(); } return(make); }
public VehicleMake GetVehicleMakeId(int?id) { var vehicleMake = from vma in _db.VehicleMakes where vma.Id == id select vma; VehicleMake vehicleMakes = new VehicleMake(); foreach (var item in vehicleMake) { vehicleMakes.Id = item.Id; vehicleMakes.Name = item.Name; vehicleMakes.Abrv = item.Abrv; } return(vehicleMakes); }
public string DeleteVehicleMake(VehicleMake vehicleMake) { string result = ""; SqlCommand cmd = new SqlCommand(); string Query = "DELETE FROM VehicleMake Where Id=@Id"; cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@Id", vehicleMake.Id); con.Open(); cmd.ExecuteNonQuery(); con.Close(); result = "Record Deleted Successfully!"; return(result); }
public void SaveVehicleMake(VehicleMake vehicleMake) { if (vehicleMake.Id == 0) { context.Add(vehicleMake); context.SaveChanges(); } else { var vehicle = context.VehicleMakers.Attach(vehicleMake); vehicle.State = Microsoft.EntityFrameworkCore.EntityState.Modified; context.SaveChanges(); } }
public bool RemoveMake(int?Id) { VehicleMake vm = this.db.VehicleMakes.Find(Id); var result = (from r in this.db.VehicleModels where r.VehicleMakeId == Id select r).FirstOrDefault(); if (result == null) { this.db.VehicleMakes.Remove(vm); this.db.SaveChanges(); return(true); } return(false); }
public string UpdateVehicleMake(VehicleMake vehicleMake) { string result = ""; SqlCommand cmd = new SqlCommand(); string Query = "UPDATE VehicleMake SET Abrv=@Abrv,Name=@Name WHERE Id=@Id"; cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@Id", vehicleMake.Id); cmd.Parameters.AddWithValue("@Name", vehicleMake.Name); cmd.Parameters.AddWithValue("@Abrv", vehicleMake.Abrv); con.Open(); cmd.ExecuteNonQuery(); result = "Record Updated Successfully !"; con.Close(); return(result); }
public async Task <VehicleMake> UpdateAsync(VehicleMake updatedItem) { var updatedItemEntity = await repository.UpdateAsync(mapper.Map <VehicleMakeEntity>(updatedItem)); return(mapper.Map <VehicleMake>(updatedItemEntity)); //var item = repository.repository.context.VehicleMakes.Update(mapper.Map<VehicleMakeEntity>(updatedItem)); //item.State = EntityState.Modified; //await repository.repository.context.SaveChangesAsync(); //return updatedItem; //var existingItem = await repository.GetAsync((mapper.Map<VehicleMakeEntity>(updatedItem)).Id); //repository.repository.context.Update(existingItem); //repository.repository.context.SaveChanges(); //return mapper.Map<VehicleMake>(existingItem); }
// create public void CreateVehicleMake(VehicleMake vehicleMake) { db.VehicleMake.Add(Mapper.Map <VehicleMake>(vehicleMake)); db.SaveChanges(); }
public bool AddMaker(VehicleMake maker) { context.Makers.Add(maker); return(Convert.ToBoolean(context.SaveChanges())); }
public async Task UpdateAsync(VehicleMake vehicleMake) { await _repository.UpdateAsync(vehicleMake); }
public async Task InsertAsync(VehicleMake vehicleMake) { await _repository.InsertAsync(vehicleMake); }
public void Detach(VehicleMake item) { throw new NotImplementedException(); }
public async Task <VehicleMake> CreteAsync(VehicleMake newItem) { var newItemEntity = await repository.CreteAsync(mapper.Map <VehicleMakeEntity>(newItem)); return(mapper.Map <VehicleMake>(newItemEntity)); }
public void InsertVehicleMake(VehicleMake make) { _context.VehicleMakes.Add(make); _context.SaveChanges(); }
public async Task <int> CreateAsync(VehicleMake vehicleMake) { return(await VehicleMakeRepository.InsertAsync(vehicleMake)); }
public async Task <int> UpdateAsync(VehicleMake vehicleMake) { return(await VehicleMakeRepository.UpdateAsync(vehicleMake)); }
public VehicleMakeVM FindVehicleMake(Guid id) { VehicleMake vehicleMake = db.VehiclMakes.Find(id); return(Mapper.Map <VehicleMakeVM>(vehicleMake));//mapping iz source(vehicleMake model) u VehicleMakeViewModel }
// update public void UpdateVehicleMake(VehicleMake vehicleMake) { db.Set <VehicleMake>().AddOrUpdate(Mapper.Map <VehicleMake>(vehicleMake)); db.SaveChanges(); }
public void Add(VehicleMake vehicleMake) { this.db.VehicleMakes.Add(vehicleMake); this.db.SaveChanges(); }
public void UpdateVehicleMake(VehicleMake make) { throw new NotImplementedException(); }
public void Edit(VehicleMake vehicleMake) { this.db.Entry(vehicleMake).State = EntityState.Modified; this.db.SaveChanges(); }