public ActionResult Post([FromBody] AddAccommodationAmenitiesViewModel addAccommodation) { try{ string Name = _context.BaseTable.Where(item => item.Name == addAccommodation.Name).Select(item => item.Name).FirstOrDefault(); if (Name == null) { BaseTable baseEntry = _mapper.Map <BaseTable>(addAccommodation); AccommodationAmenities accommodationAmenities = _mapper.Map <AccommodationAmenities>(addAccommodation); baseEntry.CategoryId = 4; var result = _context.BaseTable.Add(baseEntry); _context.SaveChanges(); BaseTable getData = result.Entity; Guid Id = getData.ID; accommodationAmenities.Id = Id; _context.AccommodationAmenities.Add(accommodationAmenities); _context.SaveChanges(); } else { return(BadRequest("Failed to Add Duplicate Data")); } } catch (Exception) { return(BadRequest("Failed to Add Accomodation Data")); } return(Ok("Successfully Posted")); }
public ActionResult Put([FromBody] AddAccommodationAmenitiesViewModel updateAccommodation, [FromQuery] Guid Id) { if (ModelState.IsValid) { if (updateAccommodation == null) { return(BadRequest()); } BaseTable getBaseData = _context.BaseTable.FirstOrDefault(item => item.ID == Id); if (getBaseData == null) { return(NotFound()); } AccommodationAmenities accommodationAmenities = _mapper.Map <AccommodationAmenities>(updateAccommodation); BaseTable baseTable = _mapper.Map <BaseTable>(updateAccommodation); baseTable.ID = getBaseData.ID; accommodationAmenities.Id = getBaseData.ID; _context.Entry(baseTable).State = EntityState.Modified; _context.Entry(accommodationAmenities).State = EntityState.Modified; return(Ok("Updated Successfull")); } return(BadRequest()); }
public ActionResult GetEntity([FromQuery] string PlaceName, [FromQuery] int Id) { try { BaseTable row = _authenticationContext.BaseTable.Where(c => c.Name == PlaceName && c.CategoryId == Id).FirstOrDefault(); if (row != null) { Guid entityId = row.ID; if (Id == 1) { AddTouristsEntryViewModel getTourists = new AddTouristsEntryViewModel(); _amenities = _authenticationContext.TouristsAmenities.FirstOrDefault(data => data.Id == entityId); getTourists = _mapper.Map <AddTouristsEntryViewModel>(_amenities); _amenities = getTourists; } else if (Id == 2) { AddActivitiesAmenitiesViewModel activities = new AddActivitiesAmenitiesViewModel(); _amenities = _authenticationContext.ActivitiesAmenities.FirstOrDefault(data => data.Id == entityId); activities = _mapper.Map <AddActivitiesAmenitiesViewModel>(_amenities); _amenities = activities; } else if (Id == 3) { AddFoodAmenitiesViewModel getFood = new AddFoodAmenitiesViewModel(); _amenities = _authenticationContext.FoodAmenities.FirstOrDefault(data => data.Id == entityId); getFood = _mapper.Map <AddFoodAmenitiesViewModel>(_amenities); _amenities = getFood; } else { AddAccommodationAmenitiesViewModel getAccommodation = new AddAccommodationAmenitiesViewModel(); _amenities = _authenticationContext.AccommodationAmenities.FirstOrDefault(data => data.Id == entityId); getAccommodation = _mapper.Map <AddAccommodationAmenitiesViewModel>(_amenities); _amenities = getAccommodation; } var images = _authenticationContext.EnitityImages.Where(c => c.EntityID == entityId).Select(d => d.Image).ToList(); List <Object> imageList = new List <Object>(); if (images != null) { foreach (byte[] image in images) { FileResult data = File(image, "image/png", $"Image"); imageList.Add(data); //var base64 = Convert.ToBase64Strin g(image, 0, image.Length); //var imgsrc = string.Format("data: image/png ; base64{0},",base64); //imageList.Add(imgsrc); } } var Result = new Dictionary <string, Object>(); Result.Add("Details", row); Result.Add("Images", imageList); Result.Add("Amenities", _amenities); return(Ok(Result)); } else { return(BadRequest(new { message = "No such entry in database" })); } } catch (Exception ex) { return(BadRequest(new { message = ex.Message })); } }