public void DvdEdit(DvdVM dvd)
{
using (var cn = new SqlConnection())
{
cn.ConnectionString = ConfigurationManager.ConnectionStrings["DVDLibrary"].ConnectionString;
var parameters = new DynamicParameters();
parameters.Add("@dvdId", dvd.dvdId);
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("DvdUpdate", parameters, commandType: CommandType.StoredProcedure);
}
}
public void DvdInsert(DvdVM 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");
}
}