public Match CreateMatch(DateTime matchDate, TimeSpan time, Venue venue, CompetitionMatchType matchType,
Competition competition, Team homeTeam, Team awayTeam)
{
if (homeTeam.GetType() == awayTeam.GetType())
{
Match match = new Match();
match.MatchDate = matchDate;
match.MatchTime = time;
match.Venue = venue;
match.CompetitionMatchType = matchType;
match.Competition = competition;
match.HomeTeam = homeTeam;
match.AwayTeam = awayTeam;
context.Matches.Add(match);
context.SaveChanges();
return match;
}
else
{
return null;
}
}
protected void ddlVenues_SelectedIndexChanged(object sender, EventArgs e)
{
ClearInput();
veu = new Venue(Convert.ToInt32(ddlVenues.SelectedValue));
txtAddressLine1.Text = veu.AddressLine1;
txtAddressLine2.Text = veu.AddressLine2;
txtCity.Text = veu.City;
txtPostalCode.Text = veu.PostalCode;
txtRegion.Text = veu.Region;
txtVenueName.Text = veu.VenueName;
txtVenueURL.Text = veu.VenueURL;
ddlCountryISO.SelectedValue = veu.CountryISO;
chkEnabled.Checked = veu.IsEnabled;
hfVenueID.Value = veu.VenueID.ToString();
txtDescription.Text = veu.Description;
if (veu.VenueType != char.MinValue)
ddlVenueType.SelectedValue = Convert.ToString(veu.VenueType);
txtPhoneNumber.Text = veu.PhoneNumber;
if (veu.Latitude != 0)
txtLatitude.Text = veu.Latitude.ToString();
if (veu.Longitude != 0)
txtLongitude.Text = veu.Longitude.ToString();
}
public RaveDetails(Rave aRave, Owner aOwner, Venue aVenue)
{
RaveID = aRave.RaveID;
Rave = aRave;
Owner = aOwner;
Venue = aVenue;
}
public static void GenerateData()
{
//Set up some test data
using (ISession session = _factory.OpenSession())
{
//Save venues
Venue venue = new Venue { Name="Main Venue"};
session.Save(venue);
//Save courses
Course course1 = new Course {CourseNumber = 1, Venue = venue};
Course course2 = new Course { CourseNumber = 2, Venue = venue };
session.Save(course1);
session.Save(course2);
//Save students
Student student1 = new Student {Name="Student 1"};
student1.Courses.Add(course1);
student1.Courses.Add(course2);
session.Save(student1);
Student student2 = new Student { Name = "Student 2" };
student2.Courses.Add(course1);
session.Save(student2);
session.Flush();
}
}
public IView Add(string name, string address, string description)
{
this.Authorize(Role.VenueAdmin);
var newVenue = new Venue(name, address, description, this.CurrentUser);
this.Data.Venues.Add(newVenue);
return this.View(newVenue);
}
public Fixture(IClub team, IClub opposition, Venue v, DateTime ko)
{
m_team = team;
m_venue = v;
m_opposition = opposition;
m_kickOff = ko;
}
public void OrderBysWork()
{
Venue venue = new Venue();
venue.Update();
List<Event> events = new List<Event>();
for (int i = 0; i < 10; i++)
{
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
events.Add(ev);
}
Event[] childEvents = venue.ChildEvents().AllItems();
Event[] pagedChildEvents = venue.ChildEvents().Page(1, 10);
for (int i = 0; i < events.Count; i++)
{
Assert.AreEqual(events[i].K, childEvents[i].K);
}
var orderBy = new Pair(Event.Columns.K, OrderBy.OrderDirection.Descending);
childEvents = venue.ChildEvents(orderBy).AllItems();
pagedChildEvents = venue.ChildEvents(orderBy).Page(1, 10);
for (int i = 0; i < events.Count; i++)
{
Assert.AreEqual(events[9 - i].K, childEvents[i].K);
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
VenueRegisterLoginClient vrlc = new VenueRegisterLoginClient();
Venue v = new Venue();
v.VenueName = txtVenueName.Text;
v.VenueAddress = txtVenueAddress.Text;
v.VenueCity = txtVenueCity.Text;
v.VenueState = txtVenueState.Text;
v.VenueZipCode = txtVenueZipCode.Text;
v.VenuePhone = txtVenuePhone.Text;
v.VenueEmail = txtVenueEmail.Text;
v.VenueWebPage = txtVenueWebPage.Text;
v.VenueAgeRestriction = int.Parse(txtVenueAgeRestriction.Text);
v.VenueDateAdded = DateTime.Now;
VenueLogin vl = new VenueLogin();
vl.VenueLoginUserName = txtVenueLoginUsername.Text;
vl.VenueLoginPasswordPlain = txtConfirm.Text;
vl.VenueLoginDateAdded = DateTime.Now;
bool result = vrlc.RegisterVenue(v, vl);
if (result)
lblResult.Text = "You have been successfully registered";
else
lblResult.Text = "Registration failed";
}
public async void Initialize()
{
var client = new Client();
var venue = new Venue();
var start = new Start();
if (RetrieveSettings("onTheWay") != "yes")
{
AppointmentStore store = await AppointmentManager.RequestStoreAsync(AppointmentStoreAccessType.AllCalendarsReadOnly);
FindAppointmentsOptions options = new FindAppointmentsOptions();
options.MaxCount = 100;
options.FetchProperties.Add(AppointmentProperties.Subject);
options.FetchProperties.Add(AppointmentProperties.Location);
options.FetchProperties.Add(AppointmentProperties.AllDay);
options.FetchProperties.Add(AppointmentProperties.StartTime);
options.FetchProperties.Add(AppointmentProperties.Duration);
IReadOnlyList<Appointment> appointments = await store.FindAppointmentsAsync(DateTime.Now, TimeSpan.FromHours(2), options);
if (appointments.Count > 0)
{
var i = 0;
while((appointments[i].AllDay) && (i < appointments.Count))
i++;
if (!appointments[i].AllDay)
{
SaveSettings("clientName", appointments[i].Subject);
SaveSettings("venueName", appointments[i].Location);
SaveSettings("startTime", appointments[i].StartTime.ToString());
SaveSettings("localID", appointments[i].LocalId);
}
else
{
SaveSettings("clientName", "Client");
SaveSettings("venueName", "Venue");
SaveSettings("startTime", DateTime.Now.ToString());
SaveSettings("localID", null);
}
}
else
{
SaveSettings("clientName", "Client");
SaveSettings("venueName", "Venue");
SaveSettings("startTime", DateTime.Now.ToString());
SaveSettings("localID", null);
}
}
client.ClientName = RetrieveSettings("clientName");
clientNameTextBox.DataContext = client;
venue.VenueName = RetrieveSettings("venueName");
venueNameTextBox.DataContext = venue;
start.StartTime = DateTime.Parse(RetrieveSettings("startTime"));
//startDatePicker.DataContext = new DateTimeOffset();
}
public int VenueRegistration(VenueLite v)
{
Venue ve = new Venue();
int result = db.usp_RegisterVenue(v.Name, v.Address, v.City, v.State, v.ZipCode, v.Phone, v.Email, v.WebPage, v.AgeRestriction, v.UserName, v.Password);
return result;
}
public Performance CreatePerformance(DateTime date, Artist artist, Venue venue)
{
Performance param = new Performance(0, date, artist.Id, venue.Id);
var request = new RestRequest("api/Performance/CreatePerformance", Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(param);
return client.Execute<Performance>(request).Data;
}
public static Venue createObj(Venue e)
{
using (var context = new EventContainer())
{
context.Venues.Add(e);
context.SaveChanges();
return e;
}
}
public void GetIncorrectVenueFromRepositoryMustReturnNull()
{
var user = new User("admin1", "admin1", Roles.VenueAdmin);
var data = new HotelBookingSystemData();
var expected = new Venue("one", "address one", "vanue with address one", user);
data.RepositoryWithVenues.Add(expected);
var actual = data.RepositoryWithVenues.Get(2);
Assert.AreEqual(null, actual);
}
public static Venue updateObj(Venue e)
{
using (var context = new EventContainer())
{
context.Entry(e).State = EntityState.Modified;
context.SaveChanges();
return e;
}
}
/// <summary>
/// Expects a 3 element array e.g.
///
/// [
/// "13 Apr 15:00",
/// "Gameweek 33",
/// "Norwich (H)"
/// ]
///
/// </summary>
/// <param name="fixtureInfo"></param>
public Fixture(IClub team, string[] fixtureInfo)
{
m_team = team;
Match oppositionMatch = Regex.Match(fixtureInfo[2], @"(.+)\((H|A)\)", RegexOptions.Singleline);
m_opposition = Clubs.GetClubFromName(oppositionMatch.Groups[1].Value.Trim());
m_venue = ParseVenue(oppositionMatch.Groups[2].Value.Trim());
m_kickOff = DateTime.ParseExact(fixtureInfo[0], "dd MMM HH:mm", CultureInfo.InvariantCulture);
}
public void AddingAChildUsingDatabaseAddsToChildren()
{
Venue venue = new Venue();
venue.Update();
Assert.AreEqual(0, venue.ChildEvents().Count);
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
Assert.AreEqual(1, venue.ChildEvents().Count);
}
public Concert(string era, DateTime date, ICollection<Artist> artists, Venue venue, string tour, ICollection<Person> people, string notes)
{
Era = era;
Date = date;
Artists = artists;
Venue = venue;
Tour = tour;
People = people;
Notes = notes;
}
protected void RegisterSubmit_Click(object sender, EventArgs e)
{
clearErrors();
bool registrationAllowed;
Response r = proxy.IsRegistrationAllowed(out registrationAllowed);
if (r.error)
{
ResultLabel.Text = r.message;
return;
}
if (!registrationAllowed)
{
ResultLabel.Text = "Registration is currently locked, please try back later.";
return;
}
string username = UserNameTextBox.Text;
string email = EmailTextBox.Text;
string password = PasswordTextBox.Text;
string confirmPassword = PasswordConfirmationTextBox.Text;
string venueName = VenueNameTextBox.Text;
string venueAddress = VenueAddressTextBox.Text;
if (ErrorInInput(username, email, password, confirmPassword, venueName, venueAddress))
return;
Venue v = new Venue();
v.venueName = venueName;
v.venueAddress = venueAddress;
r = proxy.DJSignUp(username, password, v, email);
if (r.error)
{
ResultLabel.Text = r.message;
return;
}
int ID;
r = proxy.Login(username, password, "Mobile", out ID);
if (r.error)
{
Response.Redirect("~/Account/Login2.aspx");
return;
}
Session["ID"] = ID;
Session["Role"] = "Mobile";
Session["Username"] = username;
Response.Redirect("~/Account/Manage2.aspx");
return;
}
public void DeleteVenue(Venue venue)
{
var request = new RestRequest("api/Venue/DeleteVenue", Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(venue);
client.Execute(request);
foreach (var listener in listeners)
{
listener.OnVenueDeletion(venue);
}
}
public static CheckinRequest GoOffTheGrid(Venue venue)
{
var cr = new CheckinRequest
{
ActualVenue = venue,
VenueId = venue.VenueId,
IsPrivate = true,
};
DataManager.Current.Clear<CheckinResponse>(cr);
return cr;
}
public static CheckinRequest VenueCheckin(Venue venue, bool tweet, bool fb)
{
var cr = new CheckinRequest
{
ActualVenue = venue,
VenueId = venue.VenueId,
Facebook = fb,
Twitter = tweet,
};
DataManager.Current.Clear<CheckinResponse>(cr);
return cr;
}
public Venue CreateVenue(string name, string location, County county)
{
Venue ven = new Venue();
ven.Name = name;
ven.Location = location;
ven.County = county;
context.Venues.Add(ven);
context.SaveChanges();
return ven;
}
public void CanSaveNewVenue()
{
//Optionally, the methods illustrated in the SchemaGenerator can be incorporated into the FixtureSetup/SetUp,
//ensuring a clean database for each fixture/test
Venue venue = new Venue();
venue.Name = "TestVenue";
_session.Save(venue);
//Flush the session, and dispose, to ensure that we load from the database
StartNewSession();
Venue loadedVenue = _session.Load<Venue>(venue.Id);
//Assert that the entity loaded has the same name as the entity that we saved
Assert.AreEqual("TestVenue", loadedVenue.Name);
}
public static Venue create(string name, int capacity)
{
using (var context = new EventContainer())
{
Venue newVenue = new Venue
{
Name = name,
Capacity = capacity,
};
context.Venues.Add(newVenue);
context.SaveChanges();
return newVenue;
}
}
public void CanSaveNewCourseAssociatedWithVenue()
{
Venue venue = new Venue();
venue.Name = "CourseVenue";
_session.Save(venue);
Course course = new Course();
course.CourseNumber = 123;
course.Venue = venue;
_session.Save(course);
StartNewSession();
Course loadedCourse = _session.Load<Course>(course.Id);
Assert.AreEqual(123, loadedCourse.CourseNumber);
Assert.AreEqual(venue, loadedCourse.Venue);
}
public void RemovingAChildUsingDatabaseRemovesFromChildren()
{
Venue venue = new Venue();
venue.Update();
Venue venue2 = new Venue();
venue2.Update();
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
Assert.AreEqual(1, venue.ChildEvents().Count);
ev.VenueK = venue2.K;
ev.Update();
Assert.AreEqual(0, venue.ChildEvents().Count);
}
public static Venue update(string name, int capacity)
{
using (var context = new EventContainer())
{
Venue venue = new Venue
{
Name = name,
Capacity = capacity
};
context.Venues.Attach(venue);
context.Entry(venue).State = EntityState.Modified;
context.SaveChanges();
return venue;
}
}
private Venue CreateVenue(Contract.Data.Venue venue)
{
var v = new Venue();
v.Id = venue.id;
var categoryId = (from c in venue.categories where c.primary select c.id).FirstOrDefault();
if (categoryId != null)
v.PrimaryCategory = CategoryService.FindCategory(categoryId);
v.Name = venue.name;
v.Url = venue.url;
v.GeoLocation = new GeoLocation {
Latitude = venue.location.lat,
Longitude = venue.location.lng };
return v;
}
public void GetAllVanuesWithDataMustReturnThem()
{
var user = new User("admin1", "admin1", Roles.VenueAdmin);
var data = new HotelBookingSystemData();
var venue = new Venue("one", "address one", "vanue with address one", user);
data.RepositoryWithVenues.Add(venue);
var controller = new VenuesController(data, user);
var vanues = controller.All();
var expected = new StringBuilder();
expected.AppendFormat("*[{0}] {1}, located at {2}", venue.Id, venue.Name, venue.Address)
.AppendLine()
.AppendFormat("Free rooms: {0}", venue.Rooms.Count);
Assert.AreEqual(expected.ToString(), vanues.Display());
}
public Match DeleteMatch(DateTime MatchDate, TimeSpan time, Venue venue)
{
Match match = context.Matches
.Where(m => m.MatchDate == MatchDate && m.MatchTime == time && m.Venue == venue)
.FirstOrDefault();
if (match != null)
{
context.Matches.Remove(match);
return match;
}
else
{
return null;
}
}
public void GetAll_DbStartsEmpty_0()
{
int result = Venue.GetAll().Count;
Assert.AreEqual(0, result);
}
public void EditVenue(Venue venue)
{
venues[venues.FindIndex(i => i.ID == venue.ID)] = venue;
}
public VenueWorkflowJobConfig(Venue venue, Type jobType)
: base(jobType)
{
Venue = venue;
}
public void AddVenue([FromBody] Venue venue)
{
return;
}
public static Attachment ToCommentsAttachment(this Venue venue)
{
return(new ThumbnailCard(_commentsObj, $"There are {venue?.Reviews.Count() ?? 0} comments", null, null, MakeCardActions(venue.Id, _venueObj, _actionComments).ToList()).ToAttachment());
}
public void Dispose()
{
Venue.DeleteAllVenues();
}
public static void CreateDisplay(Tournament tournament, DataContext context, Guid roundId)
{
SqlHelper helper = new SqlHelper(tournament.Database);
Round round = helper.GetRound(roundId).Result;
List <Debate> debates = helper.GetDebates(roundId).Result;
List <SpeakerDraw> speakerDraws = new List <SpeakerDraw>();
List <JudgeDraw> judgeDraws = new List <JudgeDraw>();
foreach (Debate debate in debates)
{
speakerDraws.AddRange(helper.GetSpeakerDrawsByDebate(debate.DebateId).Result);
judgeDraws.AddRange(helper.GetJudgeDrawsByDebate(debate.DebateId).Result);
}
List <Speaker> speakers = new List <Speaker>();
speakers.AddRange(context.Speakers);
speakers = speakers.OrderBy(s => s.Name).ToList();
List <Judge> judges = new List <Judge>();
judges.AddRange(context.Judges);
StringBuilder display = new StringBuilder();
display.AppendLine("<html>");
display.AppendLine("<head>");
display.AppendFormat("<title>{0} - Round {1}</title>", tournament.Name, round.RoundNumber);
display.AppendFormat("<link rel=\"stylesheet\" href=\"../lib/display.css\" type=\"text/css\"/>");
display.AppendLine();
display.AppendFormat("<script src=\"../lib/display.js\" type=\"text/javascript\"></script>");
display.AppendLine();
display.AppendLine("</head>");
display.AppendLine("<body>");
display.AppendFormat("<div class=\"header\">{0} - Round {1}</div>", tournament.Name, round.RoundNumber);
display.AppendLine();
display.AppendLine("<div class=\"blocker\"></div>");
display.AppendLine("<table border=\"1\" cellpadding=\"20\">");
display.AppendLine("<th class=\"table-header\">Speaker</th><th class=\"table-header\">Institution</th><th class=\"table-header\">Venue</th><th class=\"table-header\">Opening Government</th><th class=\"table-header\">Opening Opposition</th><th class=\"table-header\">Second Government</th><th class=\"table-header\">Second Opposition</th><th class=\"table-header\">Closing Government</th><th class=\"table-header\">Closing Opposition</th><th class=\"table-header\">Judges</th>");
foreach (Speaker speaker in speakers)
{
SpeakerDraw speakerDraw = speakerDraws.First(sd => sd.SpeakerId.Equals(speaker.SpeakerId));
Debate debate = debates.First(d => d.DebateId.Equals(speakerDraw.DebateId));
Venue venue = context.Venues.First(v => v.VenueId.Equals(debate.VenueId));
display.AppendLine("<tr class=\"display-row-entry\">");
display.AppendFormat("<td class=\"display-cell-entry\">{0}</td>", speaker.Name);
display.AppendFormat("<td class=\"display-cell-entry\">{0}</td>", context.Institutions.First(i => i.InstitutionId.Equals(speaker.InstitutionId)).Name);
display.AppendFormat("<td class=\"display-cell-entry\">{0}</td>", venue.Name);
foreach (SpeakerDraw draw in speakerDraws.Where(sd => sd.DebateId.Equals(speakerDraw.DebateId)).OrderBy(o => o.Position))
{
display.AppendFormat("<td class=\"display-cell-entry{0}\">{1}</td>", draw.DrawId.Equals(speakerDraw.DrawId) ? " selected" : string.Empty, speakers.First(s => s.SpeakerId.Equals(draw.SpeakerId)).Name);
}
string[] judgeNames = judgeDraws.Where(jd => jd.DebateId.Equals(debate.DebateId)).OrderBy(j => j.Number).Select(jd => judges.First(j => jd.JudgeId.Equals(j.JudgeId)).Name).ToArray();
display.AppendFormat("<td class=\"display-cell-entry\">{0}</td>", string.Join(",<br/>", judgeNames));
display.AppendLine("</tr>");
}
display.AppendLine("</table>");
display.AppendLine("</body>");
display.AppendLine("</html>");
string directory = Path.Combine(Path.GetDirectoryName(tournament.Location), tournament.Name, string.Format("Round {0}", round.RoundNumber));
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
string filename = Path.Combine(directory, "draw.html");
File.WriteAllText(filename, display.ToString());
}
public ActionResult ViewVenue()
{
List <Venue> allVenues = Venue.GetAll();
return(View("VenueList", allVenues));
}
public IActionResult Add(Venue Venue)
{
var newFileName = string.Empty;
if (HttpContext.Request.Form.Files != null)
{
var fileName = string.Empty;
string PathDB = string.Empty;
var files = HttpContext.Request.Form.Files;
if (files == null)
{
ModelState.AddModelError("", "Upload Venue Photo !");
return(View());
}
if (!ModelState.IsValid)
{
return(View("Venue"));
}
var uploads = Path.Combine(_environment.WebRootPath, "VenueImages");
foreach (var file in files)
{
if (file.Length > 0)
{
fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
var myUniqueFileName = Convert.ToString(Guid.NewGuid());
var FileExtension = Path.GetExtension(fileName);
newFileName = myUniqueFileName + FileExtension;
fileName = Path.Combine(_environment.WebRootPath, "VenueImages") + $@"\{newFileName}";
PathDB = "VenueImages/" + newFileName;
using (FileStream fs = System.IO.File.Create(fileName))
{
file.CopyTo(fs);
fs.Flush();
}
}
}
Venue objvenue = new Venue
{
VenueFilename = newFileName,
VenueFilePath = PathDB,
VenueID = 0,
VenueName = Venue.VenueName,
VenueCost = Venue.VenueCost,
Createdate = DateTime.Now,
Createdby = Convert.ToInt32(HttpContext.Session.GetString("UserID"))
};
_IVenue.SaveVenue(objvenue);
TempData["VenueMessage"] = "Venue Saved Successfully";
ModelState.Clear();
return(View(new Venue()));
}
return(View(Venue));
}
public Add(Venue venue)
: base(venue)
{
// https://awesomecommentphotos.files.wordpress.com/2013/08/1003531_560612187329667_1660736981_n.jpg?w=326
}
private Guid?AddNewTeam(string teamLookupId, Guid?countryKey)
{
// http://www.soccerbase.com/teams/team.sd?team_id=485
var uri = new Uri(string.Format("http://www.soccerbase.com/teams/team.sd?team_id={0}", teamLookupId));
var document = GetHtmlDocument(uri);
var table = document.DocumentNode.Descendants("table").FirstOrDefault(t => t.Attributes.Contains("class") && t.Attributes["class"].Value == "imageHead");
var header1 = table.Descendants("h1").FirstOrDefault();
var teamName = header1.InnerText.GetTextBefore("Club details").Replace("/n", string.Empty).Trim();
var venueName = string.Empty;
int?venueCapacity = null;
table = document.DocumentNode.Descendants("table").FirstOrDefault(t => t.Attributes.Contains("class") && t.Attributes["class"].Value == "clubInfo");
foreach (var tr in table.Descendants("tr"))
{
var th = tr.Descendants("th").FirstOrDefault();
if (th == null)
{
continue;
}
switch (th.InnerText)
{
case "Ground":
var venueNode = tr.Descendants("strong").FirstOrDefault();
if (venueNode != null)
{
venueName = venueNode.InnerText.Trim();
}
var groundList = tr.Descendants("li").FirstOrDefault(l => l.Attributes.Contains("class") && l.Attributes["class"].Value == "alt");
if (groundList != null)
{
var capacityNode = groundList.Descendants("strong").FirstOrDefault();
if (capacityNode != null)
{
venueCapacity = capacityNode.InnerText.Replace("/n", string.Empty).Replace(",", string.Empty).Trim().ToNullableInt();
}
}
break;
}
}
Guid?venueKey = null;
if (!string.IsNullOrWhiteSpace(venueName) && countryKey != null)
{
venueKey = Guid.NewGuid();
var venue = new Venue()
{
PrimaryKey = (Guid)venueKey
};
Provider.Add(venue);
var venueV = VenueV.CreateNew <VenueV>(User.GetUserId());
venueV.HeaderKey = venue.PrimaryKey;
venueV.VenueName = venueName;
venueV.CountryGuid = (Guid)countryKey;
venueV.Capacity = venueCapacity;
venueV.EffectiveFrom = Date.LowDate;
venueV.EffectiveTo = Date.HighDate;
Provider.Add(venueV);
}
Guid?teamGuid = null;
if (!string.IsNullOrEmpty(teamName))
{
teamGuid = Guid.NewGuid();
var team = new Team()
{
PrimaryKey = (Guid)teamGuid
};
Provider.Add(team);
var teamV = TeamV.CreateNew <TeamV>(User.GetUserId());
teamV.HeaderKey = team.PrimaryKey;
teamV.HomeVenueGuid = venueKey;
teamV.CountryGuid = countryKey;
teamV.EffectiveFrom = Date.LowDate;
teamV.EffectiveTo = Date.HighDate;
teamV.TeamNames = new List <TeamName>();
teamV.TeamNames.Add(new TeamName()
{
PrimaryKey = Guid.NewGuid(),
TeamVKey = teamV.PrimaryKey,
TeamNameType = TeamNameType.Primary,
LanguageType = LanguageType.Native,
Description = teamName
});
Provider.Add(teamV);
Provider.Add(new LookupTeam()
{
PrimaryKey = Guid.NewGuid(),
ImportSite = this.ImportSite,
TeamGuid = (Guid)teamGuid,
LookupId = teamLookupId
});
}
Provider.SaveChanges();
return(teamGuid);
}
static void Main(string[] args)
{
// Un-comment to start over
//DataManager.DeleteAll();
// Add Guitar
var guitar = (from i in DataManager.Instruments
where i.Name == "Guitar"
select i).FirstOrDefault();
if (guitar == null)
{
guitar = new Instrument()
{
Name = "Guitar"
};
DataManager.AddInstrument(guitar);
}
// Change the name from Guitar to Electric Guitar
//guitar.Name = "Electric Guitar";
//guitar = DataManager.UpdateInstrument(guitar);
Console.WriteLine("Instrument: {0} with InstrumentId {1}",
guitar.Name, guitar.InstrumentId);
// Add Keyboards
var keyboards = (from i in DataManager.Instruments
where i.Name == "Keyboards"
select i).FirstOrDefault();
if (keyboards == null)
{
keyboards = new Instrument()
{
Name = "Keyboards"
};
DataManager.AddInstrument(keyboards);
}
Console.WriteLine("Instrument: {0} with InstrumentId {1}",
keyboards.Name, keyboards.InstrumentId);
// Delete the guitar
//DataManager.DeleteInstrument(guitar);
//Console.WriteLine("Instrument: {0} deleted", guitar.Name);
// Musician
var musician = (from m in DataManager.Musicians
where m.Name == "Harry Chap"
select m).FirstOrDefault();
if (musician == null)
{
musician = new Musician()
{
Name = "Harry Chap",
Bio = "Harry Chap plays a mean guitar and sings his butt off",
Email = "*****@*****.**",
MobilePhone = "888-555-1212",
PhotoUrl = "",
};
musician = DataManager.AddMusician(musician, guitar);
}
//string message = DataManager.DeleteMusician(musician, true);
//if (message != "")
// Console.WriteLine(message);
//else
// Console.WriteLine("Musician {0} deleted", musician.Name);
//return;
//musician.Name = "Hairy Chap";
//musician = DataManager.UpdateMusician(musician);
Console.WriteLine("Musician: {0}", musician.Name);
foreach (var mi in musician.MusicianInstrument)
{
Console.WriteLine(" plays {0}", mi.Instrument.Name);
}
// Band
var band = (from x in DataManager.Bands
where x.Name == "The Harry Chap Band"
select x).FirstOrDefault();
if (band == null)
{
band = new Band()
{
Name = "The Harry Chap Band",
Description = "These guys can really jam!"
};
band = DataManager.AddBand(band, musician);
}
Console.WriteLine("Band: {0}", band.Name);
// Venue
var venue = (from x in DataManager.Venues
where x.Name == "The Spotted Horse"
select x).FirstOrDefault();
if (venue == null)
{
venue = new Venue()
{
Name = "The Spotted Horse"
};
venue = DataManager.AddVenue(venue);
}
Console.WriteLine("Venue: {0}", venue.Name);
// Booking
var booking = (from x in DataManager.Bookings
where x.BandId == band.BandId
select x).FirstOrDefault();
if (booking == null)
{
booking = new Booking()
{
Name = "Harry Chap Band at the Spotted Horse",
BandId = band.BandId,
VenueId = venue.VenueId,
DateAndTime = DateTime.Now.AddDays(30),
PayOffering = "50 bucks"
};
booking = DataManager.AddBooking(booking);
}
Console.WriteLine("Booking: {0} at {1} on {2}",
band.Name, venue.Name,
booking.DateAndTime.ToLongDateString());
Console.ReadLine();
}
public CreateVenueCommand(Venue item)
{
Venue = item;
}
public void VenueTable_Clear_True()
{
int result = Venue.GetAllVenues().Count;
Assert.AreEqual(0, result);
}
public void Equals_AreTheSame_True()
{
Venue blue2 = new Venue("Madison Square Garden");
Assert.AreEqual(blue, blue2);
}
public int Edit(Venue venue)
{
context.Venue.Update(venue);
return(context.SaveChanges());
}
/// <summary>
/// Execute this instance.
/// </summary>
public void Execute()
{
int i = 0;
Game g = null;
Venue venue = null;
currentRoadTeam = null;
currentHomeTeam = null;
while (!isSeriesOver)
{
try
{
venue = venues[i];
currentRoadTeam = roadTeams[i];
currentHomeTeam = homeTeams[i];
g = new Game(venue, currentRoadTeam, currentHomeTeam, Game.GenerateGameTime(), Convert.ToInt32(ConfigurationManager.GetConfigurationValue("CURRENT_NUM_INNINGS_REGULATION")), true);
g.IsSeasonMode = true;
Logger logger = new Logger(String.Format($"{parentDirectoryPath}{this.seriesName}/{g.Id}{ConfigurationManager.GetConfigurationValue("GAME_FILE_EXTENSION")}"));
g.Announcer = new Announcer(Guid.NewGuid().ToString(), ConfigurationManager.GetConfigurationValue("ANNOUNCER_NAME"), logger);//make sure announcer commentary gets logged
g.Announcer.Silent = this.silentMode;
g.Announcer.AnnounceToConsole(ConfigurationManager.GetConfigurationValue("GAME_TITLE"));
g.Execute();
g.Announcer.AnnounceToConsole(new GameStatisticsDisplayer(g.Scoreboard).GetFullBoxScore());
Console.Write($"The winner is {g.Winner}\r");
if (g.Winner == roadTeam)
{
roadTeamWins++;
}
else
{
homeTeamWins++;
}
logger.WriteToFile();
g.ClearGameStats(roadTeam);
g.ClearGameStats(homeTeam);
gamesPlayed.Add(g);
if (!playFullSeries)
{
isSeriesOver |= (CheckSeriesOver(roadTeamWins) || CheckSeriesOver(homeTeamWins));
}
seriesWinner = homeTeamWins > roadTeamWins ? homeTeam : roadTeam;
seriesLoser = homeTeamWins < roadTeamWins ? homeTeam : roadTeam;
i++;
isSeriesOver |= i == this.numGames;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
Console.ReadLine();
}
}
if (IsSeasonMode)
{
//Show results of season/series
ShowSeriesStatistics();
}
}
public static Attachment ToLocationAttachment(this Venue venue, Geo geo)
{
var distanceString = geo != null && venue.Location != null ? $"{venue.Location.ToKilometers(new Location(geo.longitude, geo.latitude))} km" : "Can't get distane";
return(new ThumbnailCard(_locationObj, distanceString, venue?.Location?.Adress ?? venue?.Location?.ToString() ?? "Can't get location").ToAttachment());
}
public IList <Performance> QueryPerformancesByVenueAndDay(Venue venue, DateTime day)
{
IPerformanceDao dao = DALFactory.CreatePerformanceDao(database);
return(dao.FindPerformanceForVenueByDay(venue, day));
}
public Venue Add(Venue venue)
{
return(_context.Venues.Add(venue).Entity);
}
public int Add(Venue venue)
{
context.Venue.Add(venue);
return(context.SaveChanges());
}
public void Post([FromBody] Venue value)
{
Venue.VenueAdd(value.VenueName, value.Address, value.City, value.Country);
}
public void Dispose()
{
Venue.DeleteAll();
Band.DeleteAll();
}
public void Put(int id, [FromBody] Venue a)
{
Venue.VenueUpdate(id, a.VenueName, a.Address, a.City, a.Country);
}
public PushOrderWorkflow(Venue venue, TPushOrderService orderCreator, OrderRepository repository)
{
_orderCreator = orderCreator;
_venue = venue;
_repository = repository;
}
public void AddVenue(Venue venue)
{
venues.Add(venue);
}
public SavedEventQueryResult Handle(SavedEventQuery query)
{
var eventDataModel = _eventRepository.GetByAltId(query.Id);
var eventModel = AutoMapper.Mapper.Map <Contracts.Models.Event>(eventDataModel);
var placeVisitDuration = _placeVisitDurationRepository.GetBySingleEventId(eventModel.Id);
var galleryImageResponse = _eventGalleryImageRepository.GetByEventId(eventModel.Id);
var galleryImageModel = AutoMapper.Mapper.Map <IEnumerable <EventGalleryImage> >(galleryImageResponse);
var eventcatmapresponse = _eventCategoryMappingRepository.GetByEventId(eventModel.Id);
var eventcatmap = AutoMapper.Mapper.Map <IEnumerable <EventCategoryMapping> >(eventcatmapresponse);
var eventsiteidresponse = _eventSiteIdMappingRepository.GetByEventId(eventModel.Id);
var eventsitemap = AutoMapper.Mapper.Map <EventSiteIdMapping>(eventsiteidresponse);
var eventlearnmoreresponse = _eventLearnMoreAttributeRepository.GetByEventId(eventModel.Id);
var eventlearnmore = AutoMapper.Mapper.Map <IEnumerable <EventLearnMoreAttribute> >(eventlearnmoreresponse);
var eventamenityresponse = _eventAmenityRepository.GetByEventId(eventModel.Id);
var eventamenity = AutoMapper.Mapper.Map <IEnumerable <EventAmenity> >(eventamenityresponse);
var eventdetailresponse = _eventDetailRepository.GetSubeventByEventId(eventModel.Id).FirstOrDefault();
var eventdetail = AutoMapper.Mapper.Map <EventDetail>(eventdetailresponse);
var eventTags = _eventTagMappingRepository.GetByEventId(eventModel.Id);
Country countrydetail = new Country();
City citydetail = new City();
State statedetail = new State();
Zipcode zipcodeDetail = new Zipcode();
Venue venuedetail = new Venue();
if (eventdetail != null)
{
var venuedetailresponse = _venueRepository.GetByVenueId(eventdetail.VenueId);
venuedetail = AutoMapper.Mapper.Map <Venue>(venuedetailresponse);
if (venuedetail != null)
{
var citydetailresponse = _cityRepository.GetByCityId(venuedetail.CityId);
citydetail = AutoMapper.Mapper.Map <City>(citydetailresponse);
var Zip = _zipcodeRepository.GetAllByCityId(citydetail.Id).FirstOrDefault();
zipcodeDetail = AutoMapper.Mapper.Map <Zipcode>(Zip);
}
if (citydetail != null)
{
var statedetailresponse = _stateRepository.GetByStateId(citydetail.StateId);
statedetail = AutoMapper.Mapper.Map <State>(statedetailresponse);
}
if (statedetail != null)
{
var countrydetailresponse = _countryRepository.GetByCountryId(statedetail.CountryId);
countrydetail = AutoMapper.Mapper.Map <Country>(countrydetailresponse);
}
}
var features = Enum.GetValues(typeof(LearnMoreFeatures));
var resultdata = new SavedEventQueryResult();
resultdata.Country = countrydetail.Name;
resultdata.City = citydetail.Name;
resultdata.Address1 = venuedetail.AddressLineOne;
resultdata.Address2 = venuedetail.AddressLineTwo;
resultdata.State = statedetail.Name;
resultdata.Lat = ((venuedetail.Latitude != null && venuedetail.Latitude != "" && venuedetail.Latitude != "NaN") ? venuedetail.Latitude : "18.5204");
resultdata.Long = ((venuedetail.Longitude != null && venuedetail.Longitude != "" && venuedetail.Latitude != "NaN") ? venuedetail.Longitude : "73.8567");
List <string> amenityids = new List <string>();
if (zipcodeDetail != null)
{
if (zipcodeDetail.Id != 0)
{
resultdata.Zip = zipcodeDetail.Postalcode;
}
}
foreach (var ea in eventamenity)
{
amenityids.Add((ea.AmenityId).ToString());
}
if (placeVisitDuration != null)
{
var data = placeVisitDuration.TimeDuration.Split("-");
if (data.Length >= 2)
{
resultdata.HourTimeDuration = placeVisitDuration.TimeDuration;
resultdata.MinuteTimeDuration = "";
}
}
resultdata.AmenityId = string.Join(",", amenityids);
//resultdata.AmenityId = string.Join(",", amenityids);
var archdesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.ArchitecturalDetail);
if (archdesc != null)
{
resultdata.Archdetail = archdesc.Description;
resultdata.ArchdetailId = archdesc.Id;
}
var highlightdesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.HighlightNugget);
if (highlightdesc != null)
{
resultdata.Highlights = highlightdesc.Description;
resultdata.HighlightsId = highlightdesc.Id;
}
var historydesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.History);
if (historydesc != null)
{
resultdata.History = historydesc.Description;
resultdata.HistoryId = historydesc.Id;
}
var immersdesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.ImmersiveExperience);
if (immersdesc != null)
{
resultdata.Immersiveexperience = immersdesc.Description;
resultdata.ImmersiveexperienceId = immersdesc.Id;
}
var tilesImages = "";
var galleryImages = galleryImageModel.Where(p => p.Name.Contains("gallery"));
var tilesSliderImages = galleryImageModel.Where(p => p.Name.Contains("Tiles"));
var descPageImages = galleryImageModel.Where(p => p.Name.Contains("DescBanner"));
var inventoryPageImages = galleryImageModel.Where(p => p.Name.Contains("InventoryBanner"));
var placeMapImages = galleryImageModel.Where(p => p.Name.Contains("placemapImages"));
var timelineImages = galleryImageModel.Where(p => p.Name.Contains("timelineImages"));
var immersiveImages = galleryImageModel.Where(p => p.Name.Contains("immersiveImages"));
var architecturalImages = galleryImageModel.Where(p => p.Name.Contains("archdetailImages"));
var galleryImagesList = "";
var tilesSliderImagesList = "";
var descPageList = "";
var inventoryPageList = "";
var plaeMapImagesList = "";
var timelineImagesList = "";
var immerseImagesList = "";
var archImagesList = "";
foreach (EventGalleryImage eventGalleryImage in galleryImages)
{
galleryImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in tilesSliderImages)
{
tilesSliderImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in descPageImages)
{
descPageList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in inventoryPageImages)
{
inventoryPageList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in placeMapImages)
{
plaeMapImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in timelineImages)
{
timelineImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in immersiveImages)
{
immerseImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in galleryImages)
{
archImagesList += eventGalleryImage.Name + ",";
}
resultdata.GalleryImages = galleryImagesList;
resultdata.TilesSliderImages = tilesSliderImagesList;
resultdata.DescpagebannerImage = descPageList;
resultdata.InventorypagebannerImage = inventoryPageList;
resultdata.PlacemapImages = plaeMapImagesList;
resultdata.TimelineImages = timelineImagesList;
resultdata.ImmersiveexpImages = immerseImagesList;
resultdata.ArchdetailImages = archImagesList;
resultdata.Description = eventModel.Description;
resultdata.Id = eventModel.Id;
resultdata.AltId = eventModel.AltId;
resultdata.Location = eventModel.Name;
List <int> subcatids = new List <int>();
List <int> tags = new List <int>();
int categoryId = eventModel.EventCategoryId;
foreach (var cat in eventcatmap)
{
categoryId = cat.EventCategoryId;
subcatids.Add(cat.EventCategoryId);
}
foreach (var tag in eventTags)
{
tags.Add((int)tag.TagId);
}
var category = _eventCategoryRepository.Get(categoryId);
resultdata.Subcategoryid = string.Join(",", subcatids);
resultdata.TagIds = string.Join(",", tags);
resultdata.Categoryid = category.EventCategoryId;
//resultdata.Subcategoryid = subcatids.FirstOrDefault();
/*var categorymapobj = eventcatmap.FirstOrDefault();
* if (categorymapobj != null)
* {
* resultdata.Categoryid = eventModel.EventCategoryId;
* }*/
resultdata.Metadescription = eventModel.MetaDetails;
if (resultdata.Metadescription != null)
{
string[] metas = resultdata.Metadescription.Split(new string[] { "<br/>" }, StringSplitOptions.None);
if (metas.Length == 3)
{
resultdata.Metatitle = metas[0].Split("title")[1].Replace(">", "").Replace("</", "");
resultdata.Metadescription = metas[1].Split("content=")[1].Replace(">", "").Replace("\"", "").Replace("</", "");
resultdata.Metatags = metas[2].Split("content=")[1].Replace(">", "").Replace("\"", "").Replace("</", "");
}
}
resultdata.PlaceName = venuedetail.Name;
//resultdata.Subcategoryid = eventcatmap.Select(p => p.EventCategoryId).FirstOrDefault();
//resultdata.Subcategoryid = string.Join(",", eventcatmap.Count() > 0 ? eventcatmap.Select(p => p.EventCategoryId).ToList() : new List<int>());
resultdata.Title = eventModel.Name;
var eventHostMappings = _eventHostMappingRepository.GetAllByEventId(eventModel.Id);
resultdata.EventHostMappings = eventHostMappings.ToList();
return(resultdata);
}
public static Attachment ToReservationsAttachment(this Venue venue, params string[] actions)
{
return(new ThumbnailCard(_reservationsObj, $"There are {venue?.Reservations.Count() ?? 0} reservations", null, null, MakeCardActions(venue.Id, _venueObj, actions).ToList()).ToAttachment());
}
public Task <BaseResponseDto <GigDto> > UpDateGig(Guid venueId, Venue venue)
{
throw new NotImplementedException();
}
protected void venueSave_Click(object sender, EventArgs e)
{
if (Session["Mytable"] == null)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('This venue does not contain any sections. Please add a section and try again.')", true);
}
else
{
mytable = (DataTable)Session["Mytable"];
int n;
if (!Regex.IsMatch(txtCity.Text, @"^[a-zA-Z ]+$"))
{
venueOutput.Text = "Invalid City.";
venueOutput.Visible = true;
venueOutput.ForeColor = Color.Red;
vengrid.Visible = true;
}
else if (txtZip.Text.Replace(" ", string.Empty).Length != 5 || !int.TryParse(txtZip.Text, out n))
{
venueOutput.Text = "Invalid zipcode.";
venueOutput.Visible = true;
venueOutput.ForeColor = Color.Red;
vengrid.Visible = true;
}
else if (mytable.Rows.Count == 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('The venue does not contain any sections. Please add a section and try it again.')", true);
}
else
{
try
{
string name = txtvenueName.Text;
string address1 = txtaddress1.Text;
string address2 = txtaddress2.Text;
string city = txtCity.Text;
string state = txtState.SelectedValue;
string zipcode = txtZip.Text.Replace(" ", string.Empty);
string description = txtvenueDescription.Text;
Venue venue = new Venue(name, address1, address2, city, state, zipcode, description);
int id = Connection.AddVenue(venue);
DataColumn nc;
//DataRow row;
//DataRow nr = mytable.NewRow();
if (!mytable.Columns.Contains("VenueID"))
{
//Add the a new column and add it into the existing gridview
nc = new DataColumn();
nc.DataType = System.Type.GetType("System.Int32");
nc.ColumnName = "VenueID";
nc.DefaultValue = id;
mytable.Columns.Add(nc);
}
for (int i = 0; i < mytable.Rows.Count; i++)
{
mytable.Rows[i][2] = id;
}
//Add data to gridview
VenueGrid.DataSource = mytable;
VenueGrid.DataBind();
foreach (DataRow g1 in mytable.Rows)
{
int section = g1.Field <int>(0);
int seattotal = g1.Field <int>(1);
int venueid = g1.Field <int>(2);
Seatlevel slv = new Seatlevel(venueid, section, seattotal);
Connection.AddSeatSection(slv);
}
venueOutput.Visible = true;
lbSeatOutput.Text = "";
venueOutput.Text = "The venue was uploaded successfully.";
venueOutput.ForeColor = Color.Blue;
ClearVenueFields();
GridView1.DataBind();
}
catch (Exception exe)
{
venueOutput.Text = "The venue failed to upload.";
venueOutput.ForeColor = Color.Red;
venueOutput.Visible = true;
vengrid.Visible = true;
}
}
}
}
