public static void cancelRequestAtt(int id)
{
RequestAttraction rrd = DatabaseConnectionHandler.GetInstance().RequestAttraction.Where(x => x.ReqAttId == id).FirstOrDefault();
rrd.ReqAttStatus = "Cancel";
DatabaseConnectionHandler.GetInstance().SaveChanges();
}
public static void deleteAttraction(RequestAttraction requestAttraction)
{
var rslt = DatabaseSingleton.GetInstance().Attractions.Where(x => x.AttractionID == requestAttraction.AttractionID).FirstOrDefault();
rslt.AttractionStatus = "Deleted";
DatabaseSingleton.GetInstance().SaveChanges();
}
public static void updateRequestAtt(int id, string name, string desc, string htw, string wp, DateTime launchDate)
{
RequestAttraction rrd = DatabaseConnectionHandler.GetInstance().RequestAttraction.Where(x => x.ReqAttId == id).FirstOrDefault();
rrd.ReqAttName = name;
rrd.ReqAttDescription = desc;
rrd.ReqAttHowToWork = htw;
rrd.ReqAttWhoParticipant = wp;
rrd.ReqAttStartDateLaunch = launchDate;
DatabaseConnectionHandler.GetInstance().SaveChanges();
}
public static void UpdateAttraction(RequestAttraction requestAttraction)
{
Attraction rd = DatabaseSingleton.GetInstance().Attractions.Where(x => x.AttractionID == requestAttraction.AttractionID).FirstOrDefault();
rd.AttractionName = requestAttraction.AttractionName;
rd.AttractionDescription = requestAttraction.AttractionDescription;
rd.AttractionHowToWork = requestAttraction.AttractionHowToWork;
rd.AttractionStartDate = requestAttraction.AttractionStartDate;
rd.AttractionParticipant = requestAttraction.AttractionParticipant;
DatabaseSingleton.GetInstance().SaveChanges();
}
private void RequestAttraction(object sender, RoutedEventArgs e)
{
RequestAttraction attraction = new RequestAttraction();
attraction.AttractionName = attractionNameText.Text;
attraction.AttractionStartDate = AttractionStartDate.SelectedDate.Value.Date;
attraction.AttractionDescription = AttractionDescriptionText.Text;
attraction.AttractionHowToWork = attractionHowToWorkText.Text;
attraction.AttractionParticipant = AttractionParticipantsText.Text;
attraction.AttractionStatus = "Pending Add";
RequestAttractionController.CreateRequestAttraction(attraction);
}
public static void CreateRide(RequestAttraction requestedAttraction)
{
Attraction rd = new Attraction();
rd.AttractionName = requestedAttraction.AttractionName;
rd.AttractionDescription = requestedAttraction.AttractionDescription;
rd.AttractionHowToWork = requestedAttraction.AttractionHowToWork;
rd.AttractionStartDate = requestedAttraction.AttractionStartDate;
rd.AttractionParticipant = requestedAttraction.AttractionParticipant;
rd.AttractionStatus = "Active";
DatabaseSingleton.GetInstance().Attractions.Add(rd);
DatabaseSingleton.GetInstance().SaveChanges();
}
public static void reqDelAtt(int id, string name, string desc, string htw, string wp, DateTime launchDate)
{
RequestAttraction newRa = new RequestAttraction();
newRa.EmployeeId = LoginHandler.idEmp;
newRa.ReqAttName = name;
newRa.ReqAttDescription = desc;
newRa.ReqAttHowToWork = htw;
newRa.ReqAttWhoParticipant = wp;
newRa.ReqAttStartDateLaunch = launchDate;
newRa.ReqAttStatus = "Removing.. Waiting Approvement";
DatabaseConnectionHandler.GetInstance().RequestAttraction.Add(newRa);
DatabaseConnectionHandler.GetInstance().SaveChanges();
}
private void Search(object sender, RoutedEventArgs e)
{
int id = Int32.Parse(idText.Text);
if (AttractionRadioButton.IsChecked == true)
{
RequestAttraction rslt = RequestAttractionController.SearchByID(id);
if (rslt != null)
{
NameLabel.Content = "Request of " + rslt.AttractionName + "Attraction was " + rslt.AttractionStatus;
if (rslt.AttractionStatus.Contains("Pending"))
{
AcceptButton.IsEnabled = true;
RejectButton.IsEnabled = true;
}
}
else
{
NameLabel.Content = "Not found !";
}
}
else
{
RequestRide rslt = RequestRideController.SearchByID(id);
if (rslt != null)
{
NameLabel.Content = "Your Request " + rslt.RideName + "Ride was " + rslt.RideStatus_;
if (rslt.RideStatus_.Contains("Accepted"))
{
AcceptButton.IsEnabled = true;
RejectButton.IsEnabled = true;
}
}
else
{
NameLabel.Content = "Not found !";
}
}
}
public static void CreateRequestAttraction(RequestAttraction newRequest)
{
DatabaseSingleton.GetInstance().RequestAttractions.Add(newRequest);
DatabaseSingleton.GetInstance().SaveChanges();
}
