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 }));
}
}
