public ActionResult Post([FromBody] AddFoodAmenitiesViewModel addFood) { try { string Name = _context.BaseTable.Where(item => item.Name == addFood.Name).Select(item => item.Name).FirstOrDefault(); if (Name == null) { BaseTable baseEntry = _mapper.Map <BaseTable>(addFood); FoodAmenities foodAmenities = _mapper.Map <FoodAmenities>(addFood); baseEntry.CategoryId = 3; var result = _context.BaseTable.Add(baseEntry); _context.SaveChanges(); var getData = result.Entity; Guid Id = getData.ID; foodAmenities.Id = Id; _context.FoodAmenities.Add(foodAmenities); _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] AddFoodAmenitiesViewModel updateFood, [FromQuery] Guid Id) { if (ModelState.IsValid) { if (updateFood == null) { return(BadRequest()); } BaseTable getBaseData = _context.BaseTable.FirstOrDefault(item => item.ID == Id); if (getBaseData == null) { return(NotFound()); } FoodAmenities foodAmenities = _mapper.Map <FoodAmenities>(updateFood); BaseTable baseTable = _mapper.Map <BaseTable>(updateFood); baseTable.ID = getBaseData.ID; foodAmenities.Id = getBaseData.ID; _context.Entry(baseTable).State = EntityState.Modified; _context.Entry(foodAmenities).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 })); } }