private string InsertHotel(OTA_HotelDescriptiveInfoRS.HotelDescriptiveContentsLocalType.HotelDescriptiveContentLocalType hotel)
{
string returnVal = string.Empty;
using (var context = new TravelDBContext())
{
Hotel h = null;
int hotelCode = Convert.ToInt32(hotel.HotelCode);
var isHas = (from e in context.Hotels where e.HotelCode == hotelCode select e).ToList();
if (isHas.Count > 0)
{
returnVal = isHas[0].Id;
h = isHas[0];
}
else
{
h = new Hotel();
h.Id = CommonUtil.GetHotelID(hotelCode);
}
h.BrandCode = Convert.ToInt32(hotel.BrandCode);
h.LastMofifyTime = DateTime.Now;
h.AreaID = Convert.ToInt32(hotel.AreaID);
h.HotelCityCode = Convert.ToInt32(hotel.HotelCityCode);
h.HotelCode = Convert.ToInt32(hotel.HotelCode);
h.HotelName = hotel.HotelName;
var hoteinfo = hotel.HotelInfo;
if (Check(hoteinfo))
{
if (hoteinfo[0].LastUpdated != null)
{
h.LastUpdated = Convert.ToDateTime(hoteinfo[0].LastUpdated);
}
else
{
h.LastUpdated = null;
}
if (hoteinfo[0].WhenBuilt != null)
{
h.WhenBuilt = Convert.ToDateTime(hoteinfo[0].WhenBuilt);
}
else
{
h.WhenBuilt = null;
}
}
if (isHas.Count == 0)
{
returnVal = context.Hotels.Add(h).Id;
}
context.SaveChanges();
LoggerHelper(hotelCode.ToString(), "HotelName : " + h.HotelName + ",Updated/Inserted");
return(returnVal);
}
}
public IActionResult InsertUpdateTravelData([FromBody] TravelDataModel travelDataInput)
{
try
{
var travelDb = new TravelDBContext();
if (travelDb.TravelData.Where(td => td.TravelId == travelDataInput.TravelId).Any())
{
//Si no esta la persona (unico por pasaporte) entonces lo agrego, sino lo actualizo
if (!travelDb.TravelData.Where(td => td.TravelId == travelDataInput.TravelId && td.Passport == travelDataInput.Passport).Any())
{
//Agregar
travelDb.TravelData.Add(Mapper.Map(travelDataInput));
travelDb.SaveChanges();
SendEmailToCompleteInsertOrUpdate(travelDataInput);
return(Ok());
}
else
{
//Actualizar
var traveldataToUpdate = travelDb.TravelData.Where(td => td.TravelId == travelDataInput.TravelId && td.Passport == travelDataInput.Passport).SingleOrDefault();
traveldataToUpdate.PassengerName = travelDataInput.PassengerName;
traveldataToUpdate.Birthdate = travelDataInput.Birthdate;
traveldataToUpdate.Email = travelDataInput.Email;
travelDb.SaveChanges();
SendEmailToCompleteInsertOrUpdate(travelDataInput);
return(Ok());
}
}
else
{
return(Ok("No existe el viaje"));
}
}
catch (Exception ex)
{
return(NotFound(ex));
}
}
public IActionResult DeleteTravelData([FromBody] TravelDataDeleteInputParamModel travelDataInput)
{
try
{
var travelDb = new TravelDBContext();
travelDb.TravelData.Remove(new TravelDatum()
{
Id = travelDataInput.TravelDataId
});
travelDb.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(NotFound(ex));
}
}
public string Upload(IFormFile uploadFile, int idTour)
{
string result = "";
try
{
if (uploadFile != null || uploadFile.Length != 0)
{
var path = Path.Combine(Directory.GetCurrentDirectory(), @"wwwroot\images", uploadFile.FileName);
using (var stream = new FileStream(path, FileMode.Create))
{
uploadFile.CopyToAsync(stream);
}
Tour tour = travelDB.Tour.FirstOrDefault(t => t.Id == idTour);
Hotel hotel = travelDB.Hotel.FirstOrDefault(h => h.Id == tour.IdHotel);
Picture newPicture = new Picture
{
NamePicture = "../images/" + uploadFile.FileName,
IdHotel = hotel.Id
};
travelDB.Picture.Add(newPicture);
travelDB.SaveChanges();
hotel.IdPicture = newPicture.Id;
travelDB.SaveChanges();
result = "The picture is added!";
}
else
{
result = "The picture is NOT added!!";
}
}
catch (Exception ex)
{
result = "The picture is NOT added!!";
}
return(result);
}
