BLL.Dao.TimelapseDao.UpdateReCreateHlsParams C# (CSharp) Method

        public static bool UpdateReCreateHlsParams(string code, bool reCreateHls, bool startRecreateHls)
        {
            string query = @"UPDATE [dbo].[Timelapses] " +
                           "SET [RecreateHls]=@reCreateHls, [StartRecreateHls]=@startRecreateHls " +
                           "WHERE (Code = '" + code + "')";
            try
            {
                var p1 = new SqlParameter("@reCreateHls", reCreateHls);
                var p2 = new SqlParameter("@startRecreateHls", startRecreateHls);

                var cmd = new SqlCommand { CommandText = query, CommandType = CommandType.Text };
                cmd.Parameters.Add(p1);
                cmd.Parameters.Add(p2);
                Connection.OpenConnection();
                cmd.Connection = Connection.DbConnection;
                bool result = (cmd.ExecuteNonQuery() > 0);
                Connection.CloseConnection();
                cmd.Dispose();
                return result;
            }
            catch (Exception ex)
            {
                Utils.FileLog("TimelapseDao UpdateReCreateHlsParams(string code, bool reCreateHls, bool startRecreateHls) " + ex.Message);
                return false;
            }
            finally
            { Connection.CloseConnection(); }
        }