public ActionResult Edit(int id)
{
using (AgencyDBEntities db = new AgencyDBEntities())
{
var tourguide = db.TourGuides.SingleOrDefault(c => c.ID == id);
if (tourguide == null)
{
return(HttpNotFound());
}
var tourViewModel = new TourGuideModel
{
ID = tourguide.ID,
Name = tourguide.Name,
PhoneNO = tourguide.Phone_Number,
BirthDate = tourguide.Date_Of_Birth,
Language1 = tourguide.Language1,
Language2 = tourguide.Language2,
Language3 = tourguide.Language3,
Num_Trips = tourguide.Number_Of_Trips
};
return(View("AddTourGuide", tourViewModel));
}
}
//TODO:- The following function sorts the languages of the tourguide alphabetically.
public TourGuideModel SortLanguages(TourGuideModel tourguideModel)
{
List <string> tmp = new List <string>();
tmp.Add(tourguideModel.Language1);
tmp.Add(tourguideModel.Language2);
tmp.Add(tourguideModel.Language3);
tmp.Sort();
tourguideModel.Language1 = tmp[0];
tourguideModel.Language2 = tmp[1];
tourguideModel.Language3 = tmp[2];
return(tourguideModel);
}
public ActionResult Update(TourGuideModel tourViewModel)
{
if (!ModelState.IsValid)
{
return(View("AddTourGuide", tourViewModel));
}
tourViewModel = SortLanguages(tourViewModel); //Sorting languages of the tourguide
using (AgencyDBEntities db = new AgencyDBEntities())
{
if (tourViewModel.ID == 0)
{
var tour = new TourGuide
{
Name = tourViewModel.Name,
Phone_Number = tourViewModel.PhoneNO,
Date_Of_Birth = tourViewModel.BirthDate,
Language1 = tourViewModel.Language1,
Language2 = tourViewModel.Language2,
Language3 = tourViewModel.Language3,
Number_Of_Trips = 0,
};
db.TourGuides.Add(tour);
}
else
{
var tour = db.TourGuides.Single(c => c.ID == tourViewModel.ID);
tour.Name = tourViewModel.Name;
tour.Phone_Number = tourViewModel.PhoneNO;
tour.Date_Of_Birth = tourViewModel.BirthDate;
tour.Language1 = tourViewModel.Language1;
tour.Language2 = tourViewModel.Language2;
tour.Language3 = tourViewModel.Language3;
tour.Number_Of_Trips = tourViewModel.Num_Trips;
}
db.SaveChanges();
return(RedirectToAction("ManageTourGuide", "TourGuide"));
}
}
public ActionResult ManageTourGuide()
{
List <TourGuideModel> profiles = new List <TourGuideModel>();
using (AgencyDBEntities db = new AgencyDBEntities())
{
TourGuideModel UPV;
var users = db.TourGuides.ToList();
foreach (TourGuide u in db.TourGuides)
{
UPV = new TourGuideModel();
UPV.ID = u.ID;
UPV.Name = u.Name;
UPV.PhoneNO = u.Phone_Number;
UPV.BirthDate = u.Date_Of_Birth;
UPV.BirthDate.ToOADate();
UPV.Language1 = u.Language1;
UPV.Language2 = u.Language2;
UPV.Language3 = u.Language3;
UPV.Num_Trips = u.Number_Of_Trips;
//In order not to display the defaul NONE tourguide who is automatically
//assigned to new trips.
if (UPV.ID != 1)
{
profiles.Add(UPV);
}
}
}
TourGuideDataView UDV = new TourGuideDataView();
UDV.UserProfile = profiles;
return(PartialView(UDV));
}
public ActionResult AddTourGuide()
{
var tourViewModel = new TourGuideModel();
return(View("AddTourGuide", tourViewModel));
}
