internal static TaxiServiceModel CreateTaxiService(TaxiServiceEntity service) { try { using (SriLankaToursEntities context = new SriLankaToursEntities()) { bool isServiceExists = context.TaxiServiceEntities.Any(x => (x.FromId == service.FromId) && (x.ToId == service.ToId) && (x.VehicleId == service.VehicleId)); if (isServiceExists) throw new TaxiServiceExistsException("Taxi service already exists"); context.TaxiServiceEntities.Add(service); context.SaveChanges(); vTaxiService view = context.vTaxiServices.First(x => x.ServiceId == service.ServiceId); Mapper.CreateMap<vTaxiService, TaxiServiceModel>(); return Mapper.Map<TaxiServiceModel>(view); } } catch (Exception) { throw; } }
internal static TaxiServiceModel UpdateTaxiService(TaxiServiceEntity service) { try { using (SriLankaToursEntities context = new SriLankaToursEntities()) { bool isServiceExists = context.TaxiServiceEntities.Any(x => (x.FromId == service.FromId) && (x.ToId == service.ToId) && (x.VehicleId == service.VehicleId) && (x.ServiceId != service.ServiceId)); if (isServiceExists) throw new TaxiServiceExistsException("Taxi service already exists"); TaxiServiceEntity entity = context.TaxiServiceEntities.Find(service.ServiceId); entity.Price = service.Price; entity.Visible = service.Visible; entity.FromId = service.FromId; entity.ToId = service.ToId; entity.UpdatedBy = service.UpdatedBy; entity.UpdatedOn = service.UpdatedOn; context.SaveChanges(); return GetTaxiService(entity.ServiceId); } } catch (Exception) { throw; } }