public async Task <ActionResult <Tourist> > PostTourist(Tourist tourist)
{
var isTouristExist = await _context.Tourist.AnyAsync(x => x.Email == tourist.Email);
if (isTouristExist)
{
return(StatusCode(StatusCodes.Status409Conflict, $"Tourist with email address {tourist.Email} is already exists."));
}
_context.Tourist.Add(tourist);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTourist", new { id = tourist.Id }, tourist));
}
// GET: Tourists/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tourist tourist = db.Tourists.Find(id);
if (tourist == null)
{
return(HttpNotFound());
}
return(View(tourist));
}
internal void SetPlan(Location location, Tourist tourist, Guide guide, DateTime datetime)
{
Plan p = db.Plans.Where(a => a.ArrivalDateInTurkey == datetime && a.Guide.Name == guide.Name && a.Guide.Surname == guide.Surname && a.Tourist.Name == tourist.Name && a.Tourist.Surname == tourist.Surname && a.Location.LocationDescription == location.LocationDescription).FirstOrDefault();
if (p == null)
{
p = new Plan();
p.GuideID = db.Guides.Where(a => a.Name == guide.Name && a.Surname == guide.Surname).Select(a => a.GuideID).FirstOrDefault();
p.LocationID = db.Locations.Where(a => a.LocationDescription == location.LocationDescription).Select(a => a.LocationID).FirstOrDefault();
p.TouristID = db.Tourists.Where(a => a.Name == tourist.Name && a.Surname == tourist.Surname && a.BirthDate == tourist.BirthDate).Select(a => a.TouristID).FirstOrDefault();
p.ArrivalDateInTurkey = datetime;
db.Plans.Add(p);
db.SaveChanges();
}
}
public ActionResult Delete(int ID, Tourist tourist)
{
try
{
// TODO: Add delete logic here
tourist = db.Tourists.Where(c => c.ID == ID).FirstOrDefault();
db.Tourists.Remove(tourist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(ID));
}
}
public ActionResult Create(Tourist tourist)
{
try
{
db.Tourists.Add(tourist);
db.SaveChanges();
// TODO: Add insert logic here
return(RedirectToAction("Index", "tourist"));
}
catch
{
return(View(tourist));
}
}
public string Loging([FromBody] Tourist user)
{
using (thanujaEntities db = new thanujaEntities())
{
var login = db.Tourists.Where(u => u.UserName == user.UserName).FirstOrDefault();
if (login.Password == user.Password)
{
return("loging success");
}
else
{
return("LOGING FAILED");
}
}
}
// GET: Tourists/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tourist tourist = db.Tourists.Find(id);
if (tourist == null)
{
return(HttpNotFound());
}
var Results = from f in db.Flights
select new
{
f.FlightId,
f.Name,
Checked = ((from tf in db.TouristsToFlights
where (tf.TouristId == id) & (tf.FlightId == f.FlightId)
select tf).Count() > 0)
};
var MyViewModel = new TouristsViewModel();
MyViewModel.TouristId = id.Value;
MyViewModel.FirstName = tourist.FirstName;
MyViewModel.LastName = tourist.LastName;
MyViewModel.Gender = tourist.Gender;
MyViewModel.Country = tourist.Country;
MyViewModel.Remarks = tourist.Remarks;
MyViewModel.DateOfBirth = tourist.DateOfBirth;
var MyCheckBoxList = new List <CheckBoxViewModel>();
foreach (var item in Results)
{
MyCheckBoxList.Add(new CheckBoxViewModel
{
Id = item.FlightId,
Name = item.Name,
Checked = item.Checked
});
}
MyViewModel.Flights = MyCheckBoxList;
return(View(MyViewModel));
}
public void TestGetByIdBookingsOK()
{
Tourist tourist = new Tourist
{
Email = "*****@*****.**",
Id = 1,
Name = "s",
LastName = "b"
};
Accommodation accommodation = new Accommodation
{
Id = 5,
Name = "a",
Address = "a",
ContactNumber = "2"
};
Booking booking = new Booking
{
Id = 5,
TotalPrice = 10,
CheckIn = DateTime.Now.AddDays(1),
CheckOut = DateTime.Now.AddDays(2),
HeadGuest = tourist,
Accommodation = accommodation
};
Guest guest = new Guest
{
Amount = 1,
Multiplier = 1
};
List <Guest> guestList = new List <Guest>
{
guest,
guest,
guest
};
booking.Guests = guestList;
var mockBooking = new Mock <IBookingLogic>(MockBehavior.Strict);
mockBooking.Setup(p => p.GetById(It.IsAny <int>())).Returns(booking);
var controller = new BookingController(mockBooking.Object);
var result = controller.Get(5) as OkObjectResult;
mockBooking.VerifyAll();
Assert.AreEqual(200, result.StatusCode);
}
public void TestInitialize()
{
var lodging = new Lodging()
{
Id = 1,
Name = "Name",
Description = "Description",
Rating = 3,
IsFull = true,
Images = new List <LodgingImage>()
{
new LodgingImage()
},
PricePerNight = 100,
Address = "Valid Address 123",
Phone = "+598 98 303 040",
ConfirmationMessage = "Your reservation has been confirmed!",
TouristSpot = null
};
var tourist = new Tourist()
{
Name = "aName",
LastName = "aLastName",
Email = "*****@*****.**"
};
var booking = new Booking()
{
Id = 1,
CheckIn = DateTime.Now,
CheckOut = DateTime.Now.AddDays(5),
Lodging = lodging,
Guests = 3,
Tourist = tourist,
};
BookingState = new BookingState
{
Id = 1,
Booking = booking,
BookingId = booking.Id,
State = "Aceptada",
Description = "Primer estado"
};
BookingStateBasicInfoModel = new BookingStateBasicInfoModel(BookingState);
}
public ActionResult <Tourist> Create([FromBody] Tourist tourist)
{
if (string.IsNullOrWhiteSpace(tourist.Fio))
{
ModelState.AddModelError("Name", "Tour name must be non empty string");
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var newTourist = repository.Create(tourist);
return(Ok(newTourist));
}
public bool CheckEmailExist(string TouristEmail)
{
bool result;
Tourist tour = new Tourist();
tour = (from c in entity.Tourists where c.TouristEmail == TouristEmail select c).SingleOrDefault();
if (tour != null)
{
result = true;
}
else
{
result = false;
}
return(result);
}
public JsonResult Insert(Tourist tourist)
{
if (tourist != null)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
db.Tourists.Add(tourist);
db.SaveChanges();
return(Json(new { success = true }));
}
}
else
{
return(Json(new { success = false }));
}
}
public void SetTourist(Tourist tourist, Nationality nationality, Gender gender)
{
Tourist t = db.Tourists.Where(a => a.Name == tourist.Name & a.Surname == tourist.Surname & a.BirthDate == tourist.BirthDate & a.Nationality.NationalityDescription == nationality.NationalityDescription & a.Gender.GenderDescription == gender.GenderDescription).FirstOrDefault();
if (t == null)
{
t = new Tourist();
t.Name = tourist.Name;
t.Surname = tourist.Surname;
t.BirthDate = tourist.BirthDate;
t.NationalityID = db.Nationalities.Where(a => a.NationalityDescription == nationality.NationalityDescription).Select(a => a.NationalityID).FirstOrDefault();
t.GenderID = db.Genders.Where(a => a.GenderDescription == gender.GenderDescription).Select(a => a.GenderID).FirstOrDefault();
db.Tourists.Add(t);
db.SaveChanges();
}
}
public void TestAddTourist()
{
Tourist tourist = new Tourist()
{
Id = 3,
Name = "Pepe",
LastName = "Lopez",
Email = "*****@*****.**",
Bookings = null,
};
var repository = new TouristRepository(_context);
repository.AddAndSave(tourist);
Assert.AreEqual(_context.Find <Tourist>(3), tourist);
}
public void TestAddBooking()
{
List <AccommodationImage> list = new List <AccommodationImage>();
AccommodationImage image = new AccommodationImage()
{
AccommodationId = 1,
Image = "a"
};
list.Add(image);
Accommodation accommodation = new Accommodation()
{
Id = 1,
Name = "a",
Address = "d",
ContactNumber = "a",
Images = list
};
this._context.Accommodations.Add(accommodation);
Booking booking = new Booking()
{
Id = 1,
Accommodation = null,
AccommodationId = 1,
BookingHistory = null,
CheckIn = DateTime.Now,
CheckOut = DateTime.Now.AddDays(7),
GuestId = 6,
Guests = new List <Guest>(),
HeadGuest = null,
TotalPrice = 142
};
Tourist tourist = new Tourist()
{
Email = "*****@*****.**",
LastName = "a",
Name = "a"
};
booking.HeadGuest = tourist;
var repository = new BookingRepository(_context);
repository.AddAndSave(booking);
Assert.AreEqual(_context.Find <Booking>(1), booking);
}
public void DeactivateAllExpiredHost()
{
var host = (from c in entity.Hosts where c.HostingStopTime < DateTime.Now && c.HostingStatus == true select c).ToList();
foreach (var item in host)
{
item.HostingStatus = false;
bool result = (from c in entity.Hosts where c.TouristId == item.TouristId && c.HostingStopTime >= DateTime.Now select c).Any();
if (result == false)
{
Tourist tourist =
(from c in entity.Tourists where c.TouristId == item.TouristId select c).FirstOrDefault();
tourist.TouristsHostStatus = false;
}
}
entity.SaveChanges();
}
public ActionResult DeleteConfirmed(int id)
{
if (System.Web.HttpContext.Current.Session["CurrentUser"] is ConnectedWorker)
{
if ((System.Web.HttpContext.Current.Session["CurrentUser"] as ConnectedWorker).Power == 2 ||
(System.Web.HttpContext.Current.Session["CurrentUser"] as ConnectedWorker).Power == 1)
{
try
{
Tourist tourist = db.Tourists.Find(id);
List <Tourist> livingInCurrentRoom = db.Tourists.AsNoTracking().Where(c => c.RoomId == tourist.RoomId).Select(c => c).ToList();
if (livingInCurrentRoom.Count - 1 == 0)
{
Room room = db.Rooms.Find(tourist.RoomId);
room.IsAvailable = true;
db.Entry(room).State = EntityState.Modified;
db.SaveChanges();
}
if (tourist == null)
{
return(HttpNotFound());
}
db.Tourists.Remove(tourist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
else
{
return(HttpNotFound());
}
}
else
{
return(HttpNotFound());
}
}
internal static void CheckClientDefault()
{
var Turistdb = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db));
var userTurist = Turistdb.FindByName("*****@*****.**");
if (userTurist == null)
{
CreateUserASP("*****@*****.**", "Turista123", "Tourist");
userTurist = Turistdb.FindByName("*****@*****.**");
var Tourist = new Tourist
{
UserId = userTurist.Id,
};
db.Tourists.Add(Tourist);
db.SaveChanges();
}
}
public void DeactivateHost(int HostId)
{
Host host = (from c in entity.Hosts where c.HostId == HostId select c).FirstOrDefault();
int touristId = Convert.ToInt32(host.TouristId);
host.HostingStatus = false;
entity.SaveChanges();
bool Result = (from c in entity.Hosts where c.TouristId == touristId && c.HostingStatus == true select c).Any();
if (Result == false)
{
Tourist tourist =
(from c in entity.Tourists where c.TouristId == touristId select c).FirstOrDefault();
tourist.TouristsHostStatus = false;
entity.SaveChanges();
}
}
//Adds new tourist in the database
public string RegisterTourist(string touristFirstName, string touristLastName, int age, string countryName)
{
Tourist tourist = new Tourist()
{
TouristFirstName = touristFirstName,
TouristLastName = touristLastName,
Age = age,
CountryName = countryName
};
context.Tourists.Add(tourist);
context.SaveChanges();
string result = "Tourist successfully registered.";
return(result);
}
public void Delete(TouristBindingModel model)
{
using (var context = new TourFirmDatabase())
{
Tourist element = context.Tourists.FirstOrDefault(rec => rec.ID == model.ID);
if (element != null)
{
context.Tourists.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Элемент не найден");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
TID.Text = Session["tourID"].ToString();
String tourID = Session["tourID"].ToString();
Booking b = new Booking();
Tourist t = new Tourist();
String reader = b.getBookingTuples(tourID);
String[] readerArr = reader.Split(';'); // contains array of tourist IDs
// for each tourist ID, query the tourist database and return name and country
Array.Resize(ref readerArr, readerArr.Length - 1);
for (int i = 0; i < readerArr.Length; i++)
{
String touristID = readerArr[i].ToString();
String touristInfo = t.queryTourist(touristID);
String[] touristInfoArr = touristInfo.Split(';');
Array.Resize(ref touristInfoArr, touristInfoArr.Length - 1);
LinkButton s = new LinkButton();
s.Text = touristInfoArr[0].ToString();
s.Click += new EventHandler(goToTourist);
TableRow detailsRow = new TableRow();
TableCell tgidCell = new TableCell();
tgidCell.Controls.Add(s);
detailsRow.Cells.Add(tgidCell);
TableCell tidCell = new TableCell();
tidCell.Text = touristInfoArr[1].ToString();
detailsRow.Cells.Add(tidCell);
TableCell userCell = new TableCell();
userCell.Text = touristInfoArr[2].ToString();
detailsRow.Cells.Add(userCell);
viewTRListTable.Rows.Add(detailsRow);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Tourist tr = new Tourist(Session["username"].ToString());
String reader = tr.viewUpcomingToursTR();
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
int tuple_length = readerArr.Length + 1;
int loops = tuple_length / 4;
int count = 0;
for (int i = 0; i < loops; i++)
{
LinkButton s = new LinkButton();
s.Text = readerArr[count].ToString();
s.Click += new EventHandler(setBookingId);
TableRow detailsRow = new TableRow();
TableCell tgidCell = new TableCell();
tgidCell.Controls.Add(s);
detailsRow.Cells.Add(tgidCell);
count += 1;
TableCell tidCell = new TableCell();
tidCell.Text = readerArr[count].ToString();
detailsRow.Cells.Add(tidCell);
count += 1;
TableCell userCell = new TableCell();
userCell.Text = readerArr[count].ToString();
detailsRow.Cells.Add(userCell);
count += 1;
TableCell r = new TableCell();
r.Text = readerArr[count].ToString();
detailsRow.Cells.Add(r);
TRUpTourListTable.Rows.Add(detailsRow);
count += 1;
}
}
public ActionResult Edit(int ID, Tourist tourist)
{
try
{
Tourist DBtourist = db.Tourists.Where(c => c.ID == ID).FirstOrDefault();
DBtourist.SelectedCity = tourist.SelectedCity;
DBtourist.Interests = tourist.Interests;
DBtourist.FirstName = tourist.FirstName;
DBtourist.LastName = tourist.LastName;
DBtourist.SelectedState = tourist.SelectedState;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public IActionResult Edit(TouristRequest Tourist)
{
CountryViewModel countryViewModel = new CountryViewModel();
countryViewModel.CountryList = new SelectList(countryRepository.GetAll, "CountryId", "Name");
if (ModelState.IsValid)
{
var request = new Tourist()
{
};
touristRepository.Update(request);
touristRepository.Commit();
return(RedirectToAction(nameof(List)));
}
return(View(new CountryViewModel()
{
}));
}
public override async Task <AddRangeClientReponse> AddRangeClient(IAsyncStreamReader <ClientModel> requestStream, ServerCallContext context)
{
while (await requestStream.MoveNext())
{
Tourist client = _mapper.Map <Tourist>(requestStream.Current);
_touristRepository.Add(client);
}
var insertCount = await _touristRepository.SaveChangesAsync();
var response = new AddRangeClientReponse
{
Success = insertCount > 0,
InsertCount = insertCount
};
return(response);
}
public ActionResult ChangeEmergencyInfo()
{
if ((string)Session["userCode"] == "tourist")
{
int TouristId = (int)Session["TouristId"];
Tourist tourist = (from c in entity.Tourists where c.TouristId == TouristId select c).FirstOrDefault();
TouristEmergencyInfoViewModel tcevm = new TouristEmergencyInfoViewModel();
tcevm.TouristId = TouristId;
tcevm.TouristEmergencyPhnNo = tourist.TouristEmergencyPhnNo;
tcevm.TouristAddress = tourist.TouristAddress;
return(View(tcevm));
}
else
{
Session["user"] = "******";
return(RedirectToAction("Index", "Home"));
}
}
public IActionResult cancelTrip(int tourId)
{
int?logged_id = HttpContext.Session.GetInt32("LoggedUser");
if (logged_id == null)
{
return(RedirectToAction("Index"));
}
Tourist remTour = dbContext.Tourists.FirstOrDefault(t => t.TouristId == tourId);
if (remTour != null && remTour.TravellerId == (int)logged_id)
{
dbContext.Remove(remTour);
dbContext.SaveChanges();
}
return(RedirectToAction("Dashboard"));
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
tourID.Text = Session["tourID"].ToString();
Booking b = new Booking();
String reader = b.getTIDbyTour(Session["tourID"].ToString()).ToString();
String[] readerArr = reader.Split(';'); // array of tourist IDs
Array.Resize(ref readerArr, readerArr.Length - 1);
Tourist t = new Tourist();
// for each tourist, get TID, first_name and last_name
for (int i = 0; i < readerArr.Length; i++)
{
String touristID = readerArr[i].ToString();
String touristInfo = t.getTouristName(touristID).ToString();
String[] touristInfoArr = touristInfo.Split(';'); // array of TID, fname, lname
Array.Resize(ref touristInfoArr, touristInfoArr.Length - 1);
LinkButton s = new LinkButton();
s.Text = touristInfoArr[0].ToString();
s.Click += new EventHandler(goToTourist);
TableRow detailsRow = new TableRow();
TableCell tgidCell = new TableCell();
tgidCell.Controls.Add(s);
detailsRow.Cells.Add(tgidCell);
TableCell tidCell = new TableCell();
tidCell.Text = touristInfoArr[1].ToString();
detailsRow.Cells.Add(tidCell);
TableCell userCell = new TableCell();
userCell.Text = touristInfoArr[2].ToString();
detailsRow.Cells.Add(userCell);
viewListTRTable.Rows.Add(detailsRow);
}
}
public ActionResult ChangeAccountEmail(TouristChangeEmailViewModel tcevm)
{
if (ModelState.IsValid)
{
try
{
Tourist tourist = (from c in entity.Tourists where c.TouristId == tcevm.TouristId select c).FirstOrDefault();
if (tourist.TouristEmail == tcevm.TouristEmail)
{
return(RedirectToAction("UserPanel", "Home"));
}
else
{
bool result = tl.CheckEmailExist(tcevm.TouristEmail);
if (result == true)
{
ViewData["message"] = "Email duplicacy found.";
return(View(tcevm));
}
else
{
tourist.TouristEmail = tcevm.TouristEmail;
if (entity.SaveChanges() > 0)
{
return(RedirectToAction("UserPanel", "Home"));
}
else
{
ViewData["message"] = "There's a problem going on. please try again later.";
return(View(tcevm));
}
}
}
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "Tourist", "ChangeAccountEmail")));
}
}
else
{
return(View(tcevm));
}
}
