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)); }