public void Update(Movie movie)
{
using (var conn = new SqlConnection(_ConnectionString))
{
conn.Open();
var helper = new DbHelperSql(conn, 10);
string sql = @"
update Movie
set Genre = @Genre,
Price = @Price,
ReleaseDate = @ReleaseDate,
Title = @Title
where ID = @ID
";
var paramsIn = new SqlParameter[]
{
new SqlParameter("@Genre", movie.Genre),
new SqlParameter("@Price", movie.Price),
new SqlParameter("@ReleaseDate", movie.ReleaseDate),
new SqlParameter("@Title", movie.Title),
new SqlParameter("@ID", movie.Id),
};
int ret = helper.ExecUpdateSql(sql, paramsIn);
}
}
public void Remove(Movie movie)
{
using (var conn = new SqlConnection(_ConnectionString))
{
conn.Open();
var helper = new DbHelperSql(conn);
string sql = @"
delete Movie
where ID = @ID
";
var paramIn = new SqlParameter("@ID", movie.Id);
int ret = helper.ExecUpdateSql(sql, paramIn);
}
}
public void Add(Movie movie)
{
using (var conn = new SqlConnection(_ConnectionString))
{
conn.Open();
var helper = new DbHelperSql(conn);
string sql = @"
insert into Movie
(Genre, Price, ReleaseDate, Title)
values (@Genre, @Price, @ReleaseDate, @Title)
";
var paramsIn = new SqlParameter[]
{
new SqlParameter("@Genre", movie.Genre),
new SqlParameter("@Price", movie.Price),
new SqlParameter("@ReleaseDate", movie.ReleaseDate),
new SqlParameter("@Title", movie.Title),
};
int ret = helper.ExecUpdateSql(sql, paramsIn);
}
}