public void DvdCreate(Dvd dvd)
{
using (var cn = new SqlConnection())
{
cn.ConnectionString = ConfigurationManager.ConnectionStrings["DVDLibrary"].ConnectionString;
var parameters = new DynamicParameters();
parameters.Add("@dvdId", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@title", dvd.title);
parameters.Add("@director", dvd.director);
parameters.Add("@rating", dvd.rating);
parameters.Add("@realeaseYear", dvd.realeaseYear);
parameters.Add("@notes", dvd.notes);
cn.Execute("DvdInsert", parameters, commandType: CommandType.StoredProcedure);
dvd.dvdId = parameters.Get <int>("@dvdId");
}
}
public void DvdEdit(int dvdId, Dvd dvd)
{
using (var cn = new SqlConnection())
{
cn.ConnectionString = ConfigurationManager.ConnectionStrings["DVDLibrary"].ConnectionString;
//var parameters = new DynamicParameters();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "DvdUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dvdId", dvdId);
cmd.Parameters.AddWithValue("@title", dvd.title);
cmd.Parameters.AddWithValue("@director", dvd.director);
cmd.Parameters.AddWithValue("@rating", dvd.rating);
cmd.Parameters.AddWithValue("@realeaseYear", dvd.realeaseYear);
cmd.Parameters.AddWithValue("@notes", dvd.notes);
cmd.Connection = cn;
cn.Open();
cmd.ExecuteNonQuery();
//cn.Execute("DvdUpdate", parameters, commandType: CommandType.StoredProcedure);
}
}
public void DvdEdit(Dvd dvd)
{
_dvds.RemoveAll(d => d.dvdId == dvd.dvdId);
_dvds.Add(dvd);
}
public void DvdEdit(Dvd dvd)
{
throw new NotImplementedException();
}
public void DvdCreate(Dvd dvd)
{
throw new NotImplementedException();
}
