public void AddShowDetail(ShowDetailLite sdl)
{
ShowDetail sd = new ShowDetail();
sd.ShowDetailArtistStartTime = TimeSpan.Parse(sdl.ArtistStartTime);
sd.ShowDetailAdditional = sdl.Additional;
db.ShowDetails.Add(sd);
db.SaveChanges();
}
public int AddShowDetail(ShowDetailLite sd)
{
ShowDetail sho = new ShowDetail();
sho.ShowKey = sd.Showkey;
sho.ArtistKey = sd.ArtistKey;
sho.ShowDetailArtistStartTime = sd.ShowDetailArtistStartTime;
sho.ShowDetailAdditional = sd.ShowDetailAdditional;
db.ShowDetails.Add(sho);
db.SaveChanges();
return 1;
}
public int AddShowDetail(ShowDetailLite sdl)
{
int result = 1;
ShowDetail sd = new ShowDetail();
var key = from k in db.Artists
where k.ArtistName.Equals(sdl.ArtistName)
select new { k.ArtistKey };
int AKey = 0;
foreach (var k in key)
{
AKey = (int)k.ArtistKey;
}
var kkey = from kk in db.Shows
where kk.ShowName.Equals(sdl.ShowName)
select new { kk.ShowKey };
int SKey = 0;
foreach (var kk in kkey)
{
SKey = (int)kk.ShowKey;
}
sd.ArtistKey = AKey;
sd.ShowDetailArtistStartTime = TimeSpan.Parse(sdl.ArtistStartTime);
sd.ShowDetailAdditional = sdl.Note;
sd.ShowKey = SKey;
try
{
db.ShowDetails.Add(sd);
db.SaveChanges();
}
catch (Exception ex)
{
result = 0;
throw ex;
}
return(result);
}
public void ShowDetailAdd(ShowDetailLite sl)
{
var skey = from s in db.Shows
where s.ShowName.Equals(sl.Title)
select new { s.ShowKey };
int key = 0;
foreach (var k in skey)
{
key = (int)k.ShowKey;
}
ShowDetail sh = new ShowDetail();
sh.ShowDetailArtistStartTime = sl.StartTime;
sh.ShowDetailAdditional = sl.Additional;
sh.ShowKey = key;
db.ShowDetails.Add(sh);
db.SaveChanges();
}
List <ShowDetailLite> ISelectService.GetShowDetail(string showDetail)
{
var shwDet = from b in st.Artists
from s in b.ShowDetails
where s.Show.ShowName == showDetail
select new { s.Show.Venue.VenueName, b.ArtistName, s.Show.ShowName };
List <ShowDetailLite> shwShoDet = new List <ShowDetailLite>();
foreach (var s in shwDet)
{
ShowDetailLite sdlite = new ShowDetailLite();
sdlite.VenueName = s.VenueName;
sdlite.ArtistName = s.ArtistName;
sdlite.ShowName = s.ShowName;
shwShoDet.Add(sdlite);
}
return(shwShoDet);
}
public int AddShowDetail(ShowDetailLite sdl)
{
int result = 1;
ShowDetail sd = new ShowDetail();
var key = from k in db.Artists
where k.ArtistName.Equals(sdl.ArtistName)
select new { k.ArtistKey };
int AKey = 0;
foreach (var k in key)
{
AKey = (int)k.ArtistKey;
}
var kkey = from kk in db.Shows
where kk.ShowName.Equals(sdl.ShowName)
select new { kk.ShowKey };
int SKey = 0;
foreach (var kk in kkey)
{
SKey = (int)kk.ShowKey;
}
sd.ArtistKey = AKey;
sd.ShowDetailArtistStartTime = TimeSpan.Parse(sdl.ArtistStartTime);
sd.ShowDetailAdditional = sdl.Note;
sd.ShowKey = SKey;
try
{
db.ShowDetails.Add(sd);
db.SaveChanges();
}
catch (Exception ex)
{
result = 0;
throw ex;
}
return result;
}
