public ResultResponse <PlacaResponse> getByPlaca(PapeletaVirtualDBContext _context, string numplaca) { try { ResultResponse <PlacaResponse> response = new ResultResponse <PlacaResponse>(); var firstresult = _context.Placa.Any(x => x.NumPlaca == numplaca); if (firstresult) { var result = _context.Placa.FirstOrDefault(x => x.NumPlaca == numplaca); PlacaResponse placaResponse = new PlacaResponse { Id = result.Id, CarBrand = result.CarBrand, CarModel = result.CarModel, ReleaseDate = result.ReleaseDate, TransportDetails = result.TransportDetails, NumPlaca = result.NumPlaca }; response.Data = placaResponse; response.Error = false; response.Message = "Datos encontrados"; } else { response.Data = null; response.Error = true; response.Message = "Datos no encontrados"; } return(response); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ResultResponse <PlacaResponse> AddPlaca(PapeletaVirtualDBContext _context, PlacaEntity model) { try { PlacaResponse placaResponseforAdd; ResultResponse <PlacaResponse> response = new ResultResponse <PlacaResponse>(); if (model == null) { response.Data = null; response.Error = true; response.Message = "Completar todos los campos"; return(response); } if (_context.Placa.Any(x => x.NumPlaca == model.NumPlaca)) { response.Data = null; response.Error = true; response.Message = "El nĂºmero de Placa ya existe"; return(response); } else { using (var ts = new TransactionScope()){ Models.Placa placa = new Models.Placa(); _context.Placa.Add(placa); placa.CarBrand = model.CarBrand; placa.CarModel = model.CarModel; placa.TransportDetails = model.TransportDetails; placa.NumPlaca = model.NumPlaca; _context.SaveChanges(); ts.Complete(); response.Data = null; response.Error = false; response.Message = "Placa registrada"; } var result = _context.Placa.FirstOrDefault(x => x.NumPlaca == model.NumPlaca); placaResponseforAdd = new PlacaResponse { Id = result.Id, CarBrand = result.CarBrand, CarModel = result.CarModel, ReleaseDate = result.ReleaseDate, TransportDetails = result.TransportDetails, NumPlaca = result.NumPlaca }; response.Data = placaResponseforAdd; response.Error = false; response.Message = "Placa registrada"; } return(response); } catch (Exception ex) { throw new System.Exception(ex.Message); } }