public IEnumerable <DVDDetailView> FindByTitle(string title) { List <DVDDetailView> FinalResult = new List <DVDDetailView>(); DVDLibraryEntities Libris = new DVDLibraryEntities(); var results = from d in Libris.DVDs where d.Title.Contains(title) select d; foreach (DVD r in results) { DVDDetailView current = new DVDDetailView(); current.DVDID = r.DVDID; current.Title = r.Title; current.Director = r.Director; current.RatingID = r.RatingID; current.RatingName = r.Rating.RatingName; current.realeaseYear = r.realeaseYear; current.realeaseYear = r.realeaseYear; if (Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes != null) { current.Note = Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes; } FinalResult.Add(current); } return(FinalResult); }
public DVDDetailView GetByID(int ID) //works { DVDLibraryEntities Libris = new DVDLibraryEntities(); DVD result = Libris.DVDs.Where(d => d.DVDID == ID).FirstOrDefault(); if (Libris.Notes.Where(n => n.DVDID == ID).FirstOrDefault().Notes == null) { result.Note = "no note"; } else { result.Note = Libris.Notes.Where(n => n.DVDID == ID).FirstOrDefault().Notes; } DVDDetailView Selected = new DVDDetailView { DVDID = result.DVDID, Director = result.Director, RatingName = result.Rating.RatingName, RatingID = result.RatingID, realeaseYear = result.realeaseYear, Title = result.Title, Note = result.Note }; return(Selected); }
public IEnumerable <DVDDetailView> FindbyYear(int year) { List <DVDDetailView> FinalResult = new List <DVDDetailView>(); DVDLibraryEntities Libris = new DVDLibraryEntities(); var results = from d in Libris.DVDs where d.realeaseYear == year select d; foreach (DVD r in results) { DVDDetailView current = new DVDDetailView(); current.DVDID = r.DVDID; current.Title = r.Title; current.Director = r.Director; current.RatingID = r.RatingID; current.RatingName = r.Rating.RatingName; current.realeaseYear = r.realeaseYear; if (!string.IsNullOrEmpty(Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes)) { current.Note = Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes; } FinalResult.Add(current); } return(FinalResult); }
public IEnumerable <DVDDetailView> FindByTitle(string title) { List <DVDDetailView> results = new List <DVDDetailView>(); using (SqlConnection cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetDVDsByTitle", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Title", title); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { DVDDetailView current = new DVDDetailView(); current.DVDID = (int)dr["DVDID"]; current.Title = dr["Title"].ToString(); current.Director = dr["Director"].ToString(); current.RatingID = (int)dr["RatingID"]; current.RatingName = dr["RatingName"].ToString(); current.realeaseYear = (int)dr["realeaseYear"]; current.Note = dr["Note"].ToString(); results.Add(current); } } } return(results); }
public DVDDetailView GetByID(int ID) { DVDDetailView Selected = null; using (SqlConnection cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("SelectByDVDID", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DVDID", ID); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { Selected = new DVDDetailView(); Selected.DVDID = (int)dr["DVDID"]; Selected.Title = dr["Title"].ToString(); Selected.Director = dr["Director"].ToString(); Selected.RatingID = (int)dr["RatingID"]; Selected.RatingName = dr["RatingName"].ToString(); Selected.realeaseYear = (int)dr["realeaseYear"]; Selected.Note = dr["Note"].ToString(); } } } return(Selected); }
public DVDDetailView GetByID(int id) { DVD result = _DVDs.Where(d => d.DVDID == id).FirstOrDefault(); DVDDetailView Selected = new DVDDetailView { DVDID = result.DVDID, Director = result.Director, RatingName = result.Rating.RatingName, RatingID = result.RatingID, realeaseYear = result.realeaseYear, Title = result.Title, Note = result.Note }; return(Selected); }