public int AddShow(ShowLite sl) { int result = 1; Show s = new Show(); s.VenueKey = sl.VenueKey; s.ShowName = sl.ShowName; s.ShowDate = DateTime.Parse(sl.ShowDate); s.ShowTime = TimeSpan.Parse(sl.ShowTime); s.ShowTicketInfo = sl.ShowTicket; s.ShowDateEntered = DateTime.Now; try { db.Shows.Add(s); db.SaveChanges(); } catch (Exception ex) { result = 0; throw ex; } return(result); }
public int AddShow(ShowLite sl) { int result = 1; Show s = new Show(); var vk = from v in st.Shows where v.Venue.VenueName.Equals(sl.ShowName) select new { v.VenueKey }; s.VenueKey = sl.VenueKey; s.ShowName = sl.ShowName; s.ShowDate = sl.ShowDate; s.ShowTime = sl.ShowTime; s.ShowTicketInfo = sl.ShowTicket; s.ShowDateEntered = DateTime.Now; try { st.Shows.Add(s); st.SaveChanges(); } catch (Exception ex) { result = 0; throw ex; } return(result); }
public int AddShow(ShowLite sl) { int result = 1; sl.VenueKey = 1; Show s = new Show(); var vk = from v in db.Shows where v.Venue.VenueName.Equals(sl.ShowName) select new { v.VenueKey }; s.VenueKey = sl.VenueKey; s.ShowName = sl.ShowName; s.ShowDate = sl.ShowDate; s.ShowTime = sl.ShowTime; s.ShowTicketInfo = sl.ShowTicket; s.ShowDateEntered = DateTime.Now; try { db.Shows.Add(s); db.SaveChanges(); } catch (Exception ex) { result = 0; throw ex; } return result; }
public void ShowAdd(ShowLite sl) { Show s = new Show(); s.ShowName = sl.Title; s.ShowDate = sl.Date; s.ShowDateEntered = DateTime.Now; s.ShowTime = sl.StartTime; s.ShowTicketInfo = sl.TicketInfo; db.Shows.Add(s); db.SaveChanges(); }
public void AddShow(ShowLite sl) { Show s = new Show(); s.ShowName = sl.Name; s.ShowDate = DateTime.Parse(sl.Date); s.ShowTime = TimeSpan.Parse(sl.Time); s.ShowTicketInfo = sl.TicketInfo; s.ShowDateEntered = DateTime.Now; db.Shows.Add(s); db.SaveChanges(); }
public int AddShow(ShowLite s) { Show sho = new Show(); sho.ShowName = s.ShowName; sho.VenueKey = s.VenueKey; sho.ShowDate = s.ShowDate; sho.ShowTime = s.ShowTime; sho.ShowTicketInfo = s.ShowTicketInfo; sho.ShowDateEntered = DateTime.Now; db.Shows.Add(sho); db.SaveChanges(); return 1; }
List <ShowLite> ISelectService.GetArtName(string artistName) { var shws = from s in st.Shows from sd in s.ShowDetails where sd.Artist.ArtistName == artistName select new { s.ShowName, s.ShowTime, s.ShowDate }; List <ShowLite> shwNam = new List <ShowLite>(); foreach (var s in shws) { ShowLite slite = new ShowLite(); slite.ShowDate = s.ShowDate.ToShortDateString(); slite.Showtime = s.ShowTime.ToString(); slite.ShowName = s.ShowName; shwNam.Add(slite); } return(shwNam); }
public List<ShowLite> GetShowByVenue(string venuename) { var shw = from s in st.Shows from sd in s.ShowDetails where sd.Artist.ArtistName.Equals(venuename) select new { s.Venue.VenueName, s.ShowName, s.ShowDateEntered }; List<ShowLite> showbv = new List<ShowLite>(); foreach (var s in shw) { ShowLite slite = new ShowLite(); slite.VenueName = s.VenueName; slite.ShowName = s.ShowName; slite.ShowDate = s.ShowDateEntered.ToString(); showbv.Add(slite); } return showbv; }
public List <ShowLite> GetShowByVenue(string venuename) { var sbv = from s in st.Shows where s.Venue.VenueName.Equals(venuename) select new { s.Venue.VenueName, s.ShowName, s.ShowDate, s.ShowTime }; List <ShowLite> sbvlist = new List <ShowLite>(); foreach (var s in sbv) { ShowLite vlite = new ShowLite(); vlite.ShowName = s.ShowName; vlite.ShowDate = s.ShowDate.ToShortDateString(); vlite.ShowTime = s.ShowTime.ToString(); vlite.VenueName = s.VenueName; sbvlist.Add(vlite); } return(sbvlist); }
public List <ShowLite> GetShowByArtist(string artistname) { var sba = from s in st.Shows from sb in s.ShowDetails where sb.Artist.ArtistName.Equals(artistname) select new { s.Venue.VenueName, s.ShowName, s.ShowDate }; List <ShowLite> sbalist = new List <ShowLite>(); foreach (var s in sba) { ShowLite slite = new ShowLite(); slite.ShowName = s.ShowName; slite.ShowDate = s.ShowDate.ToShortDateString(); slite.VenueName = s.VenueName; sbalist.Add(slite); } return(sbalist); }
public List<ShowLite> GetShowByArtist(string artistname) { var sba = from s in st.Shows from sb in s.ShowDetails where sb.Artist.ArtistName.Equals(artistname) select new { s.Venue.VenueName, s.ShowName, s.ShowDate }; List<ShowLite> sbalist = new List<ShowLite>(); foreach (var s in sba) { ShowLite slite = new ShowLite(); slite.ShowName = s.ShowName; slite.ShowDate = s.ShowDate.ToShortDateString(); slite.VenueName = s.VenueName; sbalist.Add(slite); } return sbalist; }
public List<ShowLite> GetShowsByVenueName(string venueName) { List<ShowLite> shows = new List<ShowLite>(); var show = from s in stde.Shows where s.Venue.VenueName.Equals(venueName) select new { s.ShowName, s.ShowDate, }; foreach (var v in shows) { ShowLite lite = new ShowLite(); lite.ShowName = v.ShowName; lite.ShowDate = v.ShowDate; shows.Add(lite); } return shows; }
public List<ShowLite> GetShowByVenue(string venuename) { var sbv = from s in st.Shows where s.Venue.VenueName.Equals(venuename) select new { s.Venue.VenueName, s.ShowName, s.ShowDate, s.ShowTime }; List<ShowLite> sbvlist = new List<ShowLite>(); foreach (var s in sbv) { ShowLite vlite = new ShowLite(); vlite.ShowName = s.ShowName; vlite.ShowDate = s.ShowDate.ToShortDateString(); vlite.ShowTime = s.ShowTime.ToString(); vlite.VenueName = s.VenueName; sbvlist.Add(vlite); } return sbvlist; }
public int AddShow(ShowLite sl) { int result = 1; Show s = new Show(); s.VenueKey = sl.VenueKey; s.ShowName = sl.ShowName; s.ShowDate = DateTime.Parse(sl.ShowDate); s.ShowTime = TimeSpan.Parse(sl.ShowTime); s.ShowTicketInfo = sl.ShowTicket; s.ShowDateEntered = DateTime.Now; try { db.Shows.Add(s); db.SaveChanges(); } catch(Exception ex) { result = 0; throw ex; } return result; }