public List <GetDvds> GetAllDvd() { List <GetDvds> dvds = new List <GetDvds>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetAll", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { GetDvds row = new GetDvds(); row.DvdId = (int)dr["DvdId"]; row.Title = dr["Title"].ToString(); row.ReleaseYear = (int)dr["ReleaseYear"]; row.Director = dr["DirectorName"].ToString(); row.Rating = dr["RatingName"].ToString(); row.Notes = dr["Notes"].ToString(); dvds.Add(row); } } } return(dvds); }
public GetDvds GetById(int dvdId) { GetDvds dvd = new GetDvds(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetById", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DvdId", dvdId); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { GetDvds row = new GetDvds(); row.DvdId = (int)dr["DvdId"]; row.Title = dr["Title"].ToString(); row.ReleaseYear = (int)dr["ReleaseYear"]; row.Director = dr["DirectorName"].ToString(); row.Rating = dr["RatingName"].ToString(); row.Notes = dr["Notes"].ToString(); return(row); } } return(null); } }
public IHttpActionResult UpdateDvd(GetDvds dvd) { var repo = DvdRepositoryFactory.GetRepository(); repo.Edit(dvd.DvdId, dvd.Title, dvd.ReleaseYear, dvd.Director, dvd.Rating, dvd.Notes); return(Ok()); }
public IHttpActionResult NewDvd(GetDvds dvd) { var repo = DvdRepositoryFactory.GetRepository(); repo.SaveNew(dvd.Title, dvd.ReleaseYear, dvd.Director, dvd.Rating, dvd.Notes); return(Ok()); }
public GetDvds GetById(int dvdId) { GetDvds dvd = new GetDvds(); Dvd getDvdInfo = _dvd.FirstOrDefault(x => x.DvdId == dvdId); dvd.DvdId = dvdId; dvd.Title = getDvdInfo.Title; dvd.ReleaseYear = getDvdInfo.ReleaseYear; dvd.Director = getDvdInfo.Director.DirectorName; dvd.Rating = getDvdInfo.Rating.RatingName; dvd.Notes = getDvdInfo.Notes; return(dvd); }
public void EFCanEditDvd() { var repo = new DvdRepositoryEF(); int dvdId = 2; string title = "Edited dvd"; int releaseYear = 1900; string directorName = "Edited director"; string ratingName = "R"; string notes = "This has been edited"; repo.Edit(dvdId, title, releaseYear, directorName, ratingName, notes); GetDvds dvd = repo.GetById(2); Assert.AreEqual(2, dvd.DvdId); Assert.AreEqual(title, dvd.Title); }
public GetDvds GetById(int dvdId) { GetDvds dvd = new GetDvds(); using (DvdCatalogEntities data = new DvdCatalogEntities()) { var getDvd = (from r in data.Dvds.Include("Director").Include("Rating") where r.DvdId == dvdId select r); foreach (var x in getDvd) { dvd.DvdId = x.DvdId; dvd.Title = x.Title; dvd.ReleaseYear = x.ReleaseYear; dvd.Director = x.Director.DirectorName; dvd.Rating = x.Rating.RatingName; dvd.Notes = x.Notes; } } return(dvd); }
public List <GetDvds> GetAllDvd() { List <GetDvds> dvds = new List <GetDvds>(); for (int index = 0; index < _dvd.Count(); index++) { GetDvds dvdGet = new GetDvds(); dvdGet.DvdId = _dvd[index].DvdId; dvdGet.Title = _dvd[index].Title; dvdGet.ReleaseYear = _dvd[index].ReleaseYear; dvdGet.Director = _dvd[index].Director.DirectorName; dvdGet.Rating = _dvd[index].Rating.RatingName; dvdGet.Notes = _dvd[index].Notes; dvds.Add(dvdGet); } return(dvds); }
public List <GetDvds> GetByDirector(string directorName) { List <GetDvds> dvds = new List <GetDvds>(); using (DvdCatalogEntities data = new DvdCatalogEntities()) { var getByDirector = (from r in data.Dvds.Include("Director").Include("Rating") where r.Director.DirectorName == directorName select r); foreach (var x in getByDirector) { GetDvds dvd = new GetDvds(); dvd.DvdId = x.DvdId; dvd.Title = x.Title; dvd.ReleaseYear = x.ReleaseYear; dvd.Director = x.Director.DirectorName; dvd.Rating = x.Rating.RatingName; dvd.Notes = x.Notes; dvds.Add(dvd); } } return(dvds); }
public List <GetDvds> GetByRating(string rating) { List <GetDvds> dvds = new List <GetDvds>(); foreach (var x in _dvd) { if (x.Rating.RatingName == rating) { GetDvds dvd = new GetDvds(); dvd.DvdId = x.DvdId; dvd.Title = x.Title; dvd.ReleaseYear = x.ReleaseYear; dvd.Director = x.Director.DirectorName; dvd.Rating = x.Rating.RatingName; dvd.Notes = x.Notes; dvds.Add(dvd); } } return(dvds); }