public void InsertDVD(DVDListView dvdListView) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { List <DVDListView> dvds = AllDVD(); DVD dvd = new DVD() { DVDID = dvds.Count() - 1, DVDTitle = dvdListView.dvdTitle, Director = dvdListView.director, ReleaseYear = dvdListView.releaseYear, Notes = dvdListView.notes }; dvd.RatingID = GetIdFromRating(dvdListView.rating); SqlCommand cmd = new SqlCommand("InsertDVD", cn); cmd.Connection = cn; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@DVDID", SqlDbType.Int); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@RatingID", dvd.RatingID); cmd.Parameters.AddWithValue("@Director", dvd.Director); cmd.Parameters.AddWithValue("@DVDTitle", dvd.DVDTitle); cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear); cmd.Parameters.AddWithValue("@Notes", dvd.Notes); cn.Open(); cmd.ExecuteNonQuery(); } }
public void UpdateDVD(DVDListView dvdListView) { DVD dvd = new DVD() { DVDID = dvdListView.dvdId, DVDTitle = dvdListView.dvdTitle, Director = dvdListView.director, ReleaseYear = dvdListView.releaseYear, Notes = dvdListView.notes }; dvd.RatingID = GetIdFromRating(dvdListView.rating); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("UpdateDVD", cn); cmd.Connection = cn; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@DVDID", dvd.DVDID); cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@RatingId", dvd.RatingID); cmd.Parameters.AddWithValue("@Director", dvd.Director); cmd.Parameters.AddWithValue("@DVDTitle", dvd.DVDTitle); cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear); cmd.Parameters.AddWithValue("@Notes", dvd.Notes); cn.Open(); cmd.ExecuteNonQuery(); } }
public IHttpActionResult InsertDVD(DVDListView dvdListView) { var repo = DVDRepositoryFactory.GetRepository(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } repo.InsertDVD(dvdListView); return(Created($"dvds/get/{dvdListView.dvdId}", dvdListView)); }
public void UpdateDVD(DVDListView dvdListView) { DVD dvd = new DVD() { DVDID = dvdListView.dvdId, Director = dvdListView.director, DVDTitle = dvdListView.dvdTitle, ReleaseYear = dvdListView.releaseYear, Notes = dvdListView.notes }; dvd.RatingID = GetIdFromRating(dvdListView.rating); _dvds[dvd.DVDID] = dvd; }
public void InsertDVD(DVDListView dvdListView) { DVD dvd = new DVD() { DVDID = dvdListView.dvdId, Director = dvdListView.director, DVDTitle = dvdListView.dvdTitle, ReleaseYear = dvdListView.releaseYear, Notes = dvdListView.notes }; dvd.RatingID = GetIdFromRating(dvdListView.rating); _dvds.Add(dvd); }
public IHttpActionResult GetDVDById(int dvdid) { var repo = DVDRepositoryFactory.GetRepository(); try { DVDListView dvdList = repo.DVDByID(dvdid); return(Ok(dvdList)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public void UpdateDVD(DVDListView dvdListView) { var repo = DVDRepositoryFactory.GetRepository(); repo.UpdateDVD(dvdListView); }