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