public ActionResult SaveEvent(Event_Details event_Details, HttpPostedFileBase ImagePath)
{
var allowedExtensions = new[] { ".Jpg", ".png", ".jpg", "jpeg" };
using (GoExploreEntities goExplore = new GoExploreEntities()) {
int _rownumner = goExplore.Event_Details.Count();
var fileName = Path.GetFileName(ImagePath.FileName);
var ext = Path.GetExtension(ImagePath.FileName);
string name = Path.GetFileNameWithoutExtension(fileName);
//string myfile = name +"_"+ _rownumner.ToString() + ext;
string myfile = "eImg_" + _rownumner.ToString() + ext;
var path = Path.Combine(Server.MapPath("~/images/"), myfile);
ImagePath.SaveAs(path);
Event_Details _event_Details = new Event_Details();
_event_Details.categoryId = event_Details.categoryId;
_event_Details.eventName = event_Details.eventName;
_event_Details.eventDescription = event_Details.eventDescription;
_event_Details.eventDate = event_Details.eventDate;
_event_Details.venue = event_Details.venue;
_event_Details.organizerId = event_Details.organizerId;
//_event_Details.i = myfile;
goExplore.Event_Details.Add(_event_Details);
goExplore.SaveChanges();
int newEventId = event_Details.eventId;
return(RedirectToAction("Index", "Dashboard", new { @pageNo = 0 }));
}
}
/// <summary>
/// Adds record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
Event_Details newRecord = args.RowData as Event_Details;
Event_Details order = context.Event_Details.First(i => i.eventID == newRecord.eventID);
order.eventID = newRecord.eventID;
order.eventAddress = newRecord.eventAddress;
order.eventDescription = newRecord.eventDescription;
order.capacity = newRecord.capacity;
order.eventStart = newRecord.eventStart;
order.eventEnd = newRecord.eventEnd;
order.eventLocation = newRecord.eventLocation;
order.eventPicture = newRecord.eventPicture;
order.eventTitle = newRecord.eventTitle;
order.eventGenre = newRecord.eventGenre;
order.showOnHomePage = newRecord.showOnHomePage;
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
public static Event_Details get_event(string event_id)
{
string url = "https://app.ticketmaster.com/discovery/v2/events/" + event_id + ".json?apikey=ijBGAE7zf8QIerN30cVi8bUnxNTiuyzy";
var client = new RestClient(url);
var request = new RestRequest(Method.GET);
IRestResponse response = client.Execute(request);
string jContent = response.Content;
dynamic dyn = JsonConvert.DeserializeObject(jContent);
string event_name = dyn.name;
string event_type = dyn.type;
var event_sales = dyn.sales;
string artist_image_url = "";
if (dyn.images != null)
{
artist_image_url = dyn.images[0]["url"].ToString();
}
string local_time = "";
string local_date = "";
string timezone = "";
if (dyn.dates != null)
{
var dates = dyn.dates.start;
local_time = dates.localTime;
local_date = dates.localDate;
timezone = dates.timezone;
}
JArray classifications = dyn.classifications;
string genre = "";
string genre_id = "";
if (classifications != null)
{
foreach (var cl in classifications)
{
var genre_obj = cl["genre"];
genre = genre_obj["name"].ToString();
genre_id = genre_obj["id"].ToString();
}
}
var promoter_obj = dyn.promoter;
string promoter = "";
if (dyn.promoter != null)
{
promoter = promoter_obj["name"];
}
;
var embedded = dyn._embedded;
JArray venues = embedded["venues"];
string venue_name = "";
string venue_url = "";
string venue_city = "";
string venue_state = "";
string venue_country = "";
string venue_country_code = "";
string venue_address = "";
string venue_state_code = "";
foreach (var v in venues)
{
venue_name = v["name"].ToString();
venue_url = v["url"].ToString();
venue_city = v["city"]["name"].ToString();
if (v["state"] != null)
{
venue_state = v["state"]["name"].ToString();
if (v["state"]["stateCode"] != null)
{
venue_state_code = v["state"]["stateCode"].ToString();
}
}
venue_country = v["country"]["name"].ToString();
venue_country_code = v["country"]["countryCode"].ToString();
venue_address = v["address"]["line1"].ToString();
}
JArray attractions = embedded["attractions"];
string artist_name = "";
string artist_instagram = "";
string artist_facebook = "";
string artist_twitter = "";
foreach (var a in attractions)
{
artist_name = a["name"].ToString();
//if (a["externalLinks"] != null)
//{
// artist_facebook = a["externalLinks"]["facebook"][0]["url"].ToString();
// if (a["externalLinks"]["instagram"] != null)
// artist_instagram = a["externalLinks"]["instagram"][0]["url"].ToString();
// if (a["externalLinks"]["twitter"] != null)
// artist_twitter = a["externalLinks"]["twitter"][0]["url"].ToString();
//}
}
Event_Details event_details = new Event_Details();
event_details.event_id = event_id;
event_details.event_name = event_name;
event_details.event_type = event_type;
event_details.event_start_date = local_date;
event_details.event_start_time = local_time;
event_details.timezone = timezone;
event_details.genre = genre;
event_details.genre_id = genre_id;
event_details.promoter = promoter;
event_details.venue_name = venue_name;
event_details.venue_address = venue_address;
event_details.venue_city = venue_city;
event_details.venue_country = venue_country;
event_details.venue_country_code = venue_country_code;
event_details.venue_state = venue_state;
event_details.venue_url = venue_url;
event_details.artist_name = artist_name;
event_details.artist_facebook = artist_facebook;
event_details.artist_instagram = artist_instagram;
event_details.artist_twitter = artist_twitter;
event_details.artist_image_url = artist_image_url;
event_details.venue_state_code = venue_state_code;
return(event_details);
}
public ActionResult Event_Details(string event_id)
{
Event_Details event_details = get_event(event_id);
return(View("~/Views//Home/Event_details.cshtml", event_details));
}
