public ActionResult DeleteConfirmed(int id, audit_trail audit)
{
var check = db.training_course_instance.Where(s => s.Venue_ID == id).FirstOrDefault();
if (check == null)
{
venue venue = db.venues.Find(id);
address address = db.addresses.Find(venue.Address_ID);
var userId = System.Web.HttpContext.Current.Session["UserID"] as String;
int IntID = Convert.ToInt32(userId);
audit.Employee_ID = IntID;
audit.Trail_DateTime = DateTime.Now.Date;
audit.Deleted_Record = "Venue ID: " + venue.Venue_ID.ToString() + " Venue Name: " + venue.Venue_Name + " Venue Description" + venue.Venue_Description + " Size" + Convert.ToString(venue.Venue_Size)
+ "Address ID: " + address.Address_ID.ToString() + " " + address.Street_Name + " " + address.Suburb + " " + address.City + " " + address.Province + " " + address.Country;
audit.Trail_Description = "Deleted a Venue And a Address.";
db.audit_trail.Add(audit);
db.addresses.Remove(address);
db.venues.Remove(venue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.Error = "Can't delete a venue that is in-use please add a new venue instead.";
return(View());
}
}
public ActionResult DeleteConfirmed(int id)
{
venue venue = db.venues.Find(id);
db.venues.Remove(venue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void SportEventConditionsTest()
{
var venue1 = new venue
{
id = "sr:venue:1",
capacity = 1,
capacitySpecified = true,
city_name = "my city",
country_name = "my country",
map_coordinates = "coordinates",
name = "venue name",
};
var weatherInfo1 = new weatherInfo
{
pitch = "my pitch",
temperature_celsius = 40,
temperature_celsiusSpecified = true,
weather_conditions = "my weather conditions",
wind = "strong",
wind_advantage = "none"
};
var sportEventConditionType = new sportEventConditions
{
attendance = "all",
match_mode = "full mode",
referee = new referee
{
id = "sr:referee:1",
name = "John Doe",
nationality = "German",
},
venue = venue1,
weather_info = weatherInfo1
};
var sportEventConditionsDTO = new SportEventConditionsDTO(sportEventConditionType);
var sportEventConditionsCI = new SportEventConditionsCI(sportEventConditionsDTO, _cultureFirst);
Assert.IsNotNull(sportEventConditionsCI);
Assert.AreEqual(sportEventConditionType.attendance, sportEventConditionsCI.Attendance);
Assert.AreEqual(sportEventConditionType.match_mode, sportEventConditionsCI.EventMode);
Assert.AreEqual(sportEventConditionType.referee.id, sportEventConditionsCI.Referee.Id.ToString());
Assert.AreEqual(sportEventConditionType.referee.name, sportEventConditionsCI.Referee.Name);
Assert.AreEqual(sportEventConditionType.referee.nationality, sportEventConditionsCI.Referee.GetNationality(_cultureFirst));
//Assert.AreEqual(sportEventConditionType.venue.id, sportEventConditionsCI.); TODO: missing Venue
Assert.AreEqual(sportEventConditionType.weather_info.pitch, sportEventConditionsCI.WeatherInfo.Pitch);
Assert.AreEqual(sportEventConditionType.weather_info.temperature_celsius, sportEventConditionsCI.WeatherInfo.TemperatureCelsius);
Assert.AreEqual(sportEventConditionType.weather_info.weather_conditions, sportEventConditionsCI.WeatherInfo.WeatherConditions);
Assert.AreEqual(sportEventConditionType.weather_info.wind, sportEventConditionsCI.WeatherInfo.Wind);
Assert.AreEqual(sportEventConditionType.weather_info.wind_advantage, sportEventConditionsCI.WeatherInfo.WindAdvantage);
}
public ActionResult Edit([Bind(Include = "Venue_ID,Venue_Name,Venue_Description,Venue_Size,Address_ID")] venue venue)
{
if (ModelState.IsValid)
{
db.Entry(venue).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View(venue));
}
public currentEvent(string n, DateTime d, venue p, string ef, List <person> a, List <person> s, string ab, List <string> pE, Dictionary <string, bool> tdl)
{
this.ToDoList = tdl;
this.pastEvents = pE;
this.about = ab;
this.date = d;
this.name = n;
this.place = p;
this.eventFees = ef;
this.attendees = a;
this.staff = s;
}
/// <summary>
/// Initializes a new instance of the <see cref="VenueDTO"/> class
/// </summary>
/// <param name="venue">A <see cref="venue"/> instance containing venue related information</param>
internal VenueDTO(venue venue)
: base(venue.id, venue.name)
{
Contract.Requires(venue != null);
Capacity = venue.capacitySpecified
? (int?)venue.capacity
: null;
City = venue.city_name;
Country = venue.country_name;
CountryCode = venue.country_code;
Coordinates = venue.map_coordinates;
}
/// <summary>
/// Initializes a new instance of the <see cref="VenueDTO"/> class
/// </summary>
/// <param name="venue">A <see cref="venue"/> instance containing venue related information</param>
internal VenueDTO(venue venue)
: base(venue.id, venue.name)
{
Guard.Argument(venue, nameof(venue)).NotNull();
Capacity = venue.capacitySpecified
? (int?)venue.capacity
: null;
City = venue.city_name;
Country = venue.country_name;
CountryCode = venue.country_code;
Coordinates = venue.map_coordinates;
}
// GET: venues/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
venue venue = db.venues.Find(id);
if (venue == null)
{
return(HttpNotFound());
}
return(View(venue));
}
public static venue GetVenue(int id = 0)
{
var msg = new venue
{
id = id == 0 ? SR.Urn("venue").ToString() : SR.Urn(id, "venue").ToString(),
name = "Venue name " + SR.S1000,
capacity = SR.I1000,
capacitySpecified = true,
city_name = "City " + SR.S1000,
country_name = "Country " + SR.S1000,
map_coordinates = "Coordinates" + SR.S1000,
};
return(msg);
}
// GET: venues/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
venue venue = db.venues.Find(id);
if (venue == null)
{
return(HttpNotFound());
}
//ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View(venue));
}
/// <summary>
/// Initializes a new instance of the <see cref="VenueDTO"/> class
/// </summary>
/// <param name="venue">A <see cref="venue"/> instance containing venue related information</param>
internal VenueDTO(venue venue)
: base(venue.id, venue.name)
{
Guard.Argument(venue, nameof(venue)).NotNull();
Capacity = venue.capacitySpecified
? (int?)venue.capacity
: null;
City = venue.city_name;
Country = venue.country_name;
CountryCode = venue.country_code;
State = venue.state;
Coordinates = venue.map_coordinates;
if (!venue.course.IsNullOrEmpty())
{
Course = venue.course.Select(s => new HoleDTO(s));
}
}
public void VenueMergeTest()
{
var venue1 = new venue
{
id = SR.Urn("venue").ToString(),
capacity = 5,
capacitySpecified = true,
city_name = "my city",
country_name = "eng country name",
state = "state",
map_coordinates = "coordinates",
name = "eng name"
};
var venue2 = new venue
{
id = SR.Urn("venue").ToString(),
capacity = 5,
capacitySpecified = true,
city_name = "my city",
country_name = "de country name",
state = "state",
map_coordinates = "coordinates",
name = "eng name"
};
var venueDTO1 = new VenueDTO(venue1);
var venueDTO2 = new VenueDTO(venue2);
var venueCI = new VenueCI(venueDTO1, _cultureFirst);
venueCI.Merge(venueDTO2, _cultureSecond);
Assert.IsNotNull(venueCI);
Assert.AreEqual(venue1.id, venueCI.Id.ToString());
Assert.AreEqual(venue1.name, venueCI.GetName(_cultureFirst));
Assert.AreEqual(venue1.capacity, venueCI.Capacity);
Assert.AreEqual(venue1.map_coordinates, venueCI.Coordinates);
Assert.AreEqual(venue1.state, venueCI.State);
Assert.AreEqual(venue1.city_name, venueCI.GetCity(_cultureFirst));
Assert.AreEqual(venue1.country_name, venueCI.GetCountry(_cultureFirst));
Assert.AreEqual(venue2.country_name, venueCI.GetCountry(_cultureSecond));
Assert.AreNotEqual(venueCI.GetCountry(_cultureFirst), venueCI.GetCountry(_cultureSecond));
}
public ActionResult Create([Bind(Include = "Venue_ID,Venue_Name,Venue_Description,Venue_Size")] venue venue, address address)
{
bool val = Validate(venue.Venue_Name);
if (val == false)
{
db.addresses.Add(address);
venue.Address_ID = address.Address_ID;
db.venues.Add(venue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
//ViewBag.StatusMessage = "There is already a venue called: " + venue.Venue_Name + " in the database.";
ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View());
}
//ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View(venue));
}
public ActionResult Edit([Bind(Include = "Venue_ID,Venue_Name,Venue_Description,Venue_Size,Address_ID")] venue venue, address address)
{
bool val = db.venues.Any(s => s.Venue_Name == venue.Venue_Name && s.Venue_ID != venue.Venue_ID);
if (val == false)
{
//address.Address_ID = venue.Address_ID;
db.Entry(address).State = EntityState.Modified;
db.Entry(venue).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
ViewBag.StatusMessage = "There is already a venue called: " + venue.Venue_Name + " in the database.";
ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View());
}
ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View(venue));
}
