public void DateEventAdd(AllEventsByDate allEvents)
{
var client = new RestClient("http://localhost:61828");
var request = new RestRequest("api/AllInfo", Method.POST);
request.AddJsonBody(allEvents);
client.Execute(request);
}
public IActionResult Cart(AllEventsByDate events)
{
if (events.EventName != null)
{
cart.Add(events);
}
return(View(new UserAndTicket {
events = cart
}));
}
public TicketEventDate AddAllEventsByDate(AllEventsByDate allEvents)
{
string connectionString = ConnectionString;
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
// Add Event
connection.Query("insert into TicketEvents(EventName, EventHtmlDescription) values(@Name, @Description)", new { Name = allEvents.EventName, Description = allEvents.EventHtmlDescription });
var events = connection.Query <int>("SELECT IDENT_CURRENT ('TicketEvents') AS Current_Identity").First();
connection.Query <TicketEvent>("SELECT * FROM TicketEvents WHERE TicketEventID=@Id", new { Id = events }).First();
// Add Venue
connection.Query("insert into Venues([VenueName],[Address],[City],[Country]) values(@Name,@Address, @City, @Country)", new { Name = allEvents.VenueName, Address = allEvents.Address, City = allEvents.City, Country = allEvents.Country });
var venue = connection.Query <int>("SELECT IDENT_CURRENT ('Venues') AS Current_Identity").First();
connection.Query <Venue>("SELECT * FROM Venues WHERE VenueID=@Id", new { Id = venue }).First();
// Add to TicketEventDate(s)
connection.Query("insert into TicketEventDates([EventStartDateTime],[VenueId],[TicketEventID]) values(@DateTime,@VenueId, @TicketEventID)", new { DateTime = allEvents.EventStartDateTime, VenueId = venue, TicketEventID = events });
var addedVenueQuery = connection.Query <int>("SELECT IDENT_CURRENT ('TicketEventDates') AS Current_Identity").First();
var values = connection.Query <TicketEventDate>("SELECT * FROM Venues WHERE VenueID=@Id", new { Id = addedVenueQuery }).First();
connection.Close();
return(values);
}
}
public void Post([FromBody] AllEventsByDate allEvents)
{
tbd.AddAllEventsByDate(allEvents);
}
