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