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