public void SaveDvd(Dvds dvd)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("DvdInsert", cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter("@DvdId", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@Title", dvd.Title);
cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear);
cmd.Parameters.AddWithValue("@Director", dvd.Director);
cmd.Parameters.AddWithValue("@Rating", dvd.Rating);
cmd.Parameters.AddWithValue("@Notes", dvd.Notes);
cn.Open();
cmd.ExecuteNonQuery();
dvd.DvdId = (int)param.Value;
}
}
public void EFCanUpdateDvd()
{
var repo = new EFRepository();
var dvds = new Dvds()
{
Title = "Trolls",
ReleaseYear = 2017,
Director = "Disney",
Rating = "G",
Notes = "Colorful and happy movie."
};
repo.SaveDvd(dvds);
dvds.Title = "Trololololololol";
dvds.Rating = "R";
repo.UpdateDvd(dvds);
Assert.AreEqual(2017, dvds.ReleaseYear);
Assert.AreEqual("Trololololololol", dvds.Title);
Assert.AreEqual("R", dvds.Rating);
Assert.AreEqual("Disney", dvds.Director);
Assert.AreEqual(4, dvds.DvdId);
}
public List <Dvds> GetDvdsDirector(string director)
{
List <Dvds> List = new List <Dvds>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GetDvdsDirector", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@director", director);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Dvds currentRow = new Dvds();
currentRow.dvdId = (int)dr["dvdId"];
currentRow.title = dr["title"].ToString();
currentRow.releaseYear = dr["releaseYear"].ToString();
currentRow.director = dr["director"].ToString();
currentRow.rating = dr["rating"].ToString();
currentRow.notes = dr["notes"].ToString();
List.Add(currentRow);
}
}
return(List);
}
}
public void SaveDvd(Dvds dvd)
{
var maxDvdNumber = _listOfDvds.Max(m => m.DvdId);
dvd.DvdId = maxDvdNumber + 1;
_listOfDvds.Add(dvd);
}
public List <Dvds> GetAll()
{
_listOfDvds.Clear();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SelectAllDvds", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Dvds currentRow = new Dvds();
currentRow.DvdId = (int)dr["DvdId"];
currentRow.Title = dr["Title"].ToString();
currentRow.ReleaseYear = (int)dr["ReleaseYear"];
currentRow.Director = dr["Director"].ToString();
currentRow.Rating = dr["Rating"].ToString();
currentRow.Notes = dr["Notes"].ToString();
_listOfDvds.Add(currentRow);
}
}
}
return(_listOfDvds);
}
public Dvds GetDvdId(int dvdId)
{
Dvds dvds = null;
Dvds Dvd = new Dvds();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GetDvdId", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dvdId", dvdId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
dvds = new Dvds();
dvds.dvdId = (int)dr["dvdId"];
dvds.title = dr["title"].ToString();
dvds.releaseYear = dr["releaseYear"].ToString();
dvds.director = dr["director"].ToString();
dvds.rating = dr["rating"].ToString();
dvds.notes = dr["notes"].ToString();
}
}
return(dvds);
}
}
public void UpdateDvd(Dvds dvd)
{
var oldDvd = _listOfDvds.SingleOrDefault(d => d.DvdId == dvd.DvdId);
_listOfDvds.Remove(oldDvd);
_listOfDvds.Add(dvd);
}
public IHttpActionResult displayDVD(int dvdId)
{
// IDvdsRepo repo = GetMode();
Dvds dvd = repo.GetDvdId(dvdId);
return(Ok(dvd));
}
public void SaveDvd(Dvds dvd)
{
using (var ctx = new DvdLibraryEntities())
{
ctx.Dvds.Add(dvd);
ctx.SaveChanges();
}
}
public IHttpActionResult insertDVD(Dvds dvd)
{
// IDvdsRepo repo = GetMode();
repo.PostDvd(dvd);
Dvds newdvd = repo.GetDvdId(dvd.dvdId);
return(Ok(newdvd));
}
public IHttpActionResult editDVDId(Dvds dvd)
{
// IDvdsRepo repo = GetMode();
repo.UpdateDvdId(dvd);
Dvds newdvd = repo.GetDvdId(dvd.dvdId);
return(Ok(newdvd));
}
public void UpdateDvd(Dvds dvd)
{
using (var ctx = new DvdLibraryEntities())
{
var updateThis = ctx.Dvds.SingleOrDefault(d => d.DvdId == dvd.DvdId);
updateThis.Title = dvd.Title;
updateThis.ReleaseYear = dvd.ReleaseYear;
updateThis.Director = dvd.Director;
updateThis.Rating = dvd.Rating;
updateThis.Notes = dvd.Notes;
ctx.SaveChanges();
}
}
public Dvds GetDvdId(int dvdId)
{
Dvds dvd = new Dvds();
if (dvdId == 1)
{
dvd.dvdId = 1;
dvd.title = "A Great Tale";
dvd.releaseYear = "2015";
dvd.director = "Sam Jones";
dvd.rating = "PG";
dvd.notes = "X";
}
return(dvd);
}
public void PostDvd(Dvds dvd)
{
using (SqlConnection cn = new SqlConnection(Settings.GetConnectionString()))
{
var parameters = new DynamicParameters();
parameters.Add("@dvdId", dvd.dvdId);
parameters.Add("@title", dvd.title);
parameters.Add("@releaseYear", dvd.releaseYear);
parameters.Add("@director", dvd.director);
parameters.Add("@rating", dvd.rating);
parameters.Add("@notes", dvd.notes);
cn.Execute("PostDvd", parameters, commandType: CommandType.StoredProcedure);
}
}
public void UpdateDvd(Dvds dvd)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("DvdUpdate", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DvdId", dvd.DvdId);
cmd.Parameters.AddWithValue("@Title", dvd.Title);
cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear);
cmd.Parameters.AddWithValue("@Director", dvd.Director);
cmd.Parameters.AddWithValue("@Rating", dvd.Rating);
cmd.Parameters.AddWithValue("@Notes", dvd.Notes);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public void UpdateDvdId(Dvds dvd)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("UpdateDvdId", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dvdId", dvd.dvdId);
cmd.Parameters.AddWithValue("@title", dvd.title);
cmd.Parameters.AddWithValue("@releaseYear", dvd.releaseYear);
cmd.Parameters.AddWithValue("@director", dvd.director);
cmd.Parameters.AddWithValue("@rating", dvd.rating);
cmd.Parameters.AddWithValue("@notes", dvd.notes);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public void PostDvd(Dvds dvd)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("PostDvd", 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("@title", dvd.title);
cmd.Parameters.AddWithValue("@releaseYear", dvd.releaseYear);
cmd.Parameters.AddWithValue("@director", dvd.director);
cmd.Parameters.AddWithValue("@rating", dvd.rating);
cmd.Parameters.AddWithValue("@notes", dvd.notes);
cn.Open();
cmd.ExecuteNonQuery();
dvd.dvdId = (int)param.Value;
}
}
public void UpdateDvdId(Dvds dvd)
{
throw new NotImplementedException();
}
public void PostDvd(Dvds dvd)
{
throw new NotImplementedException();
}
public IHttpActionResult AddDvd(Dvds dvd)
{
_dvdRepository.SaveDvd(dvd);
return(Created($"dvd/{dvd.DvdId}", dvd));
}
public void EditDvd(int dvdId, Dvds dvd)
{
_dvdRepository.UpdateDvd(dvd);
}
public ActionResult Insert(Dvds dvd)
{
if (ModelState.IsValid)
{
try
{
_repository.Add(dvd);
}
catch (Exception)
{
return RedirectToAction("Index", new { alertMsg = "Erro: Não foi possível Incluir o Registro", alertType = "error" });
}
return RedirectToAction("Index", new { alertMsg = "Incluído", alertType = "success" });
}
return View(dvd);
}
