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