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